I'll be darned. :blush: Learned something new today! I've used my script for so long, never tried to find a better (easier) way to do it. Thanks.

Thank you SA. My recommendation, to expand on it a bit, was not meant to be a blow-off of your quest for help. The biggest thing you can do is...

Why are you trying to do this? The preferred method would be to backup local and then copy the backup file to a network share. It can be done using...

Learn to use search engines. I just did a simple search here and found this as the first article. Also, have you looked through BOL??

http://www.sqlservercentral.com/articles/career+growth/64632/

Edit: here is another post to...

While this definitely will work, it won't provide the table name that the index is associated with. In an earlier post I...

I too selected the most accurate, albeit incomplete, answer.

I couldn't agree more but I'm sure with the volume of...

Gaby Abed (3/16/2009)

---

Why do I suspect that we're slowly being led to a point where he wants us to solve an actual problem at work, rather than just a general...

Something like this. Keep in mind, I use this is SQL 2000 and it will need to be tweaked for 2005/2008. Modify the like clause to suit your needs.

select ...

I'll bet that index exists on a different table. I've got a script at home to find indexes and the associated table. If noone has supplied it to you by...

DOH! I jumped right into the article after glossing over the title. I should have realized it when it stated Lynn was a "new author"... from now on I gotta...

Very poor forum etiquette -don't you think newB?

If I understand your request correctly, the file share physically resides on your SQL server box, correct? And your stored procs refer to \\servername\..., which is the local box? If...

You mean we don't get PAID? I'm so out of here.....;)

george sibbald (3/7/2009)

---

t.walker (3/6/2009)

---

I really support that idea. I think a more private invited members forum would enable me to speak more freely/

Although I am a rookie here, I am...

I didn't think that was even an issue. The issue is about the recovery of the database, not...