Not when, but you can tell that an object was modified based on the base_schema_ver column in sysobjects. The only benefit is derived when you compare current to prior...

Try this:

SELECT RETUDATE

FROM SVC05000

WHERE RETUDATE = (SELECT CONVERT(varchar(15),getdate(),111))

Be great!

Michael

select into's, truncate table

See Books Online for more examples.

Be great!

Michael

What a professional advertisement and first impression of your "company."

Be great!

Michael

It is an asthetic thing. char(13) is the code for a carriage return. Removing it would put all the SQL on one line. Nothing magical.

Be great!

Michael

Just curious, why do you want to drop all statistics?

Be great!

Michael

Running profiler would give you that information. There is nothing stored in the database that tracks that.

Be great!

Michael

This should generate the necessary SQL to facilitate your request.

SELECT "UPDATE "+so.name+char(13)+

"SET employee_id = 1006"+char(13)+

"WHERE employee_id = 7006"+char(13)+"GO"

FROM syscolumns sc

INNER JOIN sysobjects so

ON so.id = sc.id

WHERE...

I will echo the other 2 responses and add that disk space could be an issue. It all depends on the frequency of log dumps, size of each log...

Try:

DELETE TABLE_NAME

WHERE pacode IN ('a','b','c','d')

Be great!

Michael

Main production server is 1.4T!

Be great!

Michael

Other possibilities, that allow you to search by area, are

http://www.computerjobs.com

http://www.dice.com

Be great!

Michael

What about when the base_schema_ver is higher than schema_ver?

Be great!

Michael

What about when the base_schema_ver is higher than schema_ver?

Be great!

Michael

I created a table and altered a column. The resulting schema_ver value is 16. All subsequent changes incremented the value by 16. Can I assume that is...