SQL 2000 Reporting Services – Using embedded code to guide user on input parameters?
I’m working on a report which has these input parameters: StartDate (textbox, data type is datetime) EndDate (textbox, data type is datetime) AccountNumber (dropdown, data type is string) I need to set up logic where if the user viewing the report has input only date values, they’ll be prompted to select an AccountNumber, or if [...]

Answer Question   |  September 20, 2008  1:23 AM
Microsoft, Reporting Services, SQL Server 2000

Upgrading from SQL 2000 TO SQL 2005 Will all the sites (Multisites) need to be upgraded
Upgrading from SQL 2000 TO SQL 2005 Will all the sites (Multisites) need to be upgraded

Answer Question   |  March 2, 2008  12:00 PM
SQL Server 2000, SQL Server 2005, SQL Server installation

Do replica dbs need to be updagraded when uprading from SQL 2000 to SQL 2005
Do replica dbs need to be updagraded when uprading from SQL 2000 to SQL 2005

Answer Question   |  March 2, 2008  11:33 AM
SQL Server 2000, SQL Server 2005, SQL Server replication

Replication in SQL Server 2005 deleting records
We just converted from SqL 2000 to 2005. We were replicating from 2 instances on the same server every 30 minutes. A record from Intsnace A was copied to Instance B, then the record in A was deleted. Worked great for years. Now with 2005 it is deleting the records on B on the second [...]

Answer Question   |  February 22, 2008  7:41 PM
Replication, SQL Server 2000, SQL Server 2005

Connecting from VB6 to a remote Oracle Database
We are a SQL 2000 Database shop using Visual Basic 6.0 & Windows 2003. I need to develop an application that can access an Orcale database on a remote system (sight to sight VPN in place) using SQL. I retreived some information yesterday that enabled me to construct the connect statement in our application. However [...]

Answer Question   |  March 6, 2008  3:41 PM
Oracle, SQL Server, SQL Server 2000, SQL Server 2005, VB, Visual Basic 6

Installing SP4 for SQL 2000 Error: 50042
When I try to instal SP4 for SQL Server 200 with the Cyrillic Collation, the install crashes unexpectedly with no on screen errors. In the log it says “GetLastError returned: 50042″ which I understand is related to the collation. Is there a way to fix this or perhaps a workaround?

Answer Question   |  September 30, 2008  3:09 PM
SQL Server 2000, SQL Server errors

sql server 2000
i have booted my system with windows xp as user xyz with limited rights not an administrator now problem is i am not able to run sql server.please tell me what should i do to run sql server 2000 in user xyz. *it works with administrator login.

Answer Question   |  February 14, 2008  4:14 AM
SQL Server 2000, SQL Server administration

how to run sql server 2000 on terminal which is logged on as user having limited rights
how to run sql server 2000 on terminal which is lgged on as user having limited rights

Answer Question   |  February 13, 2008  4:13 AM
SQL Server 2000

Automating an application
I am a beginner in VB. I was working on a project to upload data from one table to another. The tables are in different databases. Now I am supposed to automate it so that the update from one table to another can be done regularly. I guess it should be timer based but I [...]

Answer Question   |  February 8, 2008  12:04 PM
SQL Server 2000, VB

Insert and update DB2 from SQL Server 2000 using OLEDB
I am using AS/400 and SQL Server 2000 and trying to insert and update from SQL Server. When I run a DTS from SQL Server 2000, SQL Server 2000 is able to read the table from AS/400 but when I run a DTS from SQL Server 2000 to insert or update a table on AS/400, [...]

Answer Question   |  June 29, 2010  9:42 AM
AS/400, DTS, SQL Server 2000

SQL Command
I have created a stored procedure in SQL2000 like this : SELECT p.PO_code,p.Po_date, p.Supp_code + ‘ : ‘+ s.Sname as Supp_Nme,p.po_total,r.RC_code,r.Amount FROM PO_list p inner join RC_list r on r.PO_code = p.PO_code inner join Supplier s on s.supp_code = p.supp_code WHERE (p.Supp_code in (’102200′,’102083′)) and (substring(p.PO_CODE ,5,1) = ‘R’ ) and (p.cancel = ‘N’ and [...]

Answer Question   |  February 12, 2008  3:09 AM
SQL Server 2000, Stored Procedures, T-SQL

Upgrading two instances of SQL 2000 running on the same SVR to SP4
I currently have two instances of SQL 2000 running on the same SVR. recently I commissioned a new CRM SVR and as I’m sure your all aware that the minimum requirement for the CRM to work correctly is SQL 2000 SP4. I downloaded and installed SP4 on the SVR running SQL 2000, however, my problem [...]

Answer Question   |  February 22, 2008  4:47 PM
SQL Server 2000, SQL Server 2000 SP4

Need to create SQL DTS Package
We are using SQL 2000 DTS Packages and I want to create a DTS Package which can copy only all text file names from folder(source) to SQL table column(Destination). Also i want to write number of rows in particular text file to SQL table. DTS or Procedure or Activex Script??

Answer Question   |  February 22, 2008  3:35 PM
DTS, SQL, SQL Server 2000

SQL Server 2000 backup failed
can not backup a 2000 db, dbcc checkdb ok. see following: Errorlog: 2008-01-08 09:54:40.69 spid62 Starting up database ‘CP2005′. 2008-01-08 09:54:41.00 backup BACKUP failed to complete the command BACKUP DATABASE [education] TO DISK = N’C:fjs1education_db_200801080954.BAK’ WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT 2008-01-08 10:19:18.34 backup BACKUP failed to complete the command [...]

Answer Question   |  February 22, 2008  6:51 PM
MSDE, SQL Server 2000, SQL Server 2000 Desktop Engine

Upper limit for numeric fields
What is the maximum numeric field length for Visual Basic Applications running on SQL 2000

Answer Question   |  January 4, 2008  10:46 AM
Programming, SQL Server 2000, Visual Basic

Merge Replication
How To Create Merge Replication in SQL Server 2000. There Are 20 Subscribers

Answer Question   |  December 11, 2007  7:35 AM
Merge replication, SQL Server 2000

vb.net appilication not running a in network
Hellow All I have developed a small appilication in vb.net 2005 with sql server 2000. the appilication is running in a machine is ok. but when i am going to access the appilication through another machine in the network is not running. How can I solve this problem please help, Thanks

Answer Question   |  December 7, 2007  1:55 PM
SQL Server 2000, Visual Basic .NET

sql server reporting server
I have seperate application server for ASP.NET(2.0) and Database server for Sql RS 2000, when i try calling reporting service webservice to generate excel and allow to download to the web user, it gives an error as “401 as unauthorised”, can anybody has a solution for this Regards, Prathesh

Answer Question   |  May 15, 2008  12:56 PM
ASP.NET, Reporting Services, SQL Server 2000

full text search in sql server 2000
can anyone tell me how I can get full text search to work in SQL Server 2000 ? Ive installed it, created a catalogue, selected a table (with a primary key) stepped through the wizard, in fact followed all instructions to the letter. When I run this query SELECT * FROM guidance WHERE CONTAINS(Title, ‘Cardiac’) [...]

Answer Question   |  January 29, 2008  3:48 PM
full text search, SQL Server 2000

how do i resolve two conflicting msde instances?
I have installed a second application that uses msde (ms sql server 2000) but during installation the installer found an existing msde db. when I try to use the 2nd application, it tries to log on using a different password, unsuccessfully. Does anyone know how to create a seperate msde instance that i can use? [...]

Answer Question   |  November 14, 2007  8:42 PM
MSDE instance, SQL Server 2000, SQL Server 2000 Desktop Engine