I have a subscription which is not catching up with latest transactions from publisher even after being re-initialized successfully with latest...
Hi All I am having transactional replication setup over databases upto 1 TB. Where can I get information about troubleshooting blocking issue...
Hi, I am using SQL Litespeed for taking backups. I am facing one strange issue with the physical_device_name column values in...
I was troubleshooting an issue with linked server in SQL 2005. I got an error associated with remote logins not defined. So I looked into some...
Forgot to mention the environment is win2003 + SQL 2000
Hi, How to change the IP of a cluster instance of SQL server. It is a two node cluster. We are planning to change the IP of the nodes as well as...
The authentication mode is already mixed mode. We have also reboot the server since changing the authentication mode. Still the error persists....
Hi, I am getting an error while connecting to SQL server 2000 on Windows 2003. SQL 2000 std edn+ sp4 ... basically its a authentication issue. The...
Hi All, I am doing a backup recovery solution for a 1800 GB database! Database recovery mode is simple ....point in time recovery not...
Yes, openquery is much faster.....only one problem....is the query string is limited to 8k only. Hence, I had to use DTS. Regards, Chetan
Hi, I want to understand the difference from point of performance between a query executed through linked server using the OPENQUERY function and...
Thanks Satya.! Every month a new set of 120 tables is getting created in the database. The reindex is done only on the newly added tables. [;)] And...
In our sql 2000 database we add 120 tables totalling 300 Gb in size. After the loading process is over, we run a reindex on all 120 tables. My...
Hi, I want to know is it necessary to take transaction log backup of principal database in a database mirroring. Although I know that the database...
Hello , I have written a SP to capture the data of sysperfinfo from each SQL server (we have about 150 instances). However, for some instances...
Hello, Is it possible to capture buffer cache hit ratio using t-sql script: I am going to try this: declare @num float declare @dec float select...
Satya, I m sorry if anything was unclear in the post. What I want to say is that sql 2000 installed is a 64 bit Ent edition server on a win2k3...
Hi, 64 bit OS should allow installation of 32 bit applications. Regards, Chetan Best Regards, Chetan "Calm seas can never make skillful...
Hi, Working with 32 bit tools is ok..but my question is can i install them on the server or do i have to install on some other machine and connect...
Hi, Can I install 32 bit client tools only on a win2k3 datacenter edition (64 bit). The server already has a 64 bit instance of SQL 2000 installed....
Separate names with a comma.
