I don't think there's a way to do that in T-SQL. My solution on similar scripts has been to check for the existence of the folder, and have it...

All they changed is it doesn't have a file associated with it any more.

OCTom (6/30/2011)

---

Teamwork is overrated. I think the skillset and the willingness to learn new skills is more important. I have yet to see an employer value teamwork highly. They speak...

Ah!! Two different things called "Agent". That's what confused me.

I can't say I've used the Symantec product recently. I think I may have quite some time ago,...

Brandie Tarvin (6/29/2011)

---

Hey, gang. We need a few polite responses at this thread here regarding license limitations. He wants MVPs, Microsoft peeps, and resident experts to respond because he doesn't...

You are interpretting a legally binding contract, saying that it does or does not apply to specific or general plans of action with regard to building and deploying software solutions...

I think I may be missing something here. SQL Agent comes with SQL Server, and doesn't have a direct cost associated with it. I'm also not sure what...

repicurus (6/29/2011)

---

Robert L. Jones-330863 (6/29/2011)

---

I do believe that Craig is right. In the file License_EXPR_ENU.txt from 2005 Express it states:

4. SCOPE OF LICENSE. The software is licensed,...

steve.anderson 7639 (6/29/2011)

---

I appreciate all of your replies. This is all good stuff, and yes I am relatively new to direct SQL statements vs .NET development in SQL. ...

Steve Jones - SSC Editor (6/29/2011)

---

LOL, haven't seen that. I have seen people w/ only 30...

Steve Jones - SSC Editor (6/29/2011)

---

Jack Corbett (6/29/2011)

---

Steve Jones - SSC Editor (6/28/2011)

---

Enjoy presenting. Couple things.

1. Breathe. Easy to race through things. Take a moment at a few spots to...

Every place I've worked, I've been given the tools I need to keep the databases running, and the time to do it.

Management hasn't understood the details of what's been needed,...

Essentially, Snapshot Isolation stores row versions in tempdb while they are being updated and selected at the same time.

It doesn't do anything like storing a duplicate copy of your database...

Guessing from the table structure you provided, this isn't a hierarchy at all. You're querying from one table to another. Is that what you're doing?

You're running a query that can't possibly work on your server??? Now I'm confused.