to be more clear, it should work when you have it printing this instead of what you have now (notice the extra single quotes around TIN and in other places):

execute...

jan michael woo cerna (5/7/2008)

I have problems in concatenating a sql statement using EXECUTE and Update.

Here's my code:

execute("declare @lcdbname char(11), @lclanguage char(2), @lccurrdb char(11) " +

"select @lccurrdb = db_name()...

You cannot turn off logging. without logging you would not have a proper DBMS.

you can set to a different recovery mode which will minimize logging. simple recovery mode,...

you might want use a tinyint for the PK on a states table if it was being referred to from other large tables.

one of the dbs I have to work...

might as well just say "all clients are evil"

I don't think there is a way to discover this from the metadata.

what I was trying to say in my first post is that if it's already set on some...

good point. that's a real difference.

that only tells you whether a column is an identity column or not. that's not what OP is asking.

are you sure that the columns being aggregated actually have different values in them? if the values are all the same, then the min/max/avg would also all be the...

from BOL:

"If a table already has this property set to ON, and a SET IDENTITY_INSERT ON statement is issued for another table, SQL Server 2005 returns an error message that...

perhaps the query plans for your procs are no longer optimal.

what happens if you recompile all the procs?

PK does not have to be clustered. you can have a non-clustered pk. if you don't specify when you create it though, sql server defaults to clustered for...

this works too:

drop database FOO

🙂

there are lots of examples in the article I posted. Did you have a look?

there are a great many examples of how to do this in this article:

http://www.simple-talk.com/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures