Forum Replies Created

Viewing 7 posts - 31 through 37 (of 37 total)

  • RE: Beyond Automation

    paul.knibbs (8/19/2010)


    Having thought about it, I'm not so sure that automation always needs a human in the loop. The (simplistic) example I'd give is that I recently drove a car...

  • RE: Beyond Automation

    Malone's law of tedium: It is inherent in the definition of tedium that tedious tasks are good candidates for automation.

    First corollary: To find tedious tasks walk through the office and...

  • RE: TSQL LAB 2 - Writing Conditional WHERE Clauses

    SQL's string manipulation performance is good enough for generating dynamic SQL.

    Its when you are manipulating (particularly concatenating) strings for every record in large tables you need to decide where...

  • RE: Stored Procedure Execution

    The explanation is wrong.

    Explanation: "SQL Server uses the sp_ prefix to designate system stored procedures... A user-defined stored procedure that has the same name as a system stored procedure...

  • RE: xp_cmdshell

    DOH!

    I meant to remove the -o when I copied and pasted the command.

    If the file is desired/required then run a second command to type out the file.

    @cmd varchar(1000),

    @FileNameOut varchar(200),

    @user...

  • RE: xp_cmdshell

    set @FileNameOut ='OutputConsistencia_'+@db

    select @cmd = 'osql -U'+@user+' -P'+@pass+' -S -Q"dbcc checkdb ('''+@db+''') with no_infomsgs" -o"c:\'+@FileNameOut+'.txt" -w500'

    create table #t (cmdout nvarchar(255), id int identity)

    Insert #t Exec master..xp_cmdshell @cmd

    Select * from #t

    This...

  • RE: Finding Jobs

    The problem is not just the sysdepends is deprecated, it is not accurate.

    Example:

    create a table

    create a procedure that selects from the table

    drop the table (which deletes records in sysdepends)

    create...

Viewing 7 posts - 31 through 37 (of 37 total)