Hmmm...no real resolution to this one that we found in the end, the only way around for us was to add on another drive (not a mount point) and install...

Thanks for the tips but unfortunately they don't go quite far enough.

The sys.tables view simply shows which temporary tables exist in the TempDB and when they were last accessed but...

Found it.

If you have a database on '05 that's running in 2K mode it won't return the resultset correctly. Change the compatability level to 2005 and it works, although...

Note: Here are the result sets with proper xml tags in them

One database returns the dataset as

&ltResults&gt

&lta&gtUser1&lt/a&gt

&ltb&gt1&lt/b&gt

&lt/Results&gt

&ltResults&gt

&lta&gtUser2&lt/a&gt

&ltb&gt1&lt/b&gt

&lt/Results&gt

and...

sp_Password would be needed to if we went with option three, but you have to use a different login as

1. I don't want to give permissions to users to...

The answer to this one is no, there is no nice way of doing it. There are some difficult ways of doing it however:

1. Create an ADO.Net v2.0 component with...

We have been having the debate for the past 2 years about rewriting our applications in VB.Net and we still don't have a great answer for it. Effectively we can...

I am going for Neal Stephenson's "Snow Crash"

http://www.amazon.co.uk/exec/obidos/ASIN/0140232923/203-4330774-9983950

because it had a lot of techie type stuff going on in there with the virtual reality stuff and the...

Ah-ha! I have just found a solution to my own question, so big ups to me.

The solution is to put the following line in the sql file:

IF EXISTS(SELECT 1 FROM...

Another way of doing it is to not comment at all.

(Sorry, I could not be bothered to find the shocked face icon!)

The reasoning is as follows: An inaccurate comment...

We have another solution:

Turn one light on.

Go to the next light switch and turn it on and off repeatedly.

Go to the next light switch, unscrew it and then pull...

How long does it take for a light bulb to get hot? By the time you have mucked around with the light switches, then feeling each bulb in each room...

Well done for missing the point entirely! As the discussion is about education of people then real world employers would be far more interested in getting staff who can do...

A saw a lecture by Mr.Dyson, a British engineer who invented a new vacumn cleaner and made an awful lot of money in selling them, where he thinks that too...

I like it, but I have spent an equal amount of time being a developer as being a DBA so I have a reasonably idea of when it works and...