Search results for query: *

I am trying to duplicate a production server to a test server and would normally just restore the user created database, say MY_DATABASE.  Sometime when I do this I run into problems with user id's because the logins weren't the same.  I tried restoring the master database...

I was wondering if there was a way to grant just these to permissions to a role.  I found the db_ddladmin role out there which allows the grantee to perform these plus many more.  I would like to have a couple people to be able to create tables, but not stored...

I would like to have a job run automatically to scan a directory and zip the database backup file and then transfer to another server to be backed up to tape.  Does anyone have a sample script or any suggestions on the best way to perform this.  Any help would be GREAT ! Thanks,

Does anyone know if this is possible?  I have create some DTS jobs which perform some transformations.  I had planned on running them every 10 minutes, but now the requirement is to run them based on new inserts into the source tables.  Can I perform this with a...

I am having trouble shrinking the size of my transaction log.  I just started working here and notice the transaction log was never backed up.  Therefore it grew to 900 meg.  I cannot get the size to decrease and have about 800 Meg allocated that is not being...

I am trying to create a listing that has the table name, column name and column description for all user tables in my database.  I only that came close is creating a huge report from Tools/Analyze/Documentor which provides a report with way too much data and pages.  Does...