My "Custom Reports" folder was under "My Documents\SQL Server Management Studio". Looks like it's just a matter of creating directories there.

I think it comes down to skill level and personal preference.

Maintenance plans are great for those shops that might not have a full-time DBA. They're easy to...

The auditing feature captures events asynchronously, outside the context of the session, and therefore wouldn't capture the hostname (or the network login) for events like DML.

To capture the...

Does the account the snapshot agent is running under have full rights to this directory?

You're on the right track, but you're not quite there yet. You're correct about using the IP address as the alias's server and using TCP for the protocol.

Your subscriber...

Have you seen this?

You're going to have to use the cloud server's name when you specify the subscriber. If necessary, use Configuration Manager to create an alias on your publisher using the...

SQL Server 2008 R2, Enterprise Edition.

I get an error when I run your query:

Msg 9436, Level 16, State 1, Line 1

XML parsing: line 44, character 12, end tag does not match start tag

Have you tried...

We're using updatable subscriptions with far higher latency, so that shouldn't be a problem. Do all your tables have primary keys?

Is replication an option? Either merge or transactional with updatable subscriptions?

Colleen

To remove a user from a database role, use exec sp_droprolemember [rolename], [username].

Colleen

I'm assuming you're using the SQL Audit feature in SQL 2008. If that's the case, try using the SCHEMA_OBJECT_CHANGE_GROUP rather than the DATABASE_OBJECT_CHANGE_GROUP.

Colleen

I've looked into a number of auditing solutions (DDL, not DML) and they all seem to have their drawbacks. For SQL Server Audit, the lack of the client-side information...

Have you tried using xp_delete_file? Nothing wrong with the method Geoff suggested, personally I'd rather not enable xp_cmdshell unless it's absolutely necessary.

EXECUTE master.dbo.xp_delete_file

0-- 0 = backup file,...