Viewing 15 posts - 1 through 15 (of 18 total)
Hello,
There's a long winded reason why that is difficult to implement. Anyway, your suggestion with the trigger worked on a small set of test data. So thanks very much for...
April 24, 2013 at 6:44 am
Crap. Sorry am being stupid. Ignore my previous post.
Anyways, I am hoping to use your script as a starting point to prevent circa 400+ tables from being dropped. I...
April 23, 2013 at 10:12 am
Slightly confused here... I tried this on my TEST server and I cannot drop any tables.
When I try to drop the [cherries] table, I get the following message:-
DROP TABLE Issued.
(1...
April 23, 2013 at 9:53 am
This is what I did to fix my issue.
ALTER Procedure [dbo].[sp1]
@appID int
as
--begin
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
SET XACT_ABORT ON
Declare @TranID int
BEGIN TRAN
Select @TranID = NextTransactionID
From [linked_svr1].[db1].[dbo].[tbl1]
Where ApplicationID = @appID
SET @TranID...
November 28, 2011 at 8:19 am
Import the XLS in a SQL server table. Then use SQL Data Compare (www.red-gate.com) to compare the data.
February 10, 2006 at 8:52 am
OR
EXEC sp_configure 'scan for startup procs', '1'
go
xp_servicecontrol 'stop', 'sqlserveragent'
go
xp_servicecontrol 'start', 'sqlserveragent'
go
EXEC sp_configure 'scan for startup procs', '0'
go
April 14, 2005 at 4:11 am
You will need a bespoke script to that I think.
Check out the link below.
http://databasejournal.com/features/mssql/article.php/2168291
April 14, 2005 at 4:04 am
Didn't know you could add Job Categories. V useful that plus the script to report Failed jobs.
February 14, 2005 at 8:16 am
Try adeptSQL Diff (www.adeptsql.com) or Red Gate SQL Comapre (www.red-gate.com).
February 3, 2005 at 4:04 am
Can't see anything in sysprocesses. Will have to schedule a re-boot I think...
November 17, 2004 at 7:18 am
Hi Clayton,
I can't see how the Importance flag will work. You didn't call the method anywhere in the code?
Regads,
Andy
October 21, 2004 at 9:04 am
Hi Metra,
Thanks for the attachment bit. I have been pulling my hair out on how to do the attachment.
However, there is a mistake in line
>> EXEC @hr = sp_OAMethod @iMsg,...
October 20, 2004 at 8:05 am
Anyone know how to set IMPORTANCE flag using CDOSYS instead?
EXEC sp_OASetProperty @iMsg, 'Importance', 2 does not work.
Thanks in advance.
June 30, 2004 at 8:59 am
ok thanks for the tip.
June 28, 2004 at 6:48 am
I think I did try it but still wouldn't work on my DB. Hence the script.
June 25, 2004 at 5:01 am
Viewing 15 posts - 1 through 15 (of 18 total)