Search results for query: *

We have upgraded from SQL Server 7.0 to 2000. Our application that was running on mdac 2.5 is now running slower on mdac 2.6. Since SQL Server 2000 installs mdac 2.6 as part of its installation, we are forced to use mdac 2.6. Now all our executables run 50 % slower on mdac 2.6 than the ones that...

We have upgraded from SQL Server 7.0 to 2000. The SQL 2000 install includes mdac 2.6. We use OLEDB for database connectivity and have observed that our executables run 50% (!) slower on mdac 2.6 than on mdac 2.5. Has anyone else noticed this and come across any solution? Can we use MDAC...

Is there a way to implement resource (disk, memory, elapsed cpu time) quotas on a per account basis in SQL Server 7 or SQL 2000? For example, can I protect my production environment from a poorly written query by configuring SQL Server to terminate any query that runs for more than 10...

I've read accounts here and in other forums from folks who are running SQL 7 under Windows 2000 Server. I haven't read of any problems, but does Microsoft support this configuration? We would be running SQL 7 standard on Windows 2000 Advanced Server. Thanks in advance.

I am populating an existing but empty table using an insert into (target table name) select * from (source table name). The source table contains about 106 MB of data. The transaction has been running for several hours and has generated more than 400 MB of rollback. Is this expected behavior...

We have some SQL Server 2000 databases (5 databases totalling about 7 GBs) that we want to return to version 7. The detach/attach method of moving databases will not work as SQL 7 will not attach the SQL 2000 files. Similarly, I can't restore in the SQL 7 environment a backup made in the SQL...

We have some DTS packages that need to be modified by multiple database users but it seems that only the owner can modify them. I have tried giving the appropriate users more privileges on msdb but this did not work. What's the best way to allow multiple users to modify DTS packages without...

Given that there is a choice between using TCP/IP or named pipes to connect to SQL Server, which is the better choice in terms of performance? When using TCP/IP, does using a server name (which then must resolve through DNS) instead of an IP address degrade performance noticeably? Thanks in...

Is there a way to query the data dictionary in SQL 7 to see if referential integrity constraints are enabled for insert/update/delete? I know how to do this in EM but haven't been able to find even an information_schema view that contains this information. Thanks in advance for any help.

We have lost the primary file group (the .mdf file) of a single file group database but we have the original transaction log, as it stood at the time the primary file got clobbered, in its entirety. We have a complete backup of the entire database from about a week ago. I know I can restore...

It turns out that what I found what I need in the undocumented stored procedure sp_reassign_dtspackageowner. Thanks for your help. - pd

Hi Robert, Thanks for your response. The files were imported from one server's msdb database to the current server's msdb database. The packages are stored in native DTS format in the msdb database. - Paul

I have some DTS packages that were imported from another server. I need to change the owner - sp_changeobjectowner does not work for DTS packages. Alternatively, I could grant the privilege to modify the packages in question to other users. I can't figure out how to do this, either. BOL...