SQL 2000 & Outlook 2000
We have a couple of SQL 2K Servers which have a mailbox associated with them, have always used Outlook 2000 because anything newer does not work and today it has gone wrong!!! We are now getting a “Cannot open the mailbox, information store not available” we cannot get the server to work with email and [...]

Answer Question   |  October 13, 2009  2:12 PM
Exchange 2007, Outlook 2000, Server 2000, SQL Server 2000

How does SQL Server 2000 CAL licensing work
Hi, Just wondering how SQL Server CAL licensing work. For example in one of our client SQL Server 2000, we notice in the SQL Server 2000 licensing icon in Control Panel, it is set to CAL of 50. Does this mean if the 51st client tries to access the SQL Server, an error will occur? [...]

Answer Question   |  October 8, 2009  5:52 AM
SQL Server 2000, SQL Server CAL licensing, SQL Server licensing

Change SQL Server licensing
Hi, I was wondering if it is possible for a 50 seat (i.e. maximum of 50 connection) SQL Server 2000 or 2005 license to be change to a 10 seat? If it is possible is there any limitation on the number of seat that can be change? Thanks

Answer Question   |  October 6, 2009  3:18 AM
SQL Server 2000, SQL Server 2005, SQL Server licensing

installing sql server 2000 32-bit on vista 64-bit
how to install sql server 2000 32-bit into vista 64-bit?

Answer Question   |  October 2, 2009  7:43 AM
SQL Server 2000, SQL Server 2000 32-bit, Vista, Windows Vista 64-bit

SQL Server 2000 hang and shrink won’t stop
I’m troubleshooting a SQL 2000 database problem. It’s a db for our datawarehouse system that pull everyday data from host. Current size is 461Gb for db and 67Gb for log. Because of space concern, I want to detach the log file and create new, but today I cannot open the database locally or remotely. When [...]

Answer Question   |  September 29, 2009  2:43 PM
Event Viewer, SQL Database, SQL Server 2000

Making a WAN
Hi, I would like to know the best way to setup a WAN. We have 4 small companies and one main Head quarter.  2 companies are in one city and 2 are in another city. Below is the detail on what each site has. HQ(head quarter)- HP Mail Server (HP ML350) - Win 2003 Server + Exchange [...]

Answer Question   |  September 30, 2009  10:56 AM
Exchange 2003, Network Configuration, SQL Server 2000, WAN, WAN design, WAN hardware, WAN technologies, Windows Server 2003

SQL server 2000 increase database auto-grow
Does it matter to increase database auto-grow from 10MB to 250MB? We expereience some bottleneck at database size of 36 GB for a reporting database. But the physical disk has 100 GB free disk space, CPU usage is not high. Occasionally has some COM error Not sure what the problem it is

Answer Question   |  September 9, 2009  1:32 PM
Auto Grow, Database Sizing, SQL Server 2000

SQL Server datetime
Hi - When I run this: select cast (’461129′ as datetime) i get 2046-11-29 00:00:00.000 instead of 1946-11-29 00:00:00.000 Can you please let me know why and what I need to do in order to get the required results. thx

Answer Question   |  August 27, 2009  6:35 PM
SQL datetime, SQL Server 2000, SQL Troubleshooting

Select into vs Insert into in SQL Server
Hi experts, What is better between Select into vs Insert into in SQL Server when it comes to performance? thx

Answer Question   |  September 1, 2010  4:36 PM
SQL INSERT, SQL performance, SQL Server 2000

comparing variable to a field with comma-separated values
"m trying to compare a variable (@item) to a field which has multiple item numbers separated by commas. I've used "LIKE" and "IN" to no avail. I've also tried appending wildcard characters to the variable (@item2), which also hasn't worked. Full-text indexing is not activated on the DB (SQL Server 2000), so I can't use [...]

Answer Question   |  August 15, 2009  2:00 PM
Comma Separated Values, SQL Server 2000, SQL Server development

Encrypt the password in SQL 2000
How to pass encrypted passwords in connection string in asp/vb using sql server 2000. Im trying to create a new user login for the applications using SQL server 2000. However want the end users to avoid viewing the login credentails for sql server 2000 in the connection string part. Hence prefer to pass the encrpted [...]

Answer Question   |  August 4, 2009  11:53 AM
ASP, SQL Server 2000, SQL Server encryption, SQL Server security, VB

Recovering lost SQL Server 2000 data
I lost a LDF file for SQL server 2000 — but I have the MDF. How can I recover my data?

Answer Question   |  December 13, 2010  6:47 PM
Data Recovery, LDF, MDF, SQL Server 2000, SQL Server backup and restore

Error during SQL Server 2000 installation
When I attempt to install SQL Server 2000 using Windows XP Service Pack 2 for IT Professionals and Developers, I encounter the following error: “Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system. Only client components will be available for installation” How can I fix this problem?

Answer Question   |  September 7, 2010  6:43 PM
SQL Server 2000, SQL Server error messages, SQL Server installation

SQL Server Database Date Time Values
I am developing a software using Date Time values. i am using SQL server 2000 as the database. can i create a coloumn with only time value or data value. Only datetime is available. how can i eliminate a part of it in the database. when inserting the time values the date part is 01 [...]

Answer Question   |  July 30, 2009  4:11 PM
SQL Server 2000, SQL Server database

sql server 2000 how can i make backup 4 file only and restore
how can i make backup 4 file only and restore

Answer Question   |  July 28, 2009  2:08 PM
SQL Server 2000, SQL Server backup, SQL Server backup and restore

VB 6, SQL Server 2000 & Crystal Reports
i am a developer using VB 6 EE, SQL Server 2000 & Crystal Reports 7 and windows XP & Windows NT platforms. But now i installed Windows Vista. i installed VB 6 EE, but cant work with SQL Server 2000 or Crystal reports. can u please suggest me wat i need 2 do.

Answer Question   |  July 28, 2009  3:54 PM
Crystal Reports, SQL Server 2000, VB 6 EE, VB6

Formating Sysmessage text
How does SQl Server generate this error message What happens when an error occurs in a User defined Stored Procedure. Which System stored procedure is fired I know that the error messages are stored in “sysmessages” table in “Master” Database – but which system stored procedure calls this table when an error occurs.

Answer Question   |  July 23, 2009  8:53 PM
SQL Server 2000

Connection of Crystal Report 2008 with VB6.
Plz let me know the procedure to bring the controls of Crstal Report 2008 in VB6? What control has to be select and what coding should be use for the same??am using sql 2000 as a back-end.plz help..

Answer Question   |  July 14, 2009  9:28 AM
Crystal Reports 2008 controls, Database connectivity, SQL Server 2000, VB 6, Visual Basic 6

How to move SQL Server databases to a new drive.
I have installed all my databases (nice_cls and nice_audit) in D:/ drive and need to move them to E:/ drive.

Answer Question   |  July 9, 2009  4:20 PM
SQL Server 2000, SQL Server 2005, SQL Server Database Migration, SQL Server databases

Is it possible to connect from the SSIS Analysis Services task to SQL Server 2000 Analysis Services?
Using the Analysis Services Processing Task in SSIS 2005, we are trying to connect to SQL Server 2000 Analysis Server cubes. While we are able to successfully create an Analysis Services connection, when we try to configure the task and specify the connection created above, we receive the following error: TITLE: Analysis Services Processing Task [...]

Answer Question   |  July 6, 2009  4:41 PM
SQL Server 2000, SQL Server 2005, SQL Server Analysis Services, SQL Server Integration Service