You might try restricted_user mode, which only lets Db_owner/sysadmin in. That might work for you.

I might also recommend Andy Leonard's blog: http://sqlblog.com/blogs/andy_leonard/default.aspx.

He is also doing a class later this year on SSIS. You can pick up an SSIS book as well, which will...

I'm not sure what you mean by transaction logging. Do you mean transactional replication? Or log shipping?

Replication works at the table level, and shoots changes across either on a schedule...

I would think that the 32 v 64 doesn't matter for most clients. There are some drivers on the server that might have an issue, but not the client.

Can you...

Ah, I haven't added it to the Zune marketplace. Should, and I can only say I've had a bit of the Apple iPod bias here.

The feeds are:

WMV - http://feeds.feedburner.com/SqlservercentralcomArticlesTaggedEditorial-Wmv

MP4...

sysinternals: http://technet.microsoft.com/en-us/sysinternals/bb896653

Thanks for the update. I was going to suggest IP connections.

The networking gets a little funny at times for SQL Server since we are so used to using the Windows...

Any edition other than Express can restore this.

Be aware if you change versions, as Gail mentioned, you cannot go back to the old version after the restore. You can, however,...

You can use a script like this to kill connections: http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31833/

Jeff Moden (1/3/2011)

---

If someone doesn't already have enough reasons to avoid the cloud, here is a recent post that may contain some additional reasons you may not have been aware...

I would lean toward's Eric's advice. Less info in print, make it impactful and interesting to the reader so they have a reason to call you.

As for the font, Helvetica/Arial/times,...

How much work are you doing in there? As written, you are not locking the table immediately and it won't be until the end during the update that the table...

What do you mean "required comments" and online documentation. Are you looking for an HTML file of your stored procedures? What information do you want in there?

There are a...

I'm assuming this isn't a growth issue in msdb and new history notifications are being logged.

My guess is someone cleaned it out. The default trace is probably too old for...

I like Grant's advice. Note that if you have enterprise edition, I might use a Database Snapshot instead of a backup for a quick rollback if that is possible.

Note that...