Nope I don't know why she is only re-orging partitioned indexes. I'll ask.

This is how SSMS generates the trigger text:

exec sp_executesql N'SELECT

NULL AS [Text],

ssmod.definition AS [Definition]

FROM

master.sys.server_triggers AS tr

LEFT OUTER JOIN master.sys.server_assembly_modules AS mod ON mod.object_id = tr.object_id

LEFT OUTER JOIN sys.server_sql_modules AS ssmod...

Have you tried it without the conditional for just the first column so see if the conditional is causing the problem?

RAISERROR does not abort the batch. The process will continue after a RAISERROR unless the RAISERROR is withing a TRY...CATCH block. In a TRY...CATCH block RAISERROR sends it...

I think you want sys.server_triggers

If you are using either Michelle Ufford's or Ola Hallengren's index maintenance script which checks index stats so that maintenance is done only on indexes that need it, then you...

You can't reference table3 because it isn't in the query. Shouldn't it be table1.k1 = T2.k1

He will as long as there aren't any almonds. 😛

Jim Murphy (11/22/2011)

---

The other organizer of our SQLSaturday in Austin (#97) just compiled the speaker feedback evals. I came in 3rd overall! I'm pretty pleased since it was...

Check out the last 2 articles linked in my signature.

Rob-350472 (11/23/2011)

---

I'm trying to colour a range of values with the following approximate categories:

= 0.00

+/- 0.01-0.03

+/- 0.04-0.20

+/- 0.21-0.99

+/- 1.00+

As you can see basically distance from zero, zero should be white,...

Here's an article[/url] that talks about how to do it. Be sure to look in the discussion as well because there is a link to a custom component I...

Andeavour (11/23/2011)

---

Sounds like the package is using your authentication when you're logged in to Management Studio, and presumably the Agent account authentication when your not, and I would guess the...

What is the error message?

Usually you specify the name when you attach a database to a new server. What did it get named?