Hi vinothd;

basically the script does two things, it creates a trace on the server; server side traces do not have an appreciable impact on the server.

second, it creates a view...

thanks matthew; I'm glad it looks like it might be useful for you.

it's something i play with when i have spare time; it started out before varchar(max) was available, but...

definitely fatfingered...i meant to say EXEC will use all you pass it, whether concatenated (max) variables or whatever, where sp_executesql is the one that will truncate at 4000; thanks, and...

sp_executesql, even though its an "internal" stored procedure, is still a proc, and it has a parameter that is an nvarchar(4000);

EXEC is a command, and has no parameters.. just...

I...

in addition to what ps said, maybe your friend sent you a backup file which contains more than one backup, and you restored only the first backup in the file,...

anything in double quotes or square brackets are expected to be a column name, not a static value:

SELECT 0 AS SupplierID, "All Suppliers" AS CompanyName

--should be

SELECT 0 AS SupplierID,...

I will add the obvious:

As you spend more time here, you'll see a lot of posts that help people get away from "procedural" Row By Agonizing Row Processing to Set...

service packs are cumulative...so everything that was in SP1 is also in SP2, and everything that was in SP1 and SP2 exists in Service pack 3, so you only need...

there is a scripts section here on SSC with literally thousands of script contributions.

you can use the search feature in the upper right corner of this page...

i used it to...

the default value for a column is used only if the column was not referenced in the insert.

if you include the column and it's value in the insert, the default...

doh i did not know using SSIS was a requirement....sorry...

here's how i did it:

i created a userdefined function that evaluates the three temperature types, and used a Calculated column fo rthe "flag" field.

Note I changed a few table and...

that is the advantage of SET XACT_ABORT...

i think if you want code to stop on an error, you want to use SET XACT_ABORT ON and use a transaction...in that situation, when an error is raised, execution...