Hi , Can somebody please, let me know that is there any way that we can find the error in a log file which is related to the error occured during...
Hi Friends, I am trying to connect to the local instance in my machine. I had deleted some Databases. As soon as I deleted them when It gave me the...
Hi , Ineed to move data from my test envirnoment in a MS SQL Server 2000database to a staging envirnoment, also a MS SQL Server 2000 database.I...
Hi Can any one please, tell me that when we configure log shipping do we have to open a firewall from the destination server to the source server...
Hi Freinds, Is there any query that can retrieve the current usage by transaction log file. Please, help. Thanks, Rabani
Hi, Can any body let me know that Does Distrib.exe consume a lot of memory in the SQL Server? What would be the possible reasons or an exessive...
Hi , Can anybody let me know if a store procedure is taking a high cpu time and high duration to execute , how can we fix this problem. Thanks,...
Hi, Can somebody clearify that what performance issue occurs if the maximum user connection is exceeded. Thanks, Rabani
Hi, Can anybody let me know that what happens if there is 95 % locking on MSSQL 2005. How good is it. Please, advice. Thanks, Rabani
Hi, Can anybody suggest that how can we delete a table referenced by a foreign keys. Specially the table that is referenced by multiple foreign keys...
Hi, Can anybody give me an idea that how can i move data from a table in one server to another server into the same table which doesn't have any...
Hi , Can any body let me know that how do we find the compatiblity of upgrading MSSQL server without using upgrade advisor? Thanks, Rabani
Hi , Can somebody please, help me with a script to send an alert upon the failure of a job. I need a script that will automatically send an email...
Hi, Can somebody please, let me know that how do we know exactly that a server has failed over to the secondary node. Also what does that effect the...
Hi, I have been creating package in my system and it was not a problem. Today I got this message while I tried to create a package. Can somebody...
Hi all, Can anybody let me know the difference between logical and physical read? Thanks
Hi, Can any body tell me that how can we remove fragementation on a table without an Index? Thanks
Hi , 1.Can somebody tell me that where should we put our data files on raids . I mean which raid should the data file be and which raid the log file...
Hi all, I really need help from you guys today. Please, help with the following questions. 1. Can you let me know about TDS/TCP/IP packages...
Hi , I am confused. Can somebody please, let me know if online indexing feature of SQL Sever 2005 is availabe in Standard Edition. Thanks
Separate names with a comma.
