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...
Well, actually I don't know how to do it. Can you please, explain me that how and why do we deploy the scripts to a different server? Thanks
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 Preethi, Thanks for the reply but I couldn't understand what you are trying to say. I tried using SELECT object_ID(0) It didn't work. Can you...
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 Preethi, Thanks again and I have one more question . Can you tell me that if any application is running slow because of MSSQL server database,...
Hi Preethi, Thanks a lot for your answers to my Questions. I have one more question. Can you please, suggest me some good ways to avoid locking and...
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 preethi, Thanks for quick reply. I will try that way. Jackson
Hi Madhivanan, Here is the procedure code. create procedure DB_DatabaseBackup @Path varchar(500) , @DBName varchar(128), @BackupType Varchar(10) as...
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 Luis, Thanks for the quick reply but I am still confused. Do you mean that we have to have SP2 to install MS SQL Server 2000 on Window Sevrer...
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 Peerthi, I really appreciate you help. Thanks a lot. Jackson
Hi Peerthi, Yes, I should have given more information to you.I am taking full,differential and transaction log backup.This happened yesterday...
Separate names with a comma.
