Dear all, I'm working on MS SQL 2000 SP3. I'm trying to switch to a new server. When I tried to restore the master database, the server wouldn't re-start. so I tried another way, that is to restore user-databases and transfer the users-accounts (DTS) but it seems that the users cannot connec...more >>

Hi all, I have a paradox database and i want to convert it into SQL Server all i have is a folder having Paradox data files like .px, .db etc. i have already installed SQL Server 2000,and i know about DTS Import export tool provided with it. please let me know which all other toos i need and ...more >>

I need to configure and purchase two new servers running SQL 2000 Enterprise Edition on Windows 2003 Enterprise Edition each equipped with 2 processors. I'm wondering if anyone has experience with or knowledge of using dual core Intel Xeon Processors with SQL Server, and if there are definite ...more >>

I have a lot of sprocs being called but a dbcc inputbuffer on the spid only lists the sproc name without the parameters being passed. Why is that ? Using SQL 2000 and SP3a. Thanks ...more >>

What are some of the reasons why one could get a "General Network error " from the app especially if the n/w between the app and SQL appears to be fine. Thanks ...more >>

we have this problem 1. whereby sql transaction is blocked by spid -2 2. check the error log it dump mini dump at 4.00am 3. error log repeat with The Scheduler 5 appears to be hung. SPID 102, ECID 0, UMS Context 0x03ADD340. Error: 17883, Severity: 1, State: 0 3. blocking happen at 10.00am ...more >>

Hello, I have a database with multiple file groups and mdf(M:\) resides in different disk and ldf(L:\) resides in different disk. I dump all the backup to different disk (X:\). Now, I am testing to restore the files. When i choose "Retore Files and Filegroups" or "Restore Database" and navi...more >>

Pretty simple question, what is the maximum amount of memory SQL 2000 Enterprise Edition can support on Windows 2003 Enterprise Edition (all refering to the 32-bit versions). Thanks!...more >>

About 2 months ago I loaded a new instance on my SQL Server 200 box. I have been working with the database in that instance. However, now I try to access the other instance on the server and I get connection failed check server registration properties. When I check them I get "login failed."...more >>

Insert a picture in an MS SQL Server table How can u insert a picture an an image field in SQL server table? Is it possible from SQL server tools or other tools, programming? ...more >>

I am making a web Application, where non breakable space ( ) is crucial to the layout. When I write   directly into the html, it is displayed correctly. But If I store a value in the database (MS Sql server 2003) containing the   code it is rendered to the browser like this: Ki...more >>

I did several tests of performance of SQL2k5, and I see quite strange results. I restored database from SQL2k, rebuilded indexes, updated statistics. I did all what described in migration process. Backuped the resulting database. In each of next tests I restored the database from backup. Next ...more >>

Hey im really confused about this database design ive encountered, and I wonder if anyone can help me understqand if this is a decent design and what to do about it. The database contains about 24 billion records. It is split into a distributed partitioned view on a RAID 5 of 7 different harddriv...more >>