Viewing 15 posts - 46 through 60 (of 396 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
https://dbfriend.blogspot.com/
November 13, 2006 at 11:20 pm
August 15, 2006 at 2:22 am
SET XACT_ABORT ON at the begging of trigger
https://dbfriend.blogspot.com/
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
https://dbfriend.blogspot.com/
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]
https://dbfriend.blogspot.com/
July 14, 2006 at 12:14 am
Try after deatching the DB
https://dbfriend.blogspot.com/
July 14, 2006 at 12:10 am
This seems to be a timeout expired. Try to increase your remote query timeout option.
https://dbfriend.blogspot.com/
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
https://dbfriend.blogspot.com/
July 13, 2006 at 6:42 am
http://support.microsoft.com/default.aspx/kb/280684
https://dbfriend.blogspot.com/
July 11, 2006 at 1:04 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
https://dbfriend.blogspot.com/
February 22, 2006 at 12:30 am
unfortunatly no. ( AFAIK)
https://dbfriend.blogspot.com/
November 28, 2005 at 11:47 pm
yes it should be used as final "Trump", I should have mention these in the article. Sorry About it!!
https://dbfriend.blogspot.com/
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.
https://dbfriend.blogspot.com/
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.
https://dbfriend.blogspot.com/
October 10, 2005 at 2:39 am
Viewing 15 posts - 46 through 60 (of 396 total)