TempDB

SQL Server Setup & Upgrade

Index ‹ SQL Server

- Previous
  - 1
    - Can I create a database schema from a DataSet and/or .xsd file? I have some questions about creating SQL Server CE databases. Based on my experiments and what I've read on these forums, it looks like there are a couple ways to create a database schema. I can edit the database schema via the Server Explorer in Visual Studio, or use an external program like SQL Server Management Studio and somehow convert those files to .sdf files. I find Visual Studio's built in tools to be cumbersome to use and limited in functionality, and using SSMS seems like a roundabout way of approaching the problem. I understand Microsoft will be releasing better tools with Orcas, but in the meantime, I'm wondering if there are alternative ways to generate database schemas. For instance, I find Visual Studio's DataSet designer fairly easy to use. The DataSet designer generates schema definitions (.xsd files), and an instantiated DataSet can both read and write schema definitions via Read/WriteXMLSchema. Furthermore, DataAdapter's Fill and FillSchema methods can be used to push a schema from a database to a DataSet. So, can I somehow go the other direction and push a schema from a DataSet to a database It seems like all the tools are there... For example, if I create the DataSet schema, could I use a small app to create a new .sdf file, instantiate a DataSet, write the schema from the DataSet to the database, and then save the .sdf file Or given the generated .xsd file, is there any way to create a SQL database from that Thanks in advance for any replies. Tag: TempDB
  - 2
    - Can't reinstall sql server 2005 express Hi I installed SQL server 2005 Express and it was successfully set up but I kept on getting error 26 when I try to connect to a database, so I remove all SQL programs from the control panel and reinstall SQL server 2005, but this time the set up stopped halfway saying "cannot start server". How can I successfully reinstall SQL server 2005 express Tag: TempDB
  - 3
    - How to protect my parameters Hello. I have a report with parameter called "parm1", that gets a value of "true" or "false" depanding on another parameter. When the report is runnig the parm1 value is "false". How can I protect this parameter from a change by the user I mean - the user can run the report and then add to the url "&param1 = true". Can I do anything against that I tried marking it as "internal" and I thought that now it can get his value only from inside the report but it didn't worked. Any ideas Thanks. Tag: TempDB
  - 4
    - Check to see if file exist on server Hi Folks, I'm attempting to check to see if a file exists on our server before showing a link it. I put this function in the Report Properties: Code Block Function isFile(PathFileName As String) As Boolean Return isFile = System.IO.FileExists(PathFileName) End Function I chose a situation where I'm getting back two rows of data, one row is true and the other row is false however, when I run the report they're both coming back as 'True'. We created a virtual directory to the file system that houses our files, so my PathFileName variable will contain something like http://Sales/North/Sales110907.pdf . Can I use the FileExists in this fashion or am I going down the wrong path I appreciate any help you can give. Best regards, Tag: TempDB
  - 5
    - error hi i have one varchar field i m convarting that field to datetime in format of dd/mm/yyyy but i m getting eror select top 30000 CMS_Upload_Details_ID,Scheme_Code,DrCr, convert(varchar(10),cast(AdditionalField5 as datetime),103) 'ValDate' ,AdditionalField13 'dept_slip',AdditionalField14 'dept_dt',Cheque_No 'Instrm_No',Amount,CONVERT (varchar(11),Instrm_Date,103)Instrm_Date ,AdditionalField21 'Drawer Name' from Tbl_CMS_UploadDetails with(nolock) where Compare_Status='Pending' and ltrim(rtrim(CMS_Upload_Details_ID)) not in (select top 0 ltrim(rtrim(CMS_Upload_Details_ID)) from Tbl_CMS_UploadDetails with(nolock) where Compare_Status = 'Pending ' and Format_ID =83)and Compare_Status='Pending' and Format_ID =83 error is Server: Msg 242, Level 16, State 3, Line 1 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. Tag: TempDB
  - 6
    - Formating how to format an integer in sql 2005 for ex: 1.09876 i want to format to 1.1 in access i can use : format(field,'0.0') as field1 thanks Tag: TempDB
  - 7
    - sql cluster - fulltext error We have a sql server 2000 active/passive cluster running on Windows Server 2003 and within the last 6 months have started getting the following errors which eventually cause the SQL Resource Group to failover. An error occurred in the configuration monitor for instance <SQL Server Fulltext>: 80070005 - Access is denied . SQL is at the latest service pack/hotfixes. (8.00.2187) This cluster has been running fine for the past 3 years with no problems. Nothing has changed on the servers. We've had Symantic Antivirus running on the servers for a long time but the FTDATA folder and the sql data and transaction logs are excluded and nothing has changed on the configuration. We also run Diskeeper 2007 server on these servers but I can't see any problems with this. Once it fails over it will run fine for several days and then the same errors will occur and it fails over again. Any ideas on what might be causing this I can't really find anything on the Microsoft site that matches this error. Note: This has also just started happening on our test cluster which is an identical configuration. Tag: TempDB
  - 8
    - MSSQLServerOLAPService Stops MSSQLServerOLAPService Service seems to crash rather sporadically during our nightly ETL with the error of: The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured. Internal error: An unexpected exception occured.. The time of the error in the event viewer seems to correspond with the step in the ETL that processes our AS 2005 database (Analysis Services Command Task). The job step reports success, and the data is refreshed so I don't understand why it is reporting an error in Event Viewer. The server is x86 with SQL 2005 sp2 installed. Has anyone else run across this Tag: TempDB
  - 9
    - How to Add Subscription or Subscribers manually through scripts instead of programming Hello everyone, I am new for SQL SERVER 2005 NS. I have gone through some samples about NS. Most of them add subscriptions and subscribers through vbs or .net application. So I got some questions to ask for your help: 1. I just wonder if there are some ways for me to add subscriptions and subscribers manually through T-SQL scripts instead of programming. Because sometimes, we don't need to ask our users to subscribe our message. 2. Is that possible for NS to send notification by SMTP without adding subscription For example, I have already populated all emails from database, what I need is just to send simple notes to these emails, and at this time, I don't need users to subscribe them. I just need to get NS works as database mail at this point - only send email notification without subscription. I am not sure if this is possible. ( I know with databse mail, this can be done easily, how about with SQL NS, any idea ) Would you please give me some advices I appreciate your help in advance. Best Regards, Tag: TempDB
  - 10
    - Retrieving a datetime with a time of midnight (from a typical datetime) Nothing difficult, I just need a way to generate a new datetime column based on the column [PostedDate], datetime. So basically I want to truncate the time. Thanks a lot. Tag: TempDB
  - 11
    - Reporting Services Date Format Problem I have a huge problem with reporting services.. For any reports I am running it interprets all of my dates as US format. for instance I'm using the following code snippet to specify the date range of a report CAST(@FromYear + '-01-' + @FromMonth AS DATETIME) AS froom MIN(allpartmaster.snlcat) AS cat, DATEADD(dd, - 1, DATEADD(mm, 1, CAST(@ToYear + '-01-' + @ToMonth AS DATETIME))) AS toooo these are then used to not only limit the sql statement's return set but also as labels on the report for clairfication. parameters are of string type but are passed the likes of @FromMonth = '06' @FromYear = '2006' @ToMonth = '03' @ToYear = '2007' Now I run the report on my developemtn machine with out any problems the above returns froom = '01/06/2006' the 1st of june 2006 toooo = '31/03/2007' the 31st of March 2006 now when the report is deployed and run on the server the above returns froom = '06/01/2006' 6th of January 2006 toooo = '02/02/2007' 2nd of Feb 2007 so the dates are being displayed in the correct format for what they are.. but the actual processing of the reports on the report server is flipping them to US format initially and then back to UK format to display them. I'm at a loss to understand why.. my browser's language settings are UK and my server's windows regional settings at UK as well... does anyone have any ideas as to why this is happening Tag: TempDB
  - 12
    - Shared SSIS Staging/Dev environment We are in the process of setting up a shared staging/development enviroment in which multiple developers will deploy their packages for testing etc. The plan is to allow the developers to remote in to execute their packages, but we are worried about the concurrency limit of 2 users per terminal services. It is my understanding that you cannot execute packages remotely (ie you have to be on THAT box to kick it off. (FYI - we are not planning on using SQL Agent at this point - That will be with DBAs in UA) Please let me know what options are available/best practices... Thanks! Tag: TempDB
  - 13
    - Control Result of ExecuteScalar The user is calling a Stored Procedure with ExecuteScalar. When the SQL doesn't find a match, I'd like to return the results of a different SQL. For Example: If this doesn't find a match: select amount from Lookup Where application = @app Then I'd like to return: select amount from Lookup Where application = "DEFAULT" My actual situation is more complex than this. The first SQL is in a CASE statement. After my CASE is done, can I check the current ExecuteScalar return value Or someone determine how many records are in the last SQL to execute Also, ExecuteScalar always seems to get the 1st column of the 1st query. Can I have it get the 1st column from the 3rd query Tag: TempDB
  - 14
    - Remote Source and Destination Performance Given the following scenario, what kind of performance should be expected in transferring about half a million rows We are seeing about a 9 minute execution time. Is this reasonable for about 460,000 records moving from source to target, with 3 inner joins from the source Source: Server A.OLTPDB Target: ServerA.DataMartDB Server A is running SQL Server 2000. SSIS is running on a different machine, Server B. The reason for this is that we are distributing the SSIS package for use with a BI product built on SSAS 2005 and the requirements are such that the client could very well have the source OLTP database on a different physical machine than the data mart. My understanding is therefore that: 1. SSIS will do all of the heavy lifting on Server B. 2. Even though OLTPDB and DataMartDB are on the same server, it is expensive for Server B to pull the records from Server A and then send them back to Server B, but with SSIS being on a different machine, this is inevitable. 3. In the OLE DB Source Adapter, specifying table or view has the effect of an OPEN QUERY command, whereas a SQL command with straight SQL will be executed on Server B and the former would be somewhat more performant. Can you guys validate/dispel these assumptions TIA, Rick Tag: TempDB
  - 15
    - SSRS 2005 & Number of concurrent users Hi, In one CPU installation of SSRS 2005, are there any restriction on number of users accessing the same concurrently Please let me know. Regards, TNR Tag: TempDB
  - 16
    - Problem with OPENROWSET Hi! I'm using OPENROWSET to import data from an excel file into a MS SQL table.I got it to work.....Now,my problem is that not all the data from the SQL table is imported and some values are different than the ones in the excel file. For example,in the excel file,I have the value:87987845.In the SQL table,the value is:8.79878e+007.Any idea on what causes this Tag: TempDB
- Next
  - 1
    - Dimension Writeback I am interested in using the Dimension Writeback feature to solve a specific problem in a forecasting application. I only need to Update attribute values on existing dimension members, I don't need to insert or delete members. Looking at various resources on the web, I think I understand the following ... - I must be using the Enterprise version of SQL Server / SSAS - I need to write enable the relevant dimension from within my development environment - My users need to be using an OLAP Client which supports dimension writeback. Some questions ... - Is my understanding above correct - Do the following OLAP clients support dimension writeback --- Excel 2007 Pivot Tables --- Excel Services running within Sharepoint 2007 --- If not, can someone point me towards a client which does support dimension writeback - Is there any way to experiment with this feature without having an Enterprise edition SQL Server setup Thanks Marcus Tag: TempDB
  - 2
    - Replication: periodic initial snapshot not yet available I have a push subscriprion (publisher sql2000, distributor 2005, subscriber sql2005) that periodically (twice per month) changes it's status to " ... initial snapshot not yet available ...". Then I need to mark it as for reinitialization and start the snapshot agent (starting the snapshot agent without marking it for reinitilization doesn't starts the subscription to initilize itself). There is nothing important in the logs. Any suggestion why this may happen The network connections between distributor and subscribers sometimes are broken (it's over VPN), but there is a couple of other replication that goes the same way and they are fine... Tag: TempDB
  - 3
    - Big problem I've write an application for testing RDA Syncronization When i try to connect to SQL Server 2005 Express for rda pull i've an error: The version of the Microsoft OLE Db Provider for SQL server is not connect. Install MDAC 2.8 or later. [600,version = ] I've Windows Vista, Visual Studio 2005 Sp1 + Sp for Vista, Sql Express 2005, SQL Compact Edition (SQL CE 3.1). I've write private string rdaOleDbConnectString = @"Provider=sqloledb.1;Data Source=192.168.1.63,1433;Initial Catalog=GestioneClientiSQL;User Id=sa;Password=pippobaudo;" ; private string rdaUrl = @"http://192.168.1.63/sqlce/sqlcesa30.dll" ; private string localConnection = @"Data Source=\My Documents\Archivio.sdf" ; How can solve my problem Raffaele Tag: TempDB
  - 4
    - Exactly-Once-On-Order - conversation group question Hi, A SSB newbie question: Looking in a various resources, i see that a conversation group guarantees receiving messages EOID, which means that each message will be received only once, and that messages will be received in the order they were sent. However, the documentation explicitly states that only dialogs guarantee messages order. So, I��m a little bit confused, what's the "In-Order" stand for in "Exactly Once In Order" Thanks, Ido Tag: TempDB
  - 5
    - SSIS Package Challenge!!! Hi All, Need to accomplish this in SSIS...if someone can point me the flow tips or how to proceed would sincerely appreciate it. The OwnerRecord_1 owns RecordA and RecordB....and so on...the owner record follows the details records Flat File Input RecordA........... RecordB.................. OwnerRecord_1 RecordC................. RecordD................. OwnerRecord_2 .............. Output Solution: TableA ID Records OwnerID 1 RecordA 7 2 RecordB 7 3 RecordC 8 4 RecordD 8 TableB OwnerID Desc: 7 OwnerRecord_1 8 OwnerRecord_2 TIA Tag: TempDB
  - 6
    - changeing the table name while using transfer sql server object Hi, I am wondering using transfer sql server objects task in a sub-package and feeding tableslist property from the parent package. which works fine. problem : I want to be able to change the name in the fly so if I have TableA I want to copy it for the destination as TableB is there any work arround this just using transfer sql server objects task. Thanks Tag: TempDB
  - 7
    - Inserting data having Japanese Characters(Kanji) in SQL Server 2000 Hi All, I am working on SQL Server 2000 ver 7.0. The Collation set for my Database Server is Latin. I want some way by which i can insert Japanese Characters in Database. Is it related to change the Collation or any other encoding format of database. Suppose the table 'Person' has fields id, Name, city If i enter name in a japanese characters, then while storing it does not recongnises this format. insert into person values(8,' �T','osaka') id name city 8 osaka At the place of name ' ' is displayed. Please sugggest me a solution for this. Thanks in Advance Manohar Tag: TempDB
  - 8
    - Inserting on Partitioned View Hello, I'm trying to insert on a partitioned view and I get this error: INSERT INTO dbo.TREP_NOVEDADES ( NMSEC_NOVEDAD, CDCONCEPTO, CDTIPO_VALOR, CDPRECIO, CDTIP_HECT_DTO_PAG, FEGENERACION, FEPAGO_COBRO, CDMETODO_DISTRIBUC, CDTIPO_DCTO_PAGO, VRDESCUENTO_PAGO, SNTERCERO, CDCLASE_NOVEDAD, CDENTIDAD, CDESTADO, CDCAUSA, NMSEC_PREFIJO, SNPAGO_CAJA, SNVAL_PROPOR_PESO, CDTIP_HECT_DISTRIB, CDMONEDA, CDCOMPANIA, NMSEC_NOVEDAD_PADR, SNGENERADA, POEMBARGO, CDTERCERO, CDCIA_TERCERO, NMSEM_GENERACION, NMANO_GENERACION, NMPER_GENERACION, NMSEM_PAGOCOBRO, NMANO_PAGOCOBRO, NMPER_PAGOCOBRO, CDTERCERO_CAJA, CDSUCURSAL_CAJA, CDCOMPANIA_CAJA) VALUES ( 3904, 'C01', 'V', null, null, GETDATE(), GETDATE(), null, null, 25999, 'N', 'F', '016', '01', '000001', null, 'N', 'N', null, 'PESOC', '01', null, 'N', null, null, null, null, 2007, null, null, null, null, null, null, null) Server: Msg 4436, Level 16, State 12, Line 1 UNION ALL view 'TREP_NOVEDADES' is not updatable because a partitioning column was not found. ------------------------------- This is the tables information: CREATE TABLE [dbo].[TREP_NOVEDADES_2006] ( [NMSEC_NOVEDAD] [numeric](12, 0) NOT NULL , [CDCONCEPTO] [varchar] (12) NOT NULL , [CDTIPO_VALOR] [char] (1) NULL , [CDPRECIO] [varchar] (12) NULL , [CDTIP_HECT_DTO_PAG] [varchar] (2) NULL , [FEGENERACION] [datetime] NOT NULL , [FEPAGO_COBRO] [datetime] NULL , [CDMETODO_DISTRIBUC] [char] (1) NULL , [CDTIPO_DCTO_PAGO] [char] (1) NULL , [VRDESCUENTO_PAGO] [numeric](18, 5) NULL , [SNTERCERO] [char] (1) NOT NULL , [CDCLASE_NOVEDAD] [char] (1) NOT NULL , [CDENTIDAD] [varchar] (3) NOT NULL , [CDESTADO] [varchar] (2) NOT NULL , [CDCAUSA] [varchar] (6) NOT NULL , [NMSEC_PREFIJO] [numeric](12, 0) NULL , [SNPAGO_CAJA] [char] (1) NOT NULL , [SNVAL_PROPOR_PESO] [char] (1) NOT NULL , [CDTIP_HECT_DISTRIB] [varchar] (2) NULL , [CDMONEDA] [varchar] (5) NOT NULL , [CDCOMPANIA] [varchar] (2) NOT NULL , [NMSEC_NOVEDAD_PADR] [numeric](12, 0) NULL , [SNGENERADA] [char] (1) NOT NULL , [POEMBARGO] [decimal](7, 4) NULL , [CDTERCERO] [varchar] (15) NULL , [CDCIA_TERCERO] [varchar] (2) NULL , [NMSEM_GENERACION] [tinyint] NULL , [NMANO_GENERACION] [smallint] NULL , [NMPER_GENERACION] [numeric](6, 0) NULL , [NMSEM_PAGOCOBRO] [tinyint] NULL , [NMANO_PAGOCOBRO] [smallint] NULL , [NMPER_PAGOCOBRO] [numeric](6, 0) NULL , [CDTERCERO_CAJA] [varchar] (15) NULL , [CDSUCURSAL_CAJA] [varchar] (4) NULL , [CDCOMPANIA_CAJA] [varchar] (2) NULL , [SNGENERAR_TRG] [char] (1) NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[TREP_NOVEDADES_2006] ADD CONSTRAINT [DF__TREP_NOVE__SNGEN2006] DEFAULT ('S') FOR [SNGENERAR_TRG], CONSTRAINT [TREP_NOVEDADES2006_PK] PRIMARY KEY CLUSTERED ( [NMSEC_NOVEDAD] ) ON [PRIMARY] , CONSTRAINT [TREP_NOVEDADES_2006_NMANOGENER_CK] CHECK ([NMANO_GENERACION] <= 2006), CONSTRAINT [TREP_NOVEDADES_CDMET_DIST2006_CK] CHECK ([CDMETODO_DISTRIBUC] is null or ([CDMETODO_DISTRIBUC] = 'P' or ([CDMETODO_DISTRIBUC] = 'I' or ([CDMETODO_DISTRIBUC] = 'H' or ([CDMETODO_DISTRIBUC] = 'C' or [CDMETODO_DISTRIBUC] = 'D'))))), CONSTRAINT [TREP_NOVEDADES_CDTIP_DCTO2006_CK] CHECK ([CDTIPO_DCTO_PAGO] is null or ([CDTIPO_DCTO_PAGO] = 'H' or ([CDTIPO_DCTO_PAGO] = 'C' or [CDTIPO_DCTO_PAGO] = 'A'))), CONSTRAINT [TREP_NOVEDADES_CDTIPO_VAL2006_CK] CHECK ([CDTIPO_VALOR] is null or ([CDTIPO_VALOR] = 'P' or [CDTIPO_VALOR] = 'V' or [CDTIPO_VALOR] = 'E')), CONSTRAINT [TREP_NOVEDADES_SNGENERAD2006_CK] CHECK ([SNGENERADA] = 'S' or [SNGENERADA] = 'N') GO CREATE TABLE [dbo].[TREP_NOVEDADES_2007] ( [NMSEC_NOVEDAD] [numeric](12, 0) NOT NULL , [CDCONCEPTO] [varchar] (12) NOT NULL , [CDTIPO_VALOR] [char] (1) NULL , [CDPRECIO] [varchar] (12) NULL , [CDTIP_HECT_DTO_PAG] [varchar] (2) NULL , [FEGENERACION] [datetime] NOT NULL , [FEPAGO_COBRO] [datetime] NULL , [CDMETODO_DISTRIBUC] [char] (1) NULL , [CDTIPO_DCTO_PAGO] [char] (1) NULL , [VRDESCUENTO_PAGO] [numeric](18, 5) NULL , [SNTERCERO] [char] (1) NOT NULL , [CDCLASE_NOVEDAD] [char] (1) NOT NULL , [CDENTIDAD] [varchar] (3) NOT NULL , [CDESTADO] [varchar] (2) NOT NULL , [CDCAUSA] [varchar] (6) NOT NULL , [NMSEC_PREFIJO] [numeric](12, 0) NULL , [SNPAGO_CAJA] [char] (1) NOT NULL , [SNVAL_PROPOR_PESO] [char] (1) NOT NULL , [CDTIP_HECT_DISTRIB] [varchar] (2) NULL , [CDMONEDA] [varchar] (5) NOT NULL , [CDCOMPANIA] [varchar] (2) NOT NULL , [NMSEC_NOVEDAD_PADR] [numeric](12, 0) NULL , [SNGENERADA] [char] (1) NOT NULL , [POEMBARGO] [decimal](7, 4) NULL , [CDTERCERO] [varchar] (15) NULL , [CDCIA_TERCERO] [varchar] (2) NULL , [NMSEM_GENERACION] [tinyint] NULL , [NMANO_GENERACION] [smallint] NULL , [NMPER_GENERACION] [numeric](6, 0) NULL , [NMSEM_PAGOCOBRO] [tinyint] NULL , [NMANO_PAGOCOBRO] [smallint] NULL , [NMPER_PAGOCOBRO] [numeric](6, 0) NULL , [CDTERCERO_CAJA] [varchar] (15) NULL , [CDSUCURSAL_CAJA] [varchar] (4) NULL , [CDCOMPANIA_CAJA] [varchar] (2) NULL , [SNGENERAR_TRG] [char] (1) NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[TREP_NOVEDADES_2007] ADD CONSTRAINT [DF__TREP_NOVE__SNGEN] DEFAULT ('S') FOR [SNGENERAR_TRG], CONSTRAINT [TREP_NOVEDADES2007_PK] PRIMARY KEY CLUSTERED ( [NMSEC_NOVEDAD] ) ON [PRIMARY] , CONSTRAINT [TREP_NOVEDADES_2007_NMANOGENER_CK] CHECK ([NMANO_GENERACION] > 2006), CONSTRAINT [TREP_NOVEDADES_CDMET_DIST2007_CK] CHECK ([CDMETODO_DISTRIBUC] is null or ([CDMETODO_DISTRIBUC] = 'P' or ([CDMETODO_DISTRIBUC] = 'I' or ([CDMETODO_DISTRIBUC] = 'H' or ([CDMETODO_DISTRIBUC] = 'C' or [CDMETODO_DISTRIBUC] = 'D'))))), CONSTRAINT [TREP_NOVEDADES_CDTIP_DCTO2007_CK] CHECK ([CDTIPO_DCTO_PAGO] is null or ([CDTIPO_DCTO_PAGO] = 'H' or ([CDTIPO_DCTO_PAGO] = 'C' or [CDTIPO_DCTO_PAGO] = 'A'))), CONSTRAINT [TREP_NOVEDADES_CDTIPO_VAL2007_CK] CHECK ([CDTIPO_VALOR] is null or ([CDTIPO_VALOR] = 'P' or [CDTIPO_VALOR] = 'V' or [CDTIPO_VALOR] = 'E')), CONSTRAINT [TREP_NOVEDADES_SNGENERAD2007A_CK] CHECK ([SNGENERADA] = 'S' or [SNGENERADA] = 'N') go CREATE VIEW TREP_NOVEDADES AS SELECT * FROM dbo.TREP_NOVEDADES_2006 UNION ALL SELECT * FROM dbo.TREP_NOVEDADES_2007 Tag: TempDB
  - 9
    - My SSIS problems There are things I just don't get about MS programming: 1. Text file source - recognizes column as "database date [DT_DBDATE]" - but not able to process it as date - values like "2006-12-06T13:16:04" 2. When using import export wizard - it errors out when trying to transfer large amount of rows (40 million) - 1st time out of space error - but the db is in simple recovery model - and even though I increased logs to max & moved them to different HDD - I DO NOT NEED the logging. 3. MS Full text search & full-text index performace issues - our keyword search more often than not times out (it's probably not related to SSIS - but if anyone has suggestions - please do) I just wish that I could spend more time on doing stuff - so any help on those problems are appreciated. Thanks, Tag: TempDB
  - 10
    - Infinite Loop while cube processing in SSAS 2005 SP2 Hi, We build the cube, quite large one processing 4 million records of data daily. It was working fine in SSAS 2005 Service Pack 1. But recently Service Pack 2 for SSAS came out, in the releases notes it said SP2 solves some of the issues we had on the drillthrough. So, after applying SP2 on the production server, running on 32 bit Windows 2003 SP2, the ETL process is stuck. It stuck while processing the cube, on large dimension. I was wondering whether microsoft released hotfix for this issue or anyone else had this problem. I note again, that whole thing was working fine under SSAS 2005 SP1 environment, but i believe in SP2 there is some flaw that leads to infinite loop while processing the cube. Regards, Bakhodir Makhamadov Tag: TempDB
  - 11
    - SSAS cube deployed failed I am building one cube with one dimesion table and one fact table in SQL2005SP2. After the cube is created and I got the following error during the deployment 1. Internal error: The operation terminated unsuccessfully. 2. Errors in the OLAP storage engine: An error occurred while processing the 'Open AR' partition of the 'Open AR' measure group for the 'Solomon DW' cube from the Analysis Services Project2 database. 3.Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. I then go to the partition and complete the aggration wizard without any problems. But I am still getting the same error when I try to deploy the cube. I am kind of new to the SSAS so any help is appreciated. Thanks! wenchi Tag: TempDB
  - 12
    - Replication with multiple server with the same server name hey all, I have been testing SQL merge replication out for the last few weeks and it looks as if it will work for my company. However, I have a couple of question. the setup: 1) we have multiple servers in the field all using the same server name with different IPs and different workgroups 2) Publisher = SQL 2005 SP2 3) Subscribers = SQLexpress SP2 4) Merge pull scriptions for all subscribers 5) Suser_Sname() used as filter My questions: 1) Can all the subscribing servers access the same subscription at the publisher with out screwing up the generation table 2) Is there any way to have a subscribing server point to a particular subscription at the publisher I've tried setting up an alies on a subscriber but the sp_addmergepullsubscription_agent will no longer accept subscription parameters. Thanks in advances for any and all help. Tag: TempDB
  - 13
    - Lookup Functionality Hi, I have 3 tables that i gather a single field from each and put them into another table.. simple enough you might think but when i start using a lookup funciton to check if i have already entered an item (this package could be run a number of times) some duplicates slip though, and as i continue to run the pakcage less and less appear, but never reaching 0 very strange.. doing select statements on the target table reveal strange behaviour.. after the first 'iteration' there are only unique entries in the target table (exactly what i want). After the 2nd, 3rd, 4th etc duplicates appear of upper and lower case i can only assume that there is something wrong with my query,,, but running it in SQL Manager reveals ~40,000 rows no matter how many times i run it... more magically appear when hte same statement is ran in SSIS!! I have tried a view, and using test tables (rather the live ones i am working on) and the reuslt is the same... any help would be muc happreciated regards Chris Tag: TempDB
  - 14
    - Indexed View not used by the Query Optimizer Hello All, I have a series of Stored Procedure that has a query taking a join of 5 tables. These tables are quiet large with couple of them having around 10 million rows. As this is a DSS application having periodic data loads, I thought of creating Indexed View on top of these tables. Now the problem is that the Indexed View is not directly used by the optimizer. I need to change my queries and put a WITH (NOEXPAND) query hint to make sure the indexed views are used. This is inspite getting dramatic improvement in the query timings (from 64 secs down to 3 secs) after using the Indexed Views. I would like to know what can be the possible reason for the optimizer not using the Indexed View by itself. Is it because my Indexed View caters to multiple queries or I am missing out on something basic. Thanks in Advance, Mitesh Shah Tag: TempDB
  - 15
    - How to stop automatic Replication Validation? Under EM's Replication Monitor/Publishers/pub1/publisher1 there is a "Validate Subscriptions" option on the right-click menu. Since I see unexplained Replication Validation activity I think that the "Validate Subscriptions" option is turned on. But there is no "turn-off" button or way to say "stop." Does anyone know how this "feature" works Thanks Tag: TempDB
  - 16
    - Backing Up DB & its Permissions HI All, I am currently in a situation where I have been fed to the wolves to say the least. My task is to take the current SQL server 05 we have running on a drive array partioned as C & D and rebuild it. I need to have the current database backed up, as well as the unique permissions that are currently present on the database. I then have to remove the hard drives from the RAID array, and replace them with Brand new ones. The OS will then have to be reinstalled, followed by the nessary updates and finally with SQL server. I then have to import the database back to the new server build w/ the data and the permissions all intact. Anyone have any idea of how I can go about doing this Steve Tag: TempDB

