If it helps, here is a script I use that creates a script to run to find the differences between the records in the same table in two different databases...

I worked for 14 years as a Programmer and BSA at a 401(k) recordkeeping company (third-party administrator). We had to use the "Penny Toggle" method. Basically, it meant...

You could use a UNC path in the backup script:

BACKUP DATABASE MyDatabase TO DISK='\\somepc\c$\SQLBackups\MyDatabase_backup_201203011300.bak'

As long as the user has access to that path (through their Windows Authentication), it should work....

And yet, another one....

Here is a link to one that I wrote to do an Instance Audit. It shows all users and roles assigned by database, and their individual...

SINGLE_USER mode allows only a single user at a time, but could be anyone.

RESTRICTED_USER only allows members of the db_owner fixed database role and the dbcreator and sysadmin fixed server...

I have to send a data extract every 15 minutes to an FTP site. Here is how I do it.

(Note: File name, then ====== line, then the actual contents...

See this article on SSC to load the SQL Server error logs into a temp table for research (it does some deletes of certain records, so delete them only if...

Here's my script that uses the backup sizes. Checks every two weeks (1st, 8th, 15th, and 28th). Does pct change from previous backup size, and overall avg pct...

Sure.

If on Server 2003, do a right-click on My Computer and choose Manage. Under System Tools, expand Local Users and Groups.

On Server 2008, go to Server Manager,...

I agree totally. I would recommend adding an audit table, and keep track of changes there by using a trigger to insert the important information to the audit table...

If you don't have access to AD groups (to create new ones and insert the people in them), then you can create groups on the local SQL Server box and...

Also, if you want that trigger to send you email, you will need to turn on Database Mail (DBMail) in order to use it.

To get you started, here is a...

Here is a link to a previous post, where I gave more info, and gave some scripts to play with to learn CLE.

http://www.sqlservercentral.com/Forums/Topic1152176-391-1.aspx

There are several other issues that might play into the decision.

Column-level encryption (CLE) does not allow the indexing of the encrypted column. If that column is in a WHERE...

Sorry, didn't notice the "local" part. Back to lurk mode.....