Hi Friends, Yesterday we had a deadlock in one of our application which was running on mysql (Live since last 7 year and this was the first time this...
Friends I've once scenario to discuss.... Lest suppose we have one live server in one domain. Now I've to make a replica of this server in another...
Hi, C Drive in one of our prod db server running on SQL Server 2000 EE on Win Server 2003 EE SP2 is fill up aroung 95%. When I tried to move some of...
Hello All, I'm having slight confusion in interpreting processor queue length cos as per below articles it says that average processor queue length...
Hi All, I've written a below cursor which will give me list of select query to find the count of records for each of my user table. Cursor Body ===...
Hi, I found below links very informative.... http://www.databasesecurity.com/dbsec/comparison.pdf...
Hi, We are having a simple package which will read a deliminated flat file and put in to a database table. Now I'm having few concerns on this....
Hi, I need to insert records in a table from a varchar(4000) variable, this variable will hold the values in below format id|name:id|name:... And...
Hi, We have a SSIS package running on one server and its doing lost of tasks including updating, inserting records in different tables on different...
Hi, Can any body provide me a db script or any method through which I can know space used per database object?
Hello All, I've configured Transactional publication with updatable subscriptions(with push subscription) using SQL Server 2005 in our development...
Hello All, I need to configure merge replication using SQL Server 2005. Do you guys have any document explaining the prerequisite, and the step by...
Hello, I've few queries about sql server 2005 can anyone help me in giving answers to them. 1. In 2000 we have SQLSTP.LOG in C:Winnt directory for...
Hello, I've a table with primary key defined as non-clusterd, now without dropping it can I modify the existing index to clustered. Thanks in...
Hello, I installed SQL Server 2005 Evaluation edition on one of the testing server, now two three days back when I tried to open management studio on...
When trying to copy a database from one instance of SQL 2005 to another instance I get the error below. I am using SQL 2005 Standard Edition on...
Hello,I want to configure transactional replication between two servers with sql server 2005, I want to know whether both the servers and the third...
Hi, I'm having an excel file with around 50 columns and I want to write a DTS package which should create a table in the database and import the...
Hi, Today our production server was hanged cos.....the number of current users was increasing and it was around 300+, but in normal case the number...
Separate names with a comma.
