Viewing 3 posts - 1 through 3 (of 3 total)
>dogramone
Good, but I use more faster and optimization script
Declare
@db_name sysname,
@sqlvarchar(8000),
@spidvarchar(8000)
while 1=1 do
begin
set rowcount 1
select @spid = min(spid) from master..sysprocesses where dbid = db_id(@db_name) where...
July 2, 2003 at 11:55 pm
I use this stored procedure, which I wretten
create procedure dbo.BACKUP$CreateScript (@path varchar(300)) as
begin
Declare
@resultint,
@namevarchar(128),
@cmdvarchar(2000),
@full_pathvarchar(1800)
Declare
mcur cursor local static for...
July 2, 2003 at 11:36 pm
>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
Viewing 3 posts - 1 through 3 (of 3 total)