Viewing 7 posts - 31 through 37 (of 37 total)
paul.knibbs (8/19/2010)
August 19, 2010 at 9:40 am
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...
August 19, 2010 at 6:06 am
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...
July 30, 2010 at 5:58 am
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...
July 28, 2010 at 5:42 am
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...
July 6, 2010 at 6:10 am
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...
July 6, 2010 at 5:48 am
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...
May 5, 2010 at 10:48 am
Viewing 7 posts - 31 through 37 (of 37 total)