And don't take your directors (old managers) attitude to personally. Your manager probably told him that he couldn't work with you so he has a choice between getting rid of...

Haven't looked at this very carefully but it doesn't seem to cater for entries that are split across pages in syscomments.

Would also maybe return false entries if one statmet has...

mjschwenger (9/30/2007)

---

I do not believe that this is an issue of using bind variables or literals.

Please, note that the slow statement is the one that uses bind parameters, not literals....

Sorry to hear about what's happened to you (again?).

"So I am not a team player ? All I want is to do my job. Actually all the past years I...

How quickly do you need this to run?

If SMO is too slow it implies that your database structure is very volatile so maybe you should look for a solution that...

Glad you've solved the problem.

Be careful about any code that tries to generate a row number using non-unique data. It probably means that different calls could generate different values for...

Depends on the context.

If you are talking about backups:

restoring is creating the dtaabase from the backup file - by default this will also recover but you can prevent this step....

How are you doing the copies?

Sounds like a select * into from query analyser which will just log the extent allocations (ish).

Maybe dts is doing a create table and logged...

First thing to do is to check that the source database is ok.

Try selecting the max value for that column and see if you get an error.

Try dbcc checdatabase also.

What...

Sounds like you will need to do this multiple times.

I usually create a job to do it - backup the source database then restore it with move and replace.

Then all...

Try

information_schema.columns

or syscolumns (a bit more difficult to interpret)

you can choose the columns to return.

see

http://www.nigelrivett.net/SQLTsql/BCP_quoted_CSV_Format_file.html

Jeff Moden (9/30/2007)

---

nigelrivett (9/29/2007)

---

There is a case for auditing inserts - it depends on what you are using the audit trail for.

If you want to report on full history of...

There is a case for auditing inserts - it depends on what you are using the audit trail for.

If you want to report on full history of the data then...

Jeff Moden (9/29/2007)

---

Well, I'll be damned... Now I know who to blame... 😀 (NOT Phil... Pop Rivet!)

I've had...