The answer "I don't know" was 100% correct in my case (of course, it's not now).

I've worked for managers who were useless in their current role, but brilliant if you needed them to answer technical questions. I've also worked for excellent managers who took far...

I realise this is an old thread, but I've stopped receiving the newsletter. It was getting increasingly sporadic over the last few months, but I've not received any at all...

To answer the original question; this

http://www.sqlservercentral.com/Forums/Topic1752249-1292-1.aspx

is recursion.

It looks as if only one connection is being used. When does the error occur; on table creation, row insert or the select?

I don't think anyone "builds his business on millions of lines of code". What happens is that systems get written and then things change (the changes are frequently made by...

Does that mean I get a toaster now?

We're probably going to be getting the Redgate tools fairly soon, so the developers will start using SQL Prompt. One of the things I need to do is set the...

Yes, we've noticed that it frequently puts superfluous brackets around the default expression in the script so that the resulting constraint in the database doesn't match the project and gets...

No apology required; it's always worth understanding what the tools are doing for us. As noted in a previous post, the problem I have is also occurring outside SSDT, so...

There is no trigger that would prevent this change. Another constraint change to the same table worked fine.

It's not SSDT after all. As suggested, I tried copying the DROP and CREATE statements from the deployment script into an SSMS window and ran them there. No errors, but...

If your problem is with joins or comparisons between columns in the temp tables and those in your database, you can specify which collation to use at that point, eg.

Select...

People don't (always) ask simple questions, but...

"Getting on" with people is an important skill, but it's not defined by being able to socialise outside work. I'm currently in a small(ish) department of about 30 people and...