🙁 sigh :([/url]

Ill-judged, possibly offensive, and certainly not funny.

That said, everyone else over-reacted too. Professionalism? This is a forum, not a workplace.

Summary: storm in a...

'Team Mindfire' might like to read the other comments in this discussion. Much better solutions exist.

Several clicks have come from my mouse....

Microsoft...

Bob,

You're welcome - it's amazing how many people don't know about the second parameter.

I try to include it in all my test rig set-up scripts these days to help people...

:laugh: Typical. ...

Another alternative is to change the DEFAULT_SCHEMA for the new user using ALTER USER - see Books Online (http://msdn.microsoft.com/en-us/library/ms176060.aspx)

@bob-2,

Another way to check is:

OBJECT_ID(N'dbo.BrandNewTable', N'U')

The second parameter specifies the type of...

I would also never forgive myself if I didn't mention that another way to this is to use a SQLCLR procedure.

Paul

This is an old problem. INSERT...EXEC runs in an implicit local transaction (an INSERT statement must be atomic, remember) and SQL Server attempts to promote the local transaction to...

You might want to fix the sample output data too.

:laugh: Perfect :laugh:

My own view on the whole ISNULL versus COALESCE...

Brent Ozar (2/6/2010)

---

DAC Packs aren't a solution, though, because they only support a subset of schema objects. For example, you can't include certain datatypes or stored procedures. Thanks...

select * from dbo.sourcea except select * from dbo.sourceb

Quassnoi,

I don't have time this morning for a full reply, and I'm off around the island for the next few days, so this will be just a quick one. ...