Search results for query: *

I have three different servers running SQL 7.0. This morning I have discovered that this error pops up any time I try to open the properties of the 'sa' user account. It will not allow me to change the password. I have read the article Q218172 from MS. The article explained the cause as being a...

I use SQL 2000 Enterprise Manager to connect to a 7.0 server. If I make a change to a DTS package on the 7.0 box using 2000 EM,I cannot open the package or run the package at all on that 7.0 box. I get an error syaing that the file does not exist.

How can I update the data in a column in a system catalog table. (ie. I want to globally change the owner of some stored procedures to dbo from the original user who created them. The table I want to change is sysobjects. The column is UID. I am trying to change UID 6 to UID 1.)

I have an SQL 7.0 Server that shows the status of the job as 'executing job step 1', even after the job has completed. This is a scheduled job that was kicked of at 12:00 am. The job will not run again, it tells me the job is already running. I have to start and stop the server in order to...

I have been given the task of updating hundreds of stored procedures in many different databases with our organizations. The first name field and the last name field have been expanded to a varchar(50) in the tables and the sp's have varchar(20). Is there any way to create a script that will do...

We are attempting to export about 6 gigs of data from an Oracle DB to a SQL Server DB. We are using an ODBC connection. It is running very slow. Took overnight to run. Any suggestions.

I have a SQL Server 7.0 table that stores gif images. I have an Access 2000 DB/Program that links to that table. One of the forms I have set up displays an image in a Bound Object Frame based on the record that is chosen from a drop down list. The program works great except for the speed of...

I have a SQL Server 7.0 table that stores gif images. I have an Access 2000 DB/Program that links to that table. One of the forms I have set up displays an image in a Bound Object Frame based on the record that is chosen from a drop down list. The program works great except for the speed of...