Hi,

I see that some of the DTS packages have text annotation describing what the package does, but not all.  I guess there is no standard that our developers follow.  It...

Hi,

Thanks for the clarification.  What kind of utility do you have to "document" your packages?  I have the ability to compile VB source code and I can try and save...

Thanks Paul for the info.  I didn't think it would be a problem since they are two different databases, just maybe to confuse myself later!  I just think it's odd...

Hi,

I used the alter database <database name> modify file to change the logical filenames, so I already answered my question #2.  Still would like to know the answers to my...

Great!  Thanks for the info.

Isabelle

Hi,

I found my Errorlog file and tried to modify it, but it doesn't take the changes.  I also saw in BOL that I can use sp_cycle_errorlog to archive the current...

Hi,

I am new to SQL so I think I'm a little confused with your reply. What transaction log are you referring to?  I am familiar with backing up transaction logs for...

Great!

Thanks so much for all your replies. 

Bea

Thanks for the update.  I believe this will be a long term thing so I will start playing around with triggers.

Isabelle

Hi,

Thanks for your response.  Unfortunately I don't have anything in the budget for this year to purchase any additional software.  I'm looking for a way to do this with SQL...

Hi,

Okay, I manually copied the backup to the directory that shows up on the drop down list and I see the backup that I want to restore.  The backup is...

Good Morning,

The drop down list does not show all of the older backups, including the one I need to use to restore.  I have a test box with SQL on...

Hi Marcus,

I see that the properties on the log file have Automatically grow file checked and Restrict file growth to 6GB.  I thought this was pretty much saying to set...

Hi,

I found info on this in the Books Online and it states:

Have the network administrator configure the firewall to forward the IP address and TCP port the instance of SQL...

Hi,

I looked in the MSDN library and got the following information:

The page height, in inches, to set for the report. You must include an integer or decimal value followed by...