Have you tried running the command outside the maintenance plan? You might get a better error message.

HowardW (9/27/2011)

---

SDB15 (9/27/2011)

---

Use CTEs with care, if the expected row count is very high, you're actually better off with a temp table. I've also read that CTEs have a hard...

It would be easier to help if you posted the Audit definition.

You can often get the same data using a CTE or derived table. Something like this:

CTE:

;WITH ItemCount AS

(

...

You really should see which tables really need an OUTER JOIN and only use the OUTER JOIN in those cases. Also you mention SELECT sub-queries, you don't mean that...

You would need to loop over the rows in the table and execute sp_addlinkedserver for each one.

Since I haven't done those activities in many years I can't relate anymore....

Stefan Krzywicki (9/26/2011)

---

Jack Corbett (9/26/2011)

---

So where is everybody? No messages over the weekend and only 2 today?

I know the Summit isn't for a few more weeks so that can't...

I probably would have gone with the trigger as well, but that's mainly because I don't like having to go outside the table definition to see what a check constraint...

So where is everybody? No messages over the weekend and only 2 today?

I know the Summit isn't for a few more weeks so that can't be the reason. ...

@RDBMS (9/24/2011)

---

A table has dates stored as nVarChar in the format: dd/mm/yyyy. I have added a new DateTime column and want to store the nVarChar dates into this column for...

I believe you either need to use the FOR XML syntax in T-SQL or you can use a SCRIPT TASK in the control flow or a SCRIPT COMPONENT in the...

Jim Murphy (9/22/2011)

---

Say, anyone here know how to admin Sharepoint? Things like changing permissions to the calendar and stuff like that?

People are asking me but I don't have a...

Ninja's_RGR'us (9/21/2011)

---

SQLRNNR (9/21/2011)

---

Ninja's_RGR'us (9/21/2011)

---

L' Eomot Inversé (9/21/2011)

---

Ninja's_RGR'us (9/21/2011)

---

The real short answer here is :

Why = Pourquoi

What for = Pour <space> quoi.

In the case of your sig, it's definitely 1...

Fortunately, because of...