I'm trying to attach a copy of a database to another server. When I do this, the attach fails due to an index problem. The error message indicates that I should run: dbcc checktable(sysindexes) when I run this on the original server (where the database is attached) I get a missing sysi...more >>

Hi, How do I copy the rows in my table into a .txt file comma delimited. I tried COPY mytable TO '/presentation/myfile' WITH DELIMITER ',' but it does not work TIA Roy Gourgi ...more >>

Hi, Is it possible to install 32 bit SQl Server 2000 on 64 bit Windows 2003 Server. Please let me know this information. -- SQL serer DBA...more >>

I have created a table in which one column is datetime data type. But its storing date andtimetogether. How can i chane the format to store only dates in dd-mon-yyyy? thanks in advance...more >>

Running SQL server 2000 in Mixed mode. How do I change the SL SA account password? -- Spin ...more >>

Hi, I've noticed that ORDER BY in views does not work in SQL Server 2005 as it did in SQL Server 2000. My old syntax was: "Select Top 100 Percent....." which was converted to: "Select Top (100) Percent..." when I recreated my views. However any ORDER BY's in my views are not executed unt...more >>

Hi, im hoping someone could help me with this problem. I would appreciate any help at all: SQLite said that it supports current_timestamp but it doesnt work when i use it as a Default value, for example: (Im executing these sql statements in sqliteqa) 1.drop table sample_table; 2.create...more >>

Hello All, I am wondering if someone can shed some light on how to display "Variables" window in Integration Services. I am trying to add a new variable by clicking SSIS menu, and choosing Variables. However, the Variables window never showed up. Is there some property settings that I ne...more >>

Ok under the old setup in SQL 2000 customers who host their databases with a provider coudl use DTS to transfer data, perform tasks and such as needed. The information to perform the task was stored on teh server so they could replicate the steps they took whenever they wanted Under SQL 200...more >>

I have an SP that hangs. The code seems to work fine when run from QA outside of an SP. SP_who2 shows three copies of the same SPID#. 59 RUNNABLE BTHREE\sternj 3S0BATCH001 . mydb UPDATE 468720 44083 04/29 15:27:13 DTS Designer 59 ...more >>

OK say a user creates a view "A".... Now another user comes along and creates a view "B" which joins view "A" plus other tables. Now yet another user creates a view "C" which uses "B".... Supported yes but is this really wise? It really begins to be convoluded quickly. Seems to me a view ...more >>

Hi Everyone, I added a secondary filegroup to a production database and moved some tables to it from the Primary Filegroup.In the process I changed the database recovery model to Simple and back to Full,backed up the Transaction Log and shrunk it,shrunk the primary filegroup datafile. The d...more >>

We installed SP 1 yesterday and now none of our Jobs work. The error we're getting is the following: "Unable to start execution of step 1 (reason: The job step contains one or more tokens. For SQL Server 2005 Service Pack 1 or later, all job steps with tokens must be updated with a macro be...more >>

Hi, When Tuning my DataBase with the Index tuning Wizard, it proposed me an index view, calles _hypmv_4. I added it, and I saw an enormous perfomance gain. But how does this work exactly? How does SQL Server now that it should use this indexed view when running a query? There isn't any r...more >>

Hi, When Tuning my DataBase with the Index tuning Wizard, it proposed me an index view, calles _hypmv_4. I added it, and I saw an enormous perfomance gain. But how does this work exactly? How does SQL Server now that it should use this indexed view when running a query? There isn't any refe...more >>

I create my first job schedule to remove some unused data at mid-night. As I want to do some modification in that job schedule, I don't know how to retrieve that Job , Please help. and thanks ...more >>

Hi, I am having problems with autogrow after install SP1. I have a big DB (20 GB) and autogrow is set to grow by 100 MB. I found that after SP1, the autogrow changes from 100 MB to (A random big number. ex 6545) percent and it fills my disk. First time it happened, I changed to my value, b...more >>

How could i encrypt a ms sql 2000 database. what is when i do a backup of the db. will i recieve a certificade with the key. Does somebody have some experiences about the best way for encrypting an sql server and the protocol. Thank's for some infos Michel ...more >>

I am trying to tune a query that has as its execution output as a Clustered Index Scan. There is a Clustered Index on field [dt], which is a datetime field. The query is structured as such: IF @date < '1/1/1901' --...then make it NULL, so that it works in the query SET @date = NULL ...more >>

I'm attempting to setup a uPortal instance on a laptop which has SQL Server Express. To build uPortal, I need to know several parameters about the DB Name, DB Version, Driver Name, and Driver Version. The documentation states that this data must match, exactly, what's in: java.sql.Connect...more >>

I have a SQL Server 2000 database server on Windows 2000 Advanced Server. What is the best way to move the TempDB data and transaction log files from the C: to E: drive? Thank You,...more >>

I want to know what is the %CPU used by a process in SQL Server. In other words, I got the CPUTime from the sysprocesses table and the number is say 10,000. How can I relate this CPU time with NT processor percentage? A user called me before running some stored procedure and wanted to know ...more >>

Hi. We are experiencing an issue on SQL Server that sounds very simlar to the hotifx detailed here: http://support.microsoft.com/kb/835864 Only trouble is we are running on a single CPU server when the article suggests it is only applicable to multple CPU servers. Has anyone had experience ...more >>

Hello, We are migrating an application to a new server Old server: Windows 2000 IIS 5.0 SQL 2000 New server Windows 2003 IIS 6.0 SQL 2005 Even if the new server is much faster, we have some performance issues with queries 1. Query optimizer The query optimizer seem to have probl...more >>

I use SQL Server 2000 at my place of business. I need to create a linked server so I can run queries against a DB2 database. I created the ODBC connection and can get at the database tables in Microsoft Access but cannot get at them in SQL Server 2000. I did some Googling and it seems that ...more >>

