Oh, should I do that before or after DBCC UPDATEUSAGE? Couldn't remember the DBCC command so I started with updating the statistics.

😎

Mani Singh (7/9/2008)

---

After upgrading the Databases:

1. Change the Compatiility Level to 90

2. DBCC UPDATEUSAGE

3. DBCC CHECKDB (DatabaseName)

4. Copy all the logins associated with the Database OR ALL using this...

No, something about statistics, and something else. Just having one of those "blonde" moments (or in my case, old-timer's moments).

PORK CHOPS!!!!! (lol) :w00t:

Couldn't resist (well, I could have, but didn't want too!)

😎

I also think that the car (generic here) is also a symbol of freedom. You can go where you want when you want. I did a very short...

Clive Strong (7/9/2008)

---

Lynn Pettis (7/9/2008)

---

Clive Strong (7/9/2008)

---

WFH...Hmmmm the Xbox360 is there - bad idea.... 😛

But yes, the price of petrol is a killer...As I catch the train, I rarely use...

Clive Strong (7/9/2008)

---

WFH...Hmmmm the Xbox360 is there - bad idea.... 😛

But yes, the price of petrol is a killer...As I catch the train, I rarely use the car these days,...

I've actually been told by my manager that I come across as arrogant. I don't mean to be, but there are certain things that I do feel strongly about...

Mkumari (7/8/2008)

---

The best i would do is select the rows that are to be keptin a new table and rename the old one to someting and rename the new one...

john.leo (7/8/2008)

---

I'm still not clear why SQL Server doesn't auto shrink the transaction log when a full backup is done in the full recovery model. No transaction logs are needed...

Double posted.

See this link: http://www.sqlservercentral.com/Forums/FindPost530278.aspx

😎

Try this:

alter table clients

Add SceneFlag [char](1) NOT NULL DEFAULT 'Y'

😎

If you post your current DELETE code, I am sure that there are individuals out here who help you modify it to delete small batches and thereby control the size...

I'd have to agree with Steve. I actually enjoyed every IT position I have had to date. Things got really bad at my last employer during that last...

I have used sql_variant in a database I was using for data analysis of data stored in a database. The only thing I couldn't store was blob data, or...