Hi all, First question: I have machine with sql server 2000 installed my question is can i install sql server 2005 on the same machine and can i use use both Simultaneously Second question: what is difference single # and double ## in sql server 2000 Thanks in advance Abhi ...more >>

hi! I have a question about connecting instance on local server I install MS SQL Server 2000 first and then install MS SQL Server 2005. 2005 has an instance name called "2005" I use Microsoft SQL Server Management Studio and log into 2000 I want to select data from 2005 so I write a script ...more >>

Hi, We have the following code to automatically create the linked server in one of our upgrade scripts. declare @Security_dbname nvarchar(128) -- This is the security database name declare @Security_Server nvarchar(128) -- This is the Security Server Name declare @Ins...more >>

I did a Process Monitor trace, and found that it hangs twice - 29 seconds between closing the registry key: HKLM\System\CurrentControlSet\Services\Tcpip\Parameters\Winsock and exiting the thread, and 18 seconds trying to create \ \10.0.120.21\PIPE\sql\query I'm thinking that this has to...more >>

Hello, Is there a way to export a database and delete the contents of it as it creates the backup - leaving the database intact but devoid of data? Thanks, Tmuld ...more >>

We have a new server, 4 physical dual core processors, with hyperthreading, so it shows up as 16 logical processors. A simple query joining 3 tables, a distinct, an order by, with maxdop set to 0, takes over 2 seconds. With maxdop set to 1, it takes 200 milliseconds. setting maxdop between...more >>

