As written in the subject, I would like to know if it is possible to create
a named instance of SQL Server 2000 on a W2K3 Server that already have a
default SQL Server 2005 instance?
I know that the contrary is possible but this way is it still true?

Hello - suggestions greatly appreciated.
I'm trying to import data from similar tables between a local
access database and a network accessible sql server.
After using the Microsoft SQL Server Management Studio import wizard

First of all, my SQL coding skills are not very good. Therefore I am
looking for a script which will export all SQL2k DB Roles (Application
& Database) including the Users (native SQL & AD Groups (we are using
mixed mode)) into a *.CSV.

Here is a table where column2 needs to be transposed. The output table
will be id values in C2 transposed. The values in C2 can have
different values separated by commas. Is it possible? Thanks.
C1 C2

I would like to apply referential integrity between two
tables that are not part of the same database.
Is this possible ?

I have a budget for a  1 SQL Server related conference this year and I've
never attended one. Could someone educate me on the who, when and where. I've
heard of SQL mags "Connections" but I dont know anything about it other than
name.

i need some advice.
we have here:
win2003r2sp2-32bit 4gb ram  dual quad-core xeon (8 cpu´shown and
managable)

I am going to upgrade SQL2000 to SQL2005 because 3rd party application
requires SQL2005.  My plan is upgrade my current database on SQL2000 to
SQL2005, but keeping SQL2000 for fall back plan.
Is there any impact on performance if I have SQL2005 and SQL2000 running on

I have an application that use 2 databases. I would like to be able to
produce a diagram with tables from both databases. Is this possible ?

on sql server 2000, try to do integrity check on several database once a week
but failed, what would be main area to look up? thank you

If  I have an index on a datetime, will a where clause with year(<datatime
column>) use the index? Or should I create a seperate index for it?
Thank you

Hi, we work on sql server 2000, when try to view the taskpad of the database,
always has the internet explorer script error, and click no nothing could
come back, what would be the fix? thank you

We need to manage all pdf files(sixe from 10k to 10mb) and have about
500,000 monthly.
My question is that should I design a table with image field there to have
PDF file stored in table or to have PDF files in file structure and store

I Can't seem to get LIKE to work in a stored procedure.  For instance this
sql works in a query...
SELECT     username, approle, billingcustomer, emailredundant, groupadmin,
branch, nakey, companyadmin, bcstring, dateapproved

Has there been any word as to when the release of SQL 2008 will be?