john.arnott (3/29/2010)

---

After skimming through it, paying a bit more attention to the posts from you-know-who, I would have to suggest that any further pain resulting from interaction with that particular...

Jack Corbett (3/29/2010)

---

I usually never unsubscribe from any threads, but I did from that one....

Lynn Pettis (3/29/2010)

---

CirquedeSQLeil (3/29/2010)

---

dma-669038 (3/29/2010)

---

I meant that as a joke, kinda lost it 🙂 Anyways nobody has to be 'certified' to discuss..we are sql server professionals and involved in this...

Run the following and let us know this info.

SELECT SERVERPROPERTY('EDITION');

SELECT SERVERPROPERTY('PRODUCTLEVEL');

SELECT SERVERPROPERTY('PRODUCTVERSION');

Does that filename show up in your msdb.dbo.backupfile table?

Is that file present on the share?

Do you have a dev environment or QA (UAT) environment where you can do this first? This would give you the opportunity to note anything you have missed or...

That would come down more to database design and theory. The ideal size of the table (number of columns) will depend on your application needs and design specifications.

I would...

Albacore

Here is an example for you.

http://munishbansal.wordpress.com/2009/02/20/saving-results-of-a-stored-procedure-into-a-xml-file/

Bumblebee

Avoid the use of nolock.

Document your code.

Format your code and stay consistent. Code that is easy to read is easier to troubleshoot.

Explicitly define your joins (could spare you some...

Was there only one database on the server?

I would be careful about removing the logins. George and Ron provide some nice scripts. I would not execute the code...

bee

Reading that certification thread when you already have a headache - just makes matters worse.

Nice Script. I think I can find some use for it.

crainlee2 (3/29/2010)

---

Wilfred,

What is the purpose of this elaborate query?

(NOTE: I have commented out the ALTER INDEX (DISABLE) statement until I get an explanation of what the query is supposed...