Can you provide more detail on exactly what it is you are trying to accomplish and what your problem(s) actually is/are? Also please provide 3 or 4 tables and...

Others have addressed the permissions problem. I will address the fact that you are using Maintenance Plans in the first place. Please go to Ola.Hallengren.com and start using...

1) Search web for Glenn Berry SQL Server Diagnostic Query. Learn to use the goodness therein.

2) From his version for 2012 you will find this:

-- Top Cached SPs By...

dwain.c (1/21/2014)

---

TheSQLGuru (1/21/2014)

---

I think it has to be a Gaps & Islands problem, based on this statement if for no other reason:

An assignment is defined as a continual period of...

I think it has to be a Gaps & Islands problem, based on this statement if for no other reason:

An assignment is defined as a continual period of employment at...

Search web for Itzik Ben-Gan Gaps Islands SQL Server. He has numerous blog posts/articles on SQL Server Mag that will help you here.

Here is my attempt at this. It took me a while to dot the i's and cross the t's and I noticed someone else had a posting too. ...

Sean Lange (1/21/2014)

---

SQListic (1/21/2014)

---

i All,

I want to Update column A1, when column A2 and A3both are NULL or have invalid data.

If A2 has Valid Data ignore next steps ,if...

I'm with the other two (as I am 99.x% of the time).

I will add that you can find out a LOT by yourself by doing 2 things:

1) running...

You posted this in mirroring forum, so if mirroring is actually set up you can use the monitor gui for that to see how backed up things are.

Also,...

Not enough time to check, but does tempdb.sys.tables show temp objects that aren't yours? Also, does it provide a name that is "droppable"?

GilaMonster (1/16/2014)

---

They are, they always have been. Drop a temp table and you can't access it any longer. Essential when testing code...

Why do you want a script to do this? Temp objects are automatically "managed" by the engine. Just close the connection and you don't have to worry about...

crcoracle (1/16/2014)

---

Hi,

Do you guys know if I can set up a new SQL Server cluster with AlwaysOn Availability groups as follows:

- One node inside the local network

- Another node in...

I did the Common TSQL Mistakes session on...