Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Killing users before restore

    >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 spid >...

  • RE: Scripting databases

    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...

  • RE: moving log file to another drive

    >Tmp

    OK, I want move log file my database, but this databases on replication transaction. Where way choose &

Viewing 3 posts - 1 through 3 (of 3 total)