Very good question and a clear explanation. Specification of NOT NULL is obvious, I just hadn't woken up yet and didn't read the table schema properly... must drink my coffee...

I know this is late in the day, and you asked a year ago, but I was looking for the answer too and came accross your post.

From some poking I...

Srinath what a great call you gave about "DTS Backup 2000"!!!

First off I couldn't get the DTS package stuff working on one of the machines. Just wouldn't work. Then found...

Did this without query analyser.. and got it right, nice.

Hi wall str33t,

Nice question!

Hi Charles,

Both queries will give the same error, but the question was asking what was returned in...

I read to quickly, saw the word "only", clicked Enterprise pressed submit, then wanted to cancel as quickly as possible, but it was too late. Dev edition has the same...

Didn't work for me without a holding down the control button. I use SSMS 2008 every day and it's the first time I've come accross this feature.

Incidentally, what would you...

Damn I got the answer correct, I must be wrong :w00t:

It's the responsibility of whoever asks the question to know the right answer. Its the responsibility of those that answer...

Does synonym usage work in both tibbled and non-tibbled worlds? You know what it's doing by usage if you're looking at something that's using it... but you don't know what...

GilaMonster (1/25/2010)

Now that's a clever trick I hadn't though about... but then the dev's would now also need to know which are views with triggers on.... Hmm not something...

Ok there's no way I am prefixing database names with "db", no way I'd prefix column names. But views, functions and procs yes. Tables, well I don't think there's a...

Hi Jonathan,

Thanks for the info. Think they managed to hook up the MS driver and could get back strings. They were using the JTDS back in August, but have since...

Doh... having a google for the same topic, came accross SQL Server Central and thought ah now there's the money shot...

Except it's my oringal unanswered question.. deep doh!

I know one thing, I'd hate to work in a call centre... even if you wanted to help the company may not allow you to either through rubbish systems or...

Hmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm.. ok honesty first: I've not done what you're doing, so am guessing. Whether it will help or hinder, I don't know. Hope it does help though:

Could be a bug...

However you've set it up to look for that file, use an expression to overide.

How you do the expression is up to you. You may be running it month by...