Viewing 15 posts - 46 through 60 (of 395 total)
Wish you 3, all the best for your future.
I really recomed your effort to put this site success and I learnt lot by contributing to this site
November 13, 2006 at 11:20 pm
August 15, 2006 at 2:22 am
SET XACT_ABORT ON at the begging of trigger
August 2, 2006 at 2:02 am
You can use c2 Audit
http://www.sqlservercentral.com/columnists/dasanka/basicsofc2auditing.asp
There are third party tools for this task
SQL Apex SQL Audit and Red-Gate also has a tool
July 14, 2006 at 12:45 am
you can use link serves.
using link servers you can link the SQL Server
then delete from [LinkServerName].[dbo].[DBNAme].[TableName]
July 14, 2006 at 12:14 am
This seems to be a timeout expired. Try to increase your remote query timeout option.
July 13, 2006 at 6:50 am
you can use enterprise manager as well.
right click the database. select restore and select backup file.
make sure you change the mdf and ldf file path
July 13, 2006 at 6:42 am
I think this is a bug in SQL Server 2005, I had the same issue and got away with after re-installing the SQL Serer 2005
February 22, 2006 at 12:30 am
yes it should be used as final "Trump", I should have mention these in the article. Sorry About it!!
November 1, 2005 at 5:39 am
Yes. If you want this to be done from the script you need to get the use of a temporary table and recreate the table.
October 10, 2005 at 2:43 am
There are few good article on this subject in this site. search for them. You will find them usefull.
October 10, 2005 at 2:39 am
Viewing 15 posts - 46 through 60 (of 395 total)