suraj.app (8/31/2010)

---

Hi,

What is advantage of cursors. What ever we can do with cursors can also be done using while loops, temp tables.

So, what is the advantage of using cursors...

winston Smith (8/31/2010)

---

I know i can study these areas outside of work, and i have done, but im one of these "use it or lose it" people. if im not...

If you're talking about actually performing a database restore, then your biggest issue isn't the GRANT permissions. It's going to be missing/orphaned users.

Missing users is obvious. Orphaned users is a...

George has some excellent thoughts on this. Further, I agree with Steve about having 3 databases only if you anticipate moving them to different servers in the future.

If your thoughts...

Tom, it actually sounds like you really needed some Cold Coffee :w00t:

GilaMonster (8/31/2010)

---

Brandie Tarvin (8/27/2010)

---

ACK! We've been invaded! There's one of those...

Hugo,

Great question!

It's too bad that this latest post wasn't part of the explanation for the question though - it's beautiful.

For those that have read this far, I'd like to suggest that you read this blog[/url] by Gail Shaw on working with this type of query (catch-all query).

You could do a select count(*) from inserted within the trigger.

Alternatively, in the code running the update statement, look at @@rowcount.

I just wrote this script to get all of the database mail profiles and...

Not that I'm aware of. I'd like this also.

SSIS will not do this automatically.

However, you can use a vb.net script task, excel automation, and set it all yourself. However, this would imply that you are running excel on...

No...

Uncle Moki (8/30/2010)

---

I'm not sure if I can. Let me see if I can duplicate this problem with a simple example that doesn't disclose anything my company might get...

I don't see anything here either. Can you post the CTE?

Edit: There might be an implicit conversion going on somewhere.