Search results for query: *

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

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.

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

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 :)

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

Does anyone know of a way to change a SQL View of JDE data to translate their date in to a normal date format i.e. 09/05/01. Or if there's a .udf available to convert it within Cognos? We are trying to avoid a long nested "IF" Statement each time the date is pulled into Cognos. The...

Does anyone know of a way to change a SQL View of JDE data to translate their date in to a normal date format i.e. 09/05/01. The JDE "date" format isn't stored in SQL as a date, but as a numeric field, 9 digits JDE Format: CYYddd C - Century YY - YY Ddd - day of year So...

Does anyone know how to perform a conversion in the JD Edwards "Date" format by using a SQL View? The format is actually a 9 digit numeric. It is not stored in date format. It is CYYddd. C - Century YY - Year Ddd - day of year Century - 0 = 1900 Century - 1 = 2000 YY = 01...