Sql Server 2000 Interview Questions and Answers 

Can I Use Oracle 10g on it?
Can I Use SQL Server 2000 on it?
Can I Use Java on it?
Can I Use Visual Basic 6.0 on it?
Can I Use Crystal Report 8.5 on it?

When I try to upload a bunch of tables, the upload fails and throws an error on one of the tables.The error says "Table '<tablename>' already has a primary key defined on it." What could be the possible fix?
Am working with MS SQL server 2000

what is the use of apache.

what do i need to for installing apache.

How to use it.

i have sql server 2000

I am using Microsoft SQL Server 2000 (MSDE) and Microsoft Access 2003. I am using the onNotInList event for a combo box on a form. i got a snippet of code that allows you to add a value to a combo box/table if it does not exist. The problem is there is a line of vbcode from the snippet that says "Dim db As Database". "Database does not exist! The combo box is based on a table. Can anyone please show me either how do i get this snippet to work or show me a snippet that allows me to add new values to a combo box/table.

i want to copy the selected checkbox from checkedlistbox and want to display it in textbox , and that data in checkedlistbox must be retrived from database,
Front End : VB.NET
Back End : Sql Server 2000.

Is is possible to create a percentage graph in Visual Studio. Net 2003? The graph is not fixed. It will depends on the percentage that is retrieved from the SQL Server 2000 Database and the graph will display the number of passes/failures on the user interface.

Hi all, i have a problem regarding format of Crystal report, where im displaying data from Sql Server 2000 table.
Table has following fields- date, col1, col2, col3.
Now, the data in report should be displayed as:-

Date1
col1 col2 col3
Date2
col1 col2 col3
Date3
col1 col2 col3
can anyone sort out this problem??
thanks in advance

I am working on a web application in ASP and sql server 2000. I have made an enquiry form to store visitor's data base in sql server 2000. I want send him an Automated "THANKS" email on the email id entered by him on the said enquiry for. How to do This? What is the exact coding for it?

Can someone give me the answer? I have no idea how to do them ,,,thanks !!!
Microsoft SQL Server 2000 database management system provides the database administrator with full control over:

i) the indexes that are specified for each table
ii) the allocation of tables to disk

Explain how you would decide on appropriate choices for each of the above when producing a first-cut physical design for a large database.

. Describe in detail how an industrial-strength database management system such as Microsoft SQL Server 2000 could recover from:

i) the failure of an application program that had updated the database
ii) physical damage to a disk holding database tables during transaction processing.

Hi! Our companies has two off (1) G'dham which is main off (2) in Baroda

= In G'dham off =
* There are 30 comps connected in LAN
* 6 comps running Win98, 1 comp is Win 2003 server (Standard) which is configured as File Server rest comps are Windows Xp.
* There is no Domain Controller, comps are connected in Workgroup.
* All the users working on customiszed software designed in VB6.
* Database connectivity is provided through SQL Server 2000 which is installed in Windows 2003 server.
* All the nodes need sto be install all the necessary softwares like VB6, Crystal Reports,

SQL server client installation to run the customazied software.

= In Baroda off =
* There are two comps
* one is windows 2003 server and one is Windows Xp.

= The need =
* We want to connect Baroda off comps with G'dham off so that Baroda off comp can use the same connectivity of G'dham off data.
== ?? ==
* Through bsnl broadband? Which business scheme? Unlimited or any other? wht is VPN ? static IP? how to use?

if I install j2se on my computer, must i install jdbc driver on my computer separately?
or if i have sql server 2000, has it jdbc ? and no need to install?

Hai ,

subject: crystal report 8.5 Version 8.5.3.975 - arabic character\letters\alphabets - support Regarding

Software environment :
I am using crystal report 8.5 installed with the following patches:
1. actxviewwin_en- ACTXVIEWWIN_EN_200312.EXE
2. cr85mainwin_en- CR85MAINWIN_EN_200312.EXE
3. dbexdrvrwin_en- DBEXDRVRWIN_EN_200401.EXE

I am using the crystal report for an application with Microsoft Visual Basic 6.0 service pack 6 installed and Microsoft Sql server 2000 service pack 4 installed with the machine having operating system Windows XP Professional Service pack 2 installed.

The SQL Server 2000 Database collation has been set to SQL_Latin1_General_CP1_CI_AS.

problem in three scenatiros explained::

1.When i query from database - sql query analyzer, the data stored in database appears in arabic but when i view the crystal report, the data appears in ?????????? something like this. (database displays correctly and crystal report displays incorrectly on manually opening the report)

2.Similarily, when i entered data in arabic from vb application, the data is stored in some junk format (probably unicode), this data in the crystal report shows the current entered data in arabic correctly. (database displays incorrectly and crystal report displays correctly on manually opening the report)

3. But when i view the crystal report through my VB application, the crystal report for arabic column was garbled or overwritten for the data that was entered in arabic in step 2. while all the previous data in database that shows arabic in database is shown as ??????? in the crystal report.
(database displaying correctly and crystal report displays incorrectly)
(database displays incorrectly and crystal report displays correctly)

I even tried installing with the service pack 3 - cr85win_en_sp3.exe. i also have arabic fonts installed, regional settings and language inputs also available for english UAE and arabic.

Please advise... what i have to do to resolve this error and what is the error thats causing the arabic characters not to be displayed.

Again, If it is Jeff B or hossan ahamed gonna reply me, please provide me a sample report with data in arabic and send me to noor.siraj @ yahoo . com

Hi guyz! Just wanna ask how to solve my problem regarding the Runtime Error: 20599 - Unable to open SQL Server? I already configure my ODBC connected to the SQL server and it was successful. But the error always appear eventhough I change my p2sodbc into updated version. what seems to be the problem why I cannot execute print preview? I used VB6, SQL Server 2000 and Crystal report 8.5

Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days.

How to bind a list of items in a dropdownlist based on the selection from another dropdownlist in asp.net?
I have dropdownlist named "Skill" which is bound to a database(SQL Server 2000). Now based on the selected item in this dropdownlist, a list of items from the database should be displayed in another dropdownlist Sub-Skills.