just a bit of clarification:

the program Purge.exe exists on the SQl server itself, right? not locally?

here's a typical example of what i might do: i put file contents in a...

i think if you use xp_cmdshell 'C:\purge.exe 7' it will work; I know I call executables with command line arguments like this all the tiem.

this is how i typically do a big group of transactions;

note that i use SET XACT_ABORT ON, which means if any error gets raised, it rollsback the transaction automatically, so...

and based off of Mohammed's example, here's the limit after 20 example:

drop table #test

Create table #test (

publicationdate datetime default getdate(),

NoOfDays as CASE WHEN datediff(dd, publicationdate, getdate()) < 20 THEN...

i have this snippet where i was looking for the defined row size for each table:

this might help as well:

create table ##tmp (TableName varchar(40),DefinedRowSize int)

sp_msforeachtable 'INSERT INTO ##TMP Select...

very true; don't abreviate anything; readability is critical.

 I have developers here who never heard of the *= join operator; ....someone might look at that, think it's a syntax error, then...

the model database, or any database for that matter, does not contain within itself it's own storage location...that is kept in master....the model database is used for the default schema...

just a follow up; i got the estimated execution plans for a join against two of my big tables using the commands below, and they had both identical estimated execution...

*= got deprecated in sql2005, so i'd suggest switching over to the standard format; it's more readable, and is also ANSI compliant, so you can use the same SQl statement...

i think in this case, you would want to raise an error if the value being tested('xxx') was not really numeric; there was another thread on this same subject, and...

here's another way, note that this does not order the triggers in dependancy order, it just lists them.

select parent_objects.name,

       trigger_sysobjects.name,

syscomments.Text

 from sysobjects trigger_sysobjects

inner join sysobjects parent_objects on parent_objects.id=  trigger_sysobjects.parent_obj

inner join syscomments...

this sounds like an error returned from a program, not a SQL server error. you'll need to review the source code of the application raising the error.

you might want to...

emabarrassing...my home server crashed, and I can't seem to locate a copy of this that I created. If anyone still has it, could you forward me a copy so I...

it's the index seek you would worry about when it comes to sorting.

If a SQl statement says WHERE PK='2002', the sorting is used in the PK's index to quickly lookup...

situations like this is where I switch from doing everything in TSQL, to grabbing the data in .NET or vb6, where the String variable type does not have this limitation;

I'll...