Reality - What a Concept (-- Robin Williams)

😎

Also, you can't use a variable in a select statement for a tablename, unless the variable itself is a table variable (confused?).

What you are trying to do would require the...

Betty Sun (7/9/2008)

---

Hi all,

I have a stored procedure. But it seems that you cannot use variable for a table. variables are only can be used in condition expression? What about...

Okay. Good to know. And yes, I still want to run the UPDATEUSAGE. It just really bothered me that I couldn't remember it.

Thanks!

😎

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

😎