0
votes
0answers
105 views

SQL Trace Profiler Not Capturing All Connections

I'm trying to run a profiler trace on a server to track any unused databases. I'm seeing connections through 'Audit Login', however for certain active databases there's nothing showing up on the ...
0
votes
1answer
107 views

Migrating databases from SQL 2000 to 2008 R2

Hands-ups, I have no idea what I'm doing! We have an old SQL 2000 Server with 2 databases. I have a new server running SQL Server 2008 R2. Can someone outline the basic steps of migrating the ...
2
votes
1answer
248 views

SQL Server 2000 HIGH CPU Usage with BusinessObjects reports (unsolvable?)

I have one of those weird questions, those ones that are nearly unsolvable (the only way to really solve them is to throw out the technology and buy new ones). I've had a number of experts (about 10 ...
1
vote
1answer
46 views

SQL Server database backups storage

This is rather basic question. We do backups of all the databases on the server and size around 20GB every week. All that is scheduled (shrinking,Backing up) We store them on Network drive. Now ...
0
votes
2answers
63 views

SQL Server 2008 Vs SQL Server 2000

The performance of SQL Server 2000 database is not improving with the latest multi-core processors. I think SQL Server 2000 is not capable of utilising these cores. So, I plan to switch to SQL ...
1
vote
5answers
99 views

SQL Server connection error (a weird one) (unsolved yet)

SQL Server can be connected from local system but can not be connected from remote system in the network. The error code is 40 from Visual Studio and 1326 when I try to connect to SQL Server from ...
0
votes
2answers
404 views

SQL 2000 DB problem : I/O error (torn page) detected during read at offset

I got this error : I/O error (torn page) detected during read at offset 0x0000024afe4000 in file for a user database. Using the first googled method, i set the database from master..sysdatabases ...
0
votes
1answer
145 views

Object definition in MS SQL 2000

I was looking for a way to generate object definition (in my case stored procedure defintion) in SQL 2000 like I can get in SQL 2005 : select definition from sys.all_sql_modules.
0
votes
2answers
434 views

SQL 2008 Replication corrupt data problem

We took a SQL 2000 database. Took a lightspeed backup. Restored on SQL 2008 active/passive cluster. Then setup replication to replicate the data back to SQL 2000. So 2008 is the publisher/distributor, ...