Or you can use EXISTS:

SELECT

sno, sname, address,

CASE

WHEN EXISTS(SELECT 1 FROM dbo.StudentDrillEnrolled sde WHERE sde.sno...

Check out OBJECT_DEFINITION(). That returns a single nvarchar(MAX) that is the whole procedure, rather than 255 characters per row (artificial "line"?) that sp_helptext seems to do.

I find it useful...

In SQL 2008, if you want a specific user to be able to execute any stored proc (existing ones and newly created ones), you can do this:

USE <your_db_name>

GRANT EXECUTE TO...

Lynn Pettis (3/5/2013)

---

ScottPletcher (3/5/2013)

---

Lynn Pettis (3/5/2013)

---

ScottPletcher (3/5/2013)

---

Jeff Moden (3/4/2013)

---

I'd love to take the credit for it but it's not my code. It's Scotts (although I'd have done it the...

There's no physical db differences from Enterprise to Std, so if the SQL version numbers are the same, you should be able to restore all dbs, including system dbs, from...

Lynn Pettis (3/5/2013)

---

ScottPletcher (3/5/2013)

---

Jeff Moden (3/4/2013)

---

I'd love to take the credit for it but it's not my code. It's Scotts (although I'd have done it the same way).

I was...

Jeff Moden (3/4/2013)

---

I'd love to take the credit for it but it's not my code. It's Scotts (although I'd have done it the same way).

I was just curious as...

GilaMonster (3/4/2013)

---

ScottPletcher (3/4/2013)

---

Again, rigid overly-simplistic rules such as those will give you a poorly performing database with excessive nonclustered indexes to cover all the queries the clus index can't because...

Jeff Moden (3/4/2013)

---

@scott,

Where in the world did I suggest using a format code...

Uniqueness should not be the primary consideration for a clus key. Uniqueness should be a factor, but it's not the most important factor. The proper clus key depends...

GilaMonster (3/4/2013)

---

ScottPletcher (3/4/2013)

---

GilaMonster (3/4/2013)

---

Bear in mind that a clustered index implicitly includes all...

GilaMonster (3/4/2013)

---

That's when you're trying to reduce the initial...

GilaMonster (3/4/2013)

---

Bear in mind that a clustered index implicitly includes all the columns...

Ok.

At any rate, typically you'll want to cluster the table on the most common queries that can't be easily satisified by a nonclustered index you need anyway.

For example, if (nearly)...

You're going to exactly the same version as originally, right?

I think it's easiest to just restore all the dbs (other than model) after the switch.

There are so many things in...