Should work. I usually build up an @sql variable (or whatever name you give it) and print it, try running it in QA to make sure it's valid syntax -...

Two places where I'd look to start with - one is the query being blocked? The other is are you setting up indexes?

Once you've done the initial snapshot is...

If its a long term situation, probably worth considering. If its a short term project, I'd be more inclined to just dump into an Access db, let them clean away, then...

Glad the switch to turn things off helps. I dont think its the software, I show 14 messages sent to that domain in the last 7 days, 12 of them...

Havent had time to get to it yet, still a couple larger issues we're fixing.

Nope. And by default MSDB is set to simple recovery, so you can't normally use a tool like Lumigent to rollback the change. Best bet is to restore MSDB under...

We'll definitely take you up on that! I've forwarded article standards to your email address.

I guess the first question is why a string id? Typically integers or uniqueidentifiers are used. Unless the value will be made of some component of the data itself even...

I see no reason to restrict the tools, plenty of reason to restrict what they can do with the tools!

I think that makes sense, it's truly just text.

I could probably get the emoticons back, but probably just as well to leave light weight.

Generally you should index foreign keys. I usually only create conposite indexes when I need to cover the query, or because its a constraint.

Password wont matter - unless is not really blank! I'd suggest changing that to a strong password as well.

You can map a drive, just have to make sure it's mapped under the agent account.

Test post only!