I have an issue where a database on SQL 2005 (set to "simple" recovery mode) has exponential log growth when I run one particular software service against the DB, it grows by 100-200 megabytes a minute. This service is very simple; it contains several "select" statements (that wouldn't caus...more >>

Hi. I am running SQL 2005 SP2 and when I connect through Visual Studio I do not see the maintenance plan option under Management. I have tried connecting with the SA account and my AD account and neither one has this option. They are both assigned the role of sysadmin. Any thoughts? Than...more >>

We have a mirrored SQL 2005 server. When Server1 fails, we want people to be automatically redirected to Server2. Is this a function of DNS or of SQL Server? How do I accomplish this? ...more >>

Hi I have a 64 bit server installed with sql 2005 sp2 running with 32Gb RAM. I have setup Lock pages in memory for the sql server service account and run sp_configure "awe", 1. I have also set sp_configure "max memory" to 28Gb. Now sure how I check the correct allocation is been used by sq...more >>

Hello, is there a way in SQL Server 2005 to copy a diagram from a database to another one that has exactly the same structure? Thank you in advance, Laura ...more >>

Hi I am trying to change default port on sql server 2005 via sql config manager, but the change is not taking effect even after restarting the services. Any ideas would be appreciated?...more >>

I have had some users contacting me and reporting this error message when refreshing SQL Server queries in their Excel 2003 spreadsheets: "Unknown token received from SQL Server" They are using Excel installed on a Citrix server. My locally installed Excel 2003 returns this error message ...more >>

I have followed the procedure in http://support.microsoft.com/kb/275312 to change object ownership so that I can delete a user. This appears to have worked ( subsequent runs tell me that the original user owns no objects and a query on the sysobjects table filtered on their uid confirms this) ...more >>

I am trying to run some performance monitor counters against our database server and am a little confused by some of the figures. I am monitoring the following Network - Bytes Total/Sec Physical Disk - %Disk Time (Database Drive) Physical Disk - %Disk Read Time (Database Drive) Physical Di...more >>

having sql2000 on win2000 when running long lasting queries [30 minutes f.e.], and running them async, is there some method to periodicaly check the percentage of completness? i know there is a status indicating when the query is done, but is it possible to know intermediate status? since e...more >>

Hi. I hope someone can give me some ideas. I have a SQL 2005 dev installed in my Vista and I tried to register it from my Win 2003 server which also has SQL 2005. I get a time out message, it seems the server cannot connect to my vista sql server. I already set my vista sql server remote co...more >>

My table on the SQL 2000 Server has a filed Id which is a (clustered) primary key. There is but another field named Field1 and I wish to define it as unique or it could be Null. How can I manage this constraint with help of SQL Server Enterprise manager direct on the table or with help o...more >>

I need to change the collation for my database from SQL_Latin1_General_CP1_CI_ASto SQL_Latin1_General_CP1_CI_AI Is the statement "ALTER DATABASE MyDatabase COLLATE SQL_Latin1_General_CP1_CI_AI" enough or should I change every existing fields (how to do it)? Any ideas? Any precautions to ...more >>

I upgraded from SQL Server 2000 Sp4 to SQL Server 2005 without a problem on a server with Windows 2003 SP2. However, when SP1 was applied the installer hang. All non-essential services were stopped without much success. Any thoughts or suggestion....more >>

Is there anything built into MS SQL server 2005 Admin that I can view, similar to the Health page in MY SQL? Anything to get me some real time stats would be great. Thanks. ...more >>

I've got an application that passes parms to an insert stored proc. My problem is that I get an error that says 'String or binary data would be truncated'. If I restore a back up of the same DB onto a different SQL server I dont get the error.My initial impression was that there is/are columns ...more >>

Hi, I need to get the number of rows exported through bcp. Is there a simple way to do that? The current code is as follows: DECLARE @sql varchar(8000) SELECT @sql = 'bcp "exec stored procedure" queryout Drive:\path \output.csv -T -c -t,' EXEC master..xp_cmdshell @sql Help i...more >>

hi All I test db. mirroring. While it's working, tr. log continues growing. while I run tr. log dumps regulary, the size of it only goes up. I tried dbcc shrinkfile and shrinkdatabase - it won't help. Does anybody have this experience?...more >>

We had MS consulting come in and do an engagement, the consultant provided a report. It appears the consultant is saying MS on a 32 bit platform (SL 2000 EE) can not handle physical memory on a box greater than 16 GB. The box analyzed by this consultant has 32 GB of physical memory on the bo...more >>

Gurus, I know if SQL Server / SQL Server Services are restarted, TEMPDB is recreated. Is there any option / way to retain the content of TEMPDB even if SQL Server / SQL Server Services restarted? Help much appreciated. Thanks Javed Iqbal...more >>

Hi, The following SQL works in Oracle 9, but not SQL Server 2005. Does anyone know of a similar syntax in SQL Server without using an OR clause ? SELECT * FROM idxcst_his WHERE (gvkey,iid) IN (('006066','01'), ('001013','01')) The error is: Msg 102, Level 15, State 1, Line 1 Incorrec...more >>

Does anyone know if there is a way to make a security group the DBO login for a db? What I am trying to do is assign the login id of DBO to a windows authentication group as opposed to a single user. I am using sp_changedbowner and it only allows me to enter a SQL user or a single windows u...more >>

We have a company server and want to put Access on it for our Sales order people to take orders. I was told if we have less than 10 people taking orders simultaneosly we would not have to have a special license or an SQL server, is this true? Can we just use our own little company server for ...more >>

Curious about the above: If there is a query that says If not exists(select * from table) versus one that says If not exists(select * from table with(NoLOCK)) Is the second statement more correct than the first (considering that there may be hundreds of hits to that table in a very sho...more >>

I see instances where The Log Backups are running for days but actually not doing anything. It just stalls there and sits. This is for SQL Server 2000. I am wondering if this is a service pack 3 issue that was fixed in 4. I just noticed that the one machine was still running 3 but I'm not sure...more >>

We are experiencing a very strange problem that we are having a problem tracking down. We noticed that we were getting high CPU utilization on our windows 2k box. With Process Explorer we were able to identify the culprit as srv.sys. At the same time we are seeing elevated inbound network traffi...more >>

I have SQL 2005 database, around 500gb in size. We're working on deleting a lot of useless records. In some tables, this could be in excess of 70% of the data. The largest tables are ~82gb, very wide, with wide clustered indexes. I know this sounds bad - we are working toward resolving these i...more >>

DTS packages on 2000 need to be migrated to 2005. Looking for an easy migration. What are some of the resources and tools available? We have about 30 packages so the $25 per package is not an option. More interested in a simple tutuorial - something along these lines. Saw this one alr...more >>

I am running ms sql 2000 for a shared database environement that each department uses for thier own internal database needs. There are roughly 40 active databases, and even the r&d group throws databases up there for testing. I need to know where to go in order to force all new db's to use the...more >>

Hi, I am facing a weird network problem. I am running a SQL 2000 SP2 enterprise edition over a Windows 2003 enterprise edition machine. I am getting the network error messages (see below) while trying to connect to the server. However if i am connected to the server before the problem occur...more >>

Hi All, I am using SQL Server 2000 and I am trying to change the identity seed in a table. I want to change this via a script. I have used the following command: DBCC CHECKIDENT (dbo, RESEED, value) where dbo = the table in the database whose seed I want to change value = the value I woul...more >>

Hi, This requirement is for our development and test environment. We have a database server which we use for development hence many changes are done on the database objects on daily basis like tables def changes, view def changes, sp changes, new sp etc. On the other hand our testing team c...more >>

We just get a connection.txt file from another organization that should be useful for my company. I am new to SQL connection and would like to seek your advice on what does it mean. packet size=4096;user id=HRprocess;pwd=process;data source=DA16\B1;persist security info=False;initial cat...more >>

I have a table that has more than 54 million records and I'm searching records using the LIKE statement. I looking for ways to optimize/partition/etc. this table. This is the table structure: TABLE "SEARCHCACHE" Fields: - searchType int - searchField int - value varchar(500) - externa...more >>

Hi, I'm trying to connect to (Northwind) SQL2005 express from VS2005 express edition . When I test the connection, I get the error: "Generating user instances of SQL server is disabled. Use sp_configure 'User instances enabled' to generate user instances". I run sp_configure with the abo...more >>

Hi, Is there anything wrong with this statement (it is not assigning the correct value) : SELECT TOP 1 @MyVariable = Field1 FROM #MyTable WHERE Field2 = @Value ORDER BY Field3 ASC as opposed to saying... SET @MyVariable = (SELECT TOP 1 Field1 FROM ........ WHERE ........ORDER BY......more >>

I have a SQL Server 2000 standard edition database server that has several databases. I noticed in the SQL Server errorlog that several days ago one the databases at approximately every 5 seconds output a message 'starting up database FRCALXO'. What can I do to resolve this error? Tha...more >>

We're periodically getting the following error message in the SQL log: 07/27/2007 03:42:19,spid2s,Unknown,SQL Server has encountered 21 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [E:\mssql\data\centfwamms_log.ldf] in database [centfwamms] (7). The OS fi...more >>

Hi. We have a workflow system that has tasks (tickets, whatever). As of today, we have several hundred thousand closed tasks and about 5-7k open tasks. The majority of operations work on open tasks, and the majority of reports are also for open tasks; open tasks eventually become closed, clo...more >>

Hi, I've set up two log shipping pairs between three Microsoft SQL Server 2000 SP3 databases: a primary, a main standby, and an auxiliary standby database. For the main standby database jobs that create, copy, and restore transaction log backups run one after another without any delay. Now if...more >>

I have just upgraded to SQL 2000 as per the companies allowed versions and when trying to run an Stored Procedure I am getting the following error. Syntax error converting the varchar value '2165.05' to a column of data type int. The Stored Proc just selects values into a Table, the wierd th...more >>

This pertains to SMS and SQL 2005. I am receiving a bunch of errors in the SMS Discovery Data Manager, and they all pertain to the same general message, "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value" Here is part of the DDM.log... --...more >>

I have a server that will be running as a web server and a database server? To get the best performance is it better to install the database and web server on seperate physical hard drives? or it doesn't matter? I have a total of 8 harddrives, what RAID setup should i choose? Thanks, Fred ...more >>

I've got a delimited text file that aprox 5.5GB that I'm trying to load into a table on SQL 2000 (Windows Server 2003) and I keep getting the error "Not enough storage is available to complete this operation." Changing the commit size doesn't seem to make a difference, but when I changed a co...more >>