Hi , Can anybody help me to create trigger that would send an email with all the information about the server , database and the table on which the...
HI, Actually we have about 200 servers and we have to moniter the backups running on all the servers often. It really takes a very long time to do...
Hi, How does failover work in the SQL Server with two instances. Both the instances fail or only one can fail at a time . Please, let me know....
Hi, Can anybody please, let me know about deploying the scripts . Thanks
Hi, Actually I had a great problem installing MSSQL Server today. I kept on trying to install and it kept on giving me error 'Database services and...
Hi, When I use EXEC SP_LOCKS. How can I know that in which database or the table the lock is on. Please, let me know. Thanks, Jackson
HI, Can somebody tell that how many data file can we assign to TEMPDB Database? Thanks
Hi , Can we do log shipping between MSSQL 2000 and MSQL 2005? Thanks, Jackson
HI, I have a stored procedure which was working untill day before yesterday but all of sudden it stopped working today. It doesn't give any error....
Hi, Can we install Microsoft SQL Server 2000 on Microsoft Windows Server 2003 ? Thanks, jackson
Hi, Can any body give me a detail explanation about 3GB Memory Switch in MSSQL Sever. Also can you explain about AWE AND PAE and the relation...
Hi everybody, Can someone let me know how to restore a database after a system failure? Actually I just joined as a DBA and I have never have this...
Hi all, Can somebody let me know how to move a SQL Clustered instance between cluster nodes ? also which tool can we use to add a node to a...
Separate names with a comma.