sql2k sp4 Howdy all. All of a sudden, my DTS Package is totally unusable. If I try to run it or design it, I get "unspecified error". I have verified that there is no corruption in both MSDB and Master. Ideas? TIA, ChrisR ...more >>

I am moving databases from SQL7.0 to SQL 2003. I have exported teh data and tables from the old one to teh new one. How can I move, or copy the DTS packages? ...more >>

We've been experiencing some performance degradation recently. We are a small company partnered with a MUCH larger one. Someone from the other company said they had experienced some of what we are seeing and recommended that stored procedures which only return one row of data should use outp...more >>

I am occasionally experiencing timeouts while connecting to a database. Attempts to insert even a small record cause the system to max the disk usage and keep it there. I have experienced the problem on two different servers, with different size databases (one of about 16GB and one of about...more >>

We have a strange problem with an SQL SERVER 2000 database, it doesn't seem like a corruption problem but I can't identify what's happening. I'd appreciate any ideas. On Wednesday we noticed that 85 records in a person table had been added. These appear to be old versions of existing records. ...more >>

In SQL Server 2005 is it possible to drop and create a stored procedure whilst it is in use? If not how do you recommend upgrading stored procedures that are called multiple times every second? Is it possible in SQL Server 2005 to drop an index on the fly on a table that is being quite heav...more >>

Hi, I am trying to catch only table scans on some specific large tables in very active database. I choose scan:started, and tsql:started events, and textdata, objectid columns. I also set the filter on object id for the tables I'm interested in. Problem is that the trace returns events fo...more >>

Greetings, Please tell me we don't have to live with this annoying thing where if you try to open multiple .sql files it opens a new instance of Management Studio and prompts you to connect to a server?? I JUST want to modify some sql scripts dangitt. If so, MS please get on the ball to get...more >>

Hi All, I have local Package DTS which logged in as the user runs Dandy. But when Scheduled gives me this error: MESSAGES: The job failed. Unable to determine if the owner (XXXX\YYYY) of job Copy from 2005 to SQL 2000 Server has server access (reason: Could not obtain information about Window...more >>

What is best place to look / check for a database Backup / Restore history, I am mostly interested for RESTORE, like who did it and when ...etc....more >>

is it available for other than Windows platforms? thanks best regards, schw ...more >>

We have a request to be able to execute the following from an application: declare @languageValue varchar(1000) exec sp_OASetProperty @languageValue, 'CharSet', 'Shift-JIS' Currently the developer is unable to because they get an "EXECUTE permission denied on object 'sp_OASetProperty', datab...more >>

Hi all, I have a Identity increament column name "ID" (int). Now i have values in that column : +-------------+ | ID | +-------------+ | 1 | | 2 | | 100 | | 101 | | 102 | | 104 | | 105 | | 106 | | ... ...more >>

I have setup SQL Server 2005 SP1 with mirror of a database to another server. How am I supposed to duplicate the logins between the two servers and map the logins defined at the server level to the database level? Olav ...more >>

Whenever we restart sql server the following error appears: 2005-12-20 12:34:22.28 server Attempting to initialize Distributed Transaction Coordinator. 2005-12-20 12:34:22.31 server Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b When I check the MSDTC service...more >>

I have setup SQL Server 2005 SP1 with database mirroring. I have a client application connecting to the database via ODBC and I define the connection under the System DSN tab in the ODBC Data Source Administrator (launched from Administrative Tools). How can I specify the failover partner ...more >>

Hi, I want this query (with a sub-select) to have a better performance. I trimmed it down from 3 minuts and 30 seconds to 9 seconds, by rewriting the query (originally they used a view that consumed a lot, added some indexes and re-arranged the index of the primary key), but I'm still not h...more >>

Hi All, I have a SQL2000 box and I would like to start using SQL 2005. Can I restore data from sql2000 in sql2005? If I can, the SQL2005 will be my main server, do I need to change anything on my applications? or they can connect in the same way? What do you recommend for this process? Tks J...more >>

I'm trying to rename my mdf files and I have tried 1. Detach db, rename files and attach from Enterprise Manager. I direct it to the rename MDF file and it lists the original filename then lists the current file location with the old names and two red X's indicating a problem. When I hit ...more >>

My server is running both sql 2000 and 2005. When 2005 was installed there was some issue -- I didn't do the install so that is all I know. When I looked at the server there was 1 named instance named NEW. I went to an application box which runs win2k and tried to create an ODBC connection. I ...more >>

All, For my project, I need to get familiar with sqlserver2005 in a few days.But I do not have any books or links, so please provide any links or books to learn about sqlserver205. Thanks in advance, Devraj ...more >>

Hi, I have successfully implemented SQL db mirroring on 2 - Win 2K3 Ent. servers. (haven't implemented witness server yet) I am able to manual failover the required databases. Principal server IP: 192.168.0.1 mirror server IP: 192.168.0.2 Currently, I have a front end web app on another...more >>

Hi there, I am planning to migrate SBS 2000 from one domain to another domain with a new server SBS 2003 SP1. This includes migrating SQL database, secuirty and all packages in SQL. Is there a Microsoft KB for this process? or Can someone please point me in the right direction? Your ...more >>

I am witnessing something odd with regard to execution plans and a linked server. I have a restore of a production database in two different environments, one DEV the other QA. This database resides on the linked server in our setup. The other database -- the local database -- has been instal...more >>

Hi, I just started at a new company and have been tasked with reviewing the configurations on some troubled servers. One thing I noticed that seems odd in the sp_configure output is that the min memory per query (1024 MB) is actutally higher than the max server memory (344 MB). Which setting h...more >>