msde2000

What tools are available for providing a breakdown of the diskspace used by an SQL Server database

I have an MSDE2000 database which appears to be approaching it's 2Gb limit. What tools can I use to determine where all the space is being used? Ideally think TreesizePro for SQL Databases ...

How do I shrink my SQL Server Database?

I have a Database nearly 1.9Gb Database in size MSDE2000 does not allow DBs that exceed 2.0Gb I need to shrink this DB (and many like it at various client locations) I have found and deleted many 100's of 1000's of records which are considered unneeded. these records account for a large percentage of some of the main (largest) tables i...

SQL Server 2008 replicating to SQL Server 2000

Has anyone implemented replication between SQL Server 2008 and MSDE2000? Does the merge replication work between these two databases? ...

SQL 2000 (MSDE) Hangs When It Receives an Erroneous Query from a Classic ASP Web Application

I have a SQL interface page in my classic ASP web app that allows admin users to run queries against the app's database (MSDE 2000) - it simply consists of a textarea that the user submits and the app returns the resulting list of records as below Dim oRS Set oRS = Server.CreateObject("ADODB.Recordset") oRS.ActiveConnection = sConnectio...