I don't get an error, strange or otherwise from query 3. To be honest, I'm...

To add a little more info, this is reproducible on 2012 and 2008 (and R2), but not 2005.

In 2005, the execution plan shows two separate constant scans and two filter...

This sounds like a Paul White kinda thing!

Smells like a bug in the execution plan to me.

To distil the unexpected result down to it's simplest form, this query will (sometimes)...

I've up-voted it and confirmed I can reproduce

Chris Downing (7/25/2013)

---

We're using an OLEDB Command task to execute the stored procedure, and I believe that treats it as dynamic SQL and executes that new system sproc as part...

Ah, I see. sp_describe_undeclared_parameters is a new 2012 proc.

Yes, I get the same result.

So is SSIS 2012 executing this statement as part of it's internal validation routines, or have you...

That's odd. The collation of both the user and system databases is case-insensitive?

I guess it's possible there were changes around this for contained databases, but system procedures have always followed...

HowardW (7/24/2013)

---

sharath.chalamgari (7/24/2013)

---

I was trying to restore the master database but couldn't able to connect to sql server using sqlcmd and even when i use the single user mode flag....

sharath.chalamgari (7/24/2013)

---

I was trying to restore the master database but couldn't able to connect to sql server using sqlcmd and even when i use the single user mode flag. in...

So, what's happened to the path in the error message? Assuming this has corrupted/been lost, restoring master from a backup would sound like the best plan:

http://msdn.microsoft.com/en-us/library/ms190679.aspx

Bear in mind that this...

Have you lost your E drive in the crash? Are your user databases there as well?

The issue for me is that it hasn't moved with the times,...

Not sure why that matters. Whatever you're using to generate your references, you should be able to define a...

Yep, indexed views are the answer. You can join the two tables in a view and create a unique clustered index on the view for the required columns. It will...

Brandie Tarvin (7/17/2013)

---

HowardW (7/17/2013)

---

Brandie Tarvin (7/17/2013)

---

At risk of being lynched for bringing a code convo into The Thread...

Is it just me or does SQL 2008 not script out DROP CONSTRAINT...