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 have Access 2000 and when I view the MySysObjects table, I can tell by the type field that it is a table and the name field shows the column name... BUT, I still don't see the description column (info) anywhere in here.  Maybe it is different in 2000.  Sincerely,,,, Still...

This didn't really answer my question.  The descriptions are already in the access database and I would like to query them or create a report to show them... Do you know the code to crab this information from the system.  I know it is stored out there...

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...