William Doman

If your tempdb is on a drive that crashes, is it possible to recover by moving/re-creating the tempdb on another drive

This would be SQL2000

Re: TempDB

Arnie Rowland

When you stop/start the SQL Server service, the TempDb is re-created.

Re: TempDB

Robson Brandão

Hi William,

Really, the TempDB database is created each start up of the SQL server services.

You can��t backup and restoring of TempDB because this. But You can move TempDb to other disk.

See this exemplo in my site:

http://www.msit.com.br/publicacaoDetalhes.aspx id=192

Re: TempDB

William Doman

I know it is recreated but the question is if the drives were to blow up, would SQL Server boot

It would try to recreate tempdb on drives that didnt work. Can you recover from that

Re: TempDB

Robson Brandão

Well, if the drivers blow up, SQL Server don��t boot, but you can��t to create others temporary objects.

One good idea is SHRINK the TempDB

DBCC SHRINKDATABASE (tempdb, 10)
GO

And set the recovery to SIMPLE.

SQL Server wouldn��t try to recreate on drivers that didn��t work. You can make a job to SHRINK Tempbd each specific time.

Re: TempDB

Arnie Rowland

After you replace the failed drive(s), the 'simplest' solution would be to assign the same Drive letters as was previously used on the failed drive(s).

Re: TempDB

William Doman

Ya replacing the drive array would be the easiest but this is a ad-hoc quick fix and if it were to fail it would resuolt in unacceptable downtime to replace them. We have governed 100% uptime.

I'm looking for less risky things to be placed on this temporary drives.