Are the other databases located in the same directory?

Care to share a link to the article? Not really sure what you are asking about and that would help.

Glad to be of assistance.

Gift Peddie (12/1/2009)

---

Lynn Pettis (12/1/2009)

---

Gift, he is trying to look at the code behind the system views which is not possible by right clicking on the view in the Object...

Having taken a cursory look at GSquared's code, I'd give it a try.

Gift, he is trying to look at the code behind the system views which is not possible by right clicking on the view in the Object Explorer in SSMS.

Okay, so let us take another tact. Let us start with a table of customers across the US. You want a list of customers in California, for instance.

Here...

Bru Medishetty (12/1/2009)

---

dmoldovan (11/30/2009)

---

Also if you do bulk data import / inserts, change the recovery model to "bulk logged" or "simple". BOL will guide you through the steps you need...

Will STARTUP_TIME always be greater than SHUTDOWN_TIME, SLEEP_TIME or HIBERNATE_TIME?

You could try looking up CONVERT in BOL (Books Online).

select convert(varchar(10), getdate(), 108)

Do you mean DDL (Data Definition Language) or DLL (Dynamic Link Library)?

Double posted, please reply here.

It is obvious that this procedure has not been run on a regular basis on the DEV system. You are going to have to modify the procedure there to...

RCC-JAXDBA (11/30/2009)

---

The best way to handle this in a production environment is to cap the size of the log file so it does not fill up the entire disk or...

My thanks to you also, Steve. Keep up the great work, you are a terrific steward for this community. I have learned more about SQL Server since becoming...