How do i recover the DB from suspect mode in sqlserver 2000?
I have a database that went to suspect mode in sqlserver 2000.How do i recover the DB from suspect without restore the DB? 

Answer Question   |  March 22, 2010  4:15 PM
Database, SQL Server 2000, SQL Server 2000 Suspect Mode

Encrypting passwords on SQL server 2000
I m using SQL server 2000 and I want to use a password field for Employee Master. My question is how to encrypt this password field in my insert query. I have heard about the “EncryptByPassPhrase” function and symmetric key, but it is provided from SQL Server 2005. I have tried using pwdencrypt which is [...]

Answer Question   |  March 19, 2010  7:00 PM
Encryption, Password, Password field, SQL Server 2000

Running SQL Server 2000 and 2005 simultaneously
When simultaneously running SQL Server 2000 and 2005, what performance effects can I expect this having on the box? Should the memory be increased? And what can I do now to fine-tune it before the install of 2005?

Answer Question   |  March 12, 2010  6:51 PM
Performance/Tuning, SQL Server 2000, SQL Server 2005

Problems with SQL Server 2000
In my office we work on SQL Server 2000, and we have software in .NET Question 1: Sometimes the message display reads “You cannot access because of user limit”. What does this mean? Question 2: Some of my computers work slow in SQL for an hour or two at a time. What can I do [...]

Answer Question   |  March 12, 2010  6:45 PM
.NET, SQL, SQL Server 2000

Storing encrypted files on an SQL Server 2000
We are doing our final year project as a secured electronic voting system. To finish this project, we are in need of storing our votes in an encrypted form to provide security and, to do so, we are using back-end as SQL Server 2000. Is this possible or must we change our back-end?

Answer Question   |  February 24, 2010  7:47 PM
Encryption, SQL Server, SQL Server 2000

Switching from Bulk-Logged to Simple Recovery Model on SQL Server 2000
Hello, I’ve got a SQL Server 2000 SP4 database that I am considering switching from Bulk-Logged to Simple recovery model. The reason is, there are no transaction log backups happening so the log is just growing to an unmanageable size (40+ GB). I also want to minimize/shrink the log file. What is the easiest (but [...]

Answer Question   |  February 24, 2010  4:52 PM
SQL Server 2000, SQL Server transaction logs, Transaction logs

Using SQL and Postgre on the same machine
We have a requirement in which we need to have our Microsoft SQL Server, as a database of tomcat servers, and our Postgre SQL, as database of jboss servers, on same machine. Are there any known conflicts or issues we should be aware of?

Answer Question   |  February 24, 2010  9:21 PM
Database API, Postgres, PostgreSQL, SQL, SQL Server 2000, Tomcat

Monitoring log files in a SQL Server 2000 database
I have an intermittent problem with a SQL Server 2000 database. The job, to truncate the log files, doesn’t start on time, and the transaction fills up preventing users from logging in. I would like to monitor the log such that I can send an alert when the log reaches e.g. 80% full.

Answer Question   |  February 24, 2010  9:18 PM
SQL Server 2000, SQL Server 2000 Database, SQL Server database, SQL Server logs

Adding and removing disk space for SQL2000
The scenario:SQL_SVR_A (2000)has x amount ‘too much’ SAN disk space that they want to reclaim/use to allocate to SQL_SVR_B (2000)- which doesn’t have enough space. What is the best method to 1)remove the disk space and keep all db’s in-tact (backup/recovery?, or another way??) and 2)how to add the new space to the server B, [...]

Answer Question   |  February 11, 2010  4:35 PM
SQL Server 2000

sql server 2000 in server
Hi, We have a server in which windows 2003 is installed and we have created users in the domain (eg – aaa). The server is installed with sql server 2000 and data is stored in the database. The user name for the server is administrator. The problem is when we login from the user computer [...]

Answer Question   |  February 2, 2010  5:19 AM
SQL Server 2000, SQL Server administration, Windows Server 2003

differences between SQL server 2000 & SQL server 2005
Hai  Can any one tell me What are the Main differences between SQL server 2000 & SQL server 2005. Thanks and Regards

Answer Question   |  January 29, 2010  10:21 AM
SQL Server, SQL Server 2000, SQL Server 2005

Need help setting Transaction Log properties in SQL Server 2000
I’d like some help determining what would be the best settings for my transaction log properties. When our SQL Server 2000 SP4 Database was setup it was done by developers without detailed information regarding all of the possible settings so most settings were left at their defaults. I have been looking at the issues around [...]

Answer Question   |  January 26, 2010  3:55 PM
backups, SQL Server 2000, Transaction logs

how to save file doc, xls, into database sql server 2000 in VB6
how to save file doc, xls, into database sql server 2000 in VB6 with rdoconnection?

Answer Question   |  December 14, 2009  12:33 AM
Microsoft Office, SQL Server 2000, VB6, Visual Basic

How to restore Sql Server 2000 mdf and ldf data
I have MDF and LDF files with different modified dates. How could I attach these to SQL Server 2000

Answer Question   |  December 3, 2009  2:54 PM
.MDF files, LDF, MDF, SQL Restore, SQL Server 2000

Select – Top 10
Hello, I have to tables, one with name CONTRACT, second AGENT IN table CONTRACT these data: ClientID ClientName ClientSurname ContractNR AgentID AGENT data: ClientID Sum ContractNR I need to select 10 agent’s clients, who have a bigest sum. One agent have 100 clients, second only 2 or one client. Sum is very different. The result [...]

Answer Question   |  November 2, 2009  9:02 AM
SQL Server 2000

Replication sync_method set to concurrent in SQL Server 2000
Hi, Just wondering what happens to data that are inserted during the time of a snapshot replication generation when the sync_method is set to concurrent, as there are no table locks, are the data insert into the publisher then held in the distribution database and when the snapshot has been completed, the data in the [...]

Answer Question   |  October 22, 2009  12:24 PM
SQL Server 2000, SQL Server database, SQL Server replication

Set identity to not for replication in T-SQL
Hi, Does anyone know the TSQL to change the identity column on a table in SQL Server 2000. And also the TSQL to change trigger to not for replication. Thanks

Answer Question   |  October 23, 2009  5:58 AM
ALTER, SQL Server 2000, T-SQL

store image to sql server
would you please give me a code to store and retrieve an image in SQL Server 2000, using Visual Basic 6.0 on the front end

Answer Question   |  January 23, 2010  8:28 AM
SQL Server 2000, SQL Server Image Store, VB 6.0, Visual Basic, Visual Basic 6.0

MS SQL Server 2000 Vulnerability
Hello, I have installed on one of my servers SQL Server 8.00.2273 – SP4 (Standard Edition). At the last vulnerability tests it founds the followings: 1. Microsoft SQL Server MTF Data Structures Memory Corruption Vulnerability (MS08-040) 2. Microsoft SQL Server ‘sp_replwritetovarbin’ Remote Memory Corruption Vulnerability (MS09-004) Searching for an answer at microsoft I found that [...]

Answer Question   |  October 19, 2009  7:17 AM
SQL Server 2000, SQL Server vulnerabilities, Windows Server 2003, Windows Server 2003 SP2

Tree View Control
i am trying 2 make and explorer using the tree view control in my project using VB 6, SQL Server 2000 and crystal reports. in the looping statements i had inculed the details and all. i need 2 display the results in the Grid Box when click the nodes in the Tree control. please provide [...]

Answer Question   |  October 15, 2009  8:55 AM
Crystal Reports, SQL Server 2000, Tree View control, VB 6, Visual Basic