Weird. I guess I'd be poking around in settings if it were me. But sounds like you've already done that.

Call Microsoft? Should have some free support tickets...

Cool biz.

Not sure what you mean about SSIS not being able to do a "dynamic command string". It can do dynamic connections, and dynamic queries.

But the main thing you're running...

What version of SQL Server is your database on, and what compatibility level is the database? Native SSMS intellisense is affected by that, if I remember correctly. (I...

Whatever works for you. As mentioned, they've all got pros and cons.

Edit: So far as I know, CDC doesn't use any triggers. It's basically just an automated log-parser....

GilaMonster (12/13/2012)

Sch-M is a schema modification lock. Taken by...

Not clear on one thing: Intellisense in Visual Studio, or Intellisense in SQL Server Management Studio?

Another thing I find useful in SSMS, is use the Tools->Options->Environment, to change from "Tabbed documents", to "MDI environment".

Then you get individual "windows" for each connection, and you can see...

The green icons mean SSMS can tell that the SQL Server service is running. White means it doesn't have access to that data, so it's not sure.

Connections don't change...

Autoshrink will shrink the database when there's 25% space available, per http://msdn.microsoft.com/en-us/library/bb522682.aspx.

But it's almost always a really, really, really bad idea to turn on autoshrink.

You can also schedule a database/file...

Sch-M locks are schema locks. Means you can't change the definition of the table during the bulk insert. Might mess the whole thing up if you were to...

I don't have access to your database, so all I can say here is that the query is doing what you're telling it to. You just have a different...

I just noticed something. Doesn't mean it's new, just means I just noticed it.

Per the standings page (http://www.sqlservercentral.com/TotalScores), I'm still listed as "SSChampion", just like everyone else with serious...

Ah. Audit trails.

CDC will work for that. There are a number of other options, each with its own pros and cons.

I generally prefer to use triggers that capture...

I don't think that's a regex issue. Wouldn't you just use a find with a "and not" in it? Find anything with CREATE, and not with the regex...