I personally prefere msdb deployment. It really depends on how much you want to worry about maintaining backups and the like on msdb vs. using a file system backup,...

My waistline.

dso808 (12/9/2010)

---

Thanks Only4! BTW, could you please explain to me this part:

SET @sql = ' SELECT * FROM PROBLEMTICKET WHERE 1=1 '

I'm not familiar with the...

Relatively sure every member of the Thread is...

Thank you. 🙂

No, I had meant it as personal. ...

Sounds like a classic 'Double Hop' issue. Just google that phrase with sql server and you'll get a ton of information.

The short form is that anything that routes more...

Stefan Krzywicki (12/9/2010)

---

As a consultant I go on many interviews and see even more job listings. Most listings include quite a bit that isn't needed for the job or understood...

TalkSql (12/9/2010)

---

Great article Craig,

It was really put well, I now know where to focus more as a developer now and how to steer myself to the next level. I just...

Sad...

:blush: First, thank you all for your kind words. I came on ~1/2AM my time out of perverse curiousity and must admit, I was worried. It had 600...

Black Holes

Unfortunately, you can't.

You can do some template manipulation of the base package, though:

http://blogs.conchango.com/jamiethomson/archive/2005/11/12/2380.aspx

Your best bet is to start here:

http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx

FYI, second link in Google with : Sql server database certification.

Dig into the second tab and the specific test information. This is the...

Just so you're not left in the wind...

Yes, I've seen this issue regularly. Unfortunately, I don't have an easy fix for you. It falls under the 'grunt work'...

nVARCHAR for Unicode. You mention...