Viewing 3 posts - 1 through 3 (of 3 total)
>dogramone
Good, but I use more faster and optimization script
Declare
@db_name sysname,
@sql varchar(8000),
@spid varchar(8000)
while 1=1 do
begin
set rowcount 1
select @spid = min(spid) from master..sysprocesses where dbid = db_id(@db_name) where spid >...
July 2, 2003 at 11:55 pm
#464005
I use this stored procedure, which I wretten
create procedure dbo.BACKUP$CreateScript (@path varchar(300)) as
@result int,
@name varchar(128),
@cmd varchar(2000),
@full_path varchar(1800)
mcur cursor local static for...
July 2, 2003 at 11:36 pm
#464004
>Tmp
OK, I want move log file my database, but this databases on replication transaction. Where way choose &
February 12, 2003 at 11:10 pm
#448836