Recent content by skippaNH

Hi, I have four SQL Servers with several databases on each being replicated to another data center via merge replication. Full backups at night, noon differentials and hourly log backups are running. I haven't had any problems. Kim

Thanks, but the DTS packages are no longer available due to the new installation of the Standard Edition (new and "empty" MSDB table). Please considered this a resolved post. I ended up doing the following: On a standby server: Backed up existing MSDB Restored MSDB that...

I have reloaded a SQL Server from Enterprise Edition down to Standard Edition. The DTS packages saved locally were not saved off the server prior to the reload, and therfore do not exist now in the new MSDB. I have a backup of the previous MSDB which has the packages. What is the best way to...

TFO is on the same server as other databases that are being backed up. I just created another db and restored a backup of TFO into it. BE was able to backup the restored db fine.

Hi, BE Version 9 is backing up several SQL Server 2000 databases. It is failing on one database. The error being returned is "unable to open item TFO.mdf - File is in use." This error is returned even when I show no cursors attached to the database. Thanks in advance.

Have you tried renaming the existing backup file and rerunning the job?

Just need it to refresh (or redirect) on time. The IP address was changed on the server of the data shource. Existing Access db would then error when trying to validate.

Hi all, How do I change the DSN that tables are imported from? This is for an Access 97 database. Thanks in advance.

Thanks much!

Hi all, Is there an easy way to change the data in a column using T-SQL to simply add a zero in front of the existing value? For example, the value is 123456, but I need it to be 0123467. The column is char type, lenght of 7. Thanks in advance :)

Are you open to setting the max size and then having an alert fire when the database has grown to a certain percentage? (say 80% full)?

I actually want the entire source document to appear, not just the first page, without double clicking on it. The goal is to have the entire source document print each time the main document is printed. "Inserting" the file is not an option as the source document may be edited and...

I have linked a file (MS Word Document) into another MS Word Document. However, it only displays the first page of the source file. How do I get it to display (and print) the entire source file. I have tried saving the source file off as an .rtf, but that doesn't help. Thanks :)

I have Merge Replication running on two databases (Live & Test) to a secondary data center. How do I refresh the Test Environment with the Live Environment data with Replication running? I tried DTS, but it would not let me copy any data in because both DBs are being used in Replication. I...

MSSQL Server and SQL Agent will no longer Auto Start after reboot. Due to a client software pacakge install, Acces 97 and Message Queuing Services had to be installed/configured on the same sever. Since then the Services will not Auto Start after reboot. There are no errors in the event log...