Viewing 15 posts - 1 through 15 (of 41 total)
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...
November 6, 2003 at 11:04 am
Try this:
SELECT RETUDATE
FROM SVC05000
WHERE RETUDATE = (SELECT CONVERT(varchar(15),getdate(),111))
Be great!
Michael
July 28, 2003 at 9:08 am
select into's, truncate table
See Books Online for more examples.
Be great!
Michael
June 10, 2003 at 8:39 am
What a professional advertisement and first impression of your "company."
Be great!
Michael
June 3, 2003 at 7:58 am
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
June 3, 2003 at 7:55 am
Just curious, why do you want to drop all statistics?
Be great!
Michael
June 2, 2003 at 1:28 pm
Running profiler would give you that information. There is nothing stored in the database that tracks that.
Be great!
Michael
June 2, 2003 at 1:26 pm
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...
June 2, 2003 at 1:21 pm
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...
December 11, 2002 at 11:45 am
Try:
DELETE TABLE_NAME
WHERE pacode IN ('a','b','c','d')
Be great!
Michael
December 10, 2002 at 1:36 pm
Main production server is 1.4T!
Be great!
Michael
December 6, 2002 at 8:28 am
Other possibilities, that allow you to search by area, are
Be great!
Michael
December 5, 2002 at 1:22 pm
What about when the base_schema_ver is higher than schema_ver?
Be great!
Michael
December 5, 2002 at 9:30 am
What about when the base_schema_ver is higher than schema_ver?
Be great!
Michael
December 5, 2002 at 9:28 am
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...
December 5, 2002 at 9:22 am
Viewing 15 posts - 1 through 15 (of 41 total)