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 found an answer for anyone interested. Update 7.0 to sp3.

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.

I don't seem to be getting a 1706 error. I did find that it could have something to do with a distinct clause in a subquery somewhere. I am running a SQL Profiler trace on the distinct clause overnight, to see if I can capture the problem.

I am having a similiar situation happening on my server as well. Have you found any resolution?

I am receiving some strange reference to Ghost in my server daily log. Here is an example ..... Module(sqlservr+0004182F) (GhostExorciser::ExpungeGhostedRows(class SDES *,struct INDEX const *,struct BUF * &)+00000089) I have no idea what is causing it. Have you had any luck on the profile issue?

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

Thanks to all for the replies. The SQL Programmer tool seems pretty nice. I will further evaluate it and also look in to creating my own procedure for conducting a search and replace method.

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.

In my opinion(which everyone knows what opinions are like). I have found that you can be limited with linked objects rather than embedded objects. With the Linked object you are at the mercy of your network connections if your images or objects are stored on a different server. Linked objects on...

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