Stack Overflow
Stack Overflow

Questions tagged [msde2000]

7 questions
57
votes
16 answers

How do I shrink my SQL Server Database?

I have a Database nearly 1.9Gb Database in size, and MSDE2000 does not allow DBs that exceed 2.0Gb I need to shrink this DB (and many others like this at various client locations). I have found and deleted many 100's of 1000's of records which are…
Rory Becker
  • 15,551
  • 16
  • 69
  • 94
2
votes
1 answer

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…
Jimbo
  • 22,379
  • 42
  • 117
  • 159
0
votes
1 answer

Connection problem when connecting to MSDE2000 with .NET

I have a strange problem. I'm trying to connect to a Microsoft SQL server from C# (.Net 4.0). The server is running MSDE2000(8.00.194). When I connect I get the following message: System.Data.SqlClient.SqlException (0x80131904): A network-related or…
chiefi
  • 101
  • 3
  • 12
0
votes
1 answer

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?
Shiva
0
votes
1 answer

How do I start MSDE2000A (mssql$netsdk) from cmd in Windows 7?

I'm trying to install MSDE2000A on a Windows 7 machine, and the database book I'm using described doing so through the command line. First I installed it to C:\< folder >. Everything went fine (except for a Windows 7 compatibility issue notice),…
Panzercrisis
  • 4,590
  • 6
  • 46
  • 85
0
votes
1 answer

Can an MSDE 2000 database be deplolyed to SQL Server 2000?

I am developing a Web Application using SQL Server 2005 for the database, but will need to deploy the database to SQL Server 2000 in the production environment. We don't have a license for SQL Server 2000 (we've only got for 2005), and I've come…
Saajid Ismail
  • 8,029
  • 11
  • 48
  • 56
0
votes
1 answer

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
Rory Becker
  • 15,551
  • 16
  • 69
  • 94