I'm hoping somebody here might be able to point me in the right
direction.
Basically, I'm looking for a "good" way to build tables such that
different kinds of stuff can grouped.

Were using the data transfermation service to copy in an Ingres II 2.5
database to an SQL Server 2000 database. Small databases don't present an
issue, but when pulling one across that's about 20GB its been taking between
12 and 24 hours. Both systems are relitively quick boxes ...

I've found thhis to be VERY fast when backing up:
BACKUP DATABASE FooBar to DISK = 'nul:'
Smoking fast!

Does anyone know if reporting services in sql server 2005 will support
querying against the native xml datatype?

I'm trying to write a script that loads default data into new tables that
(will) have an integer identity column.
When creating the table I do not specify IDENTITY on any column in the
table.  Then I use INSERT statements to load in the default data which

I've put my sql 2K transaction logs on a single drive off the raid 5.
I'm curious in what to do if that drive should fail ?
-will sql server start?
-will it recreate the logs somewhere else?

Hopefully not too dumb of question, but better safe than sorry -- is it
ok to delete the c:\SQL2KSP4 folder after the SQL SP install?
thanks! -Scott

We need to install CI database on CS server, and there are some issues
with stored procedures.
Database works and have CI collation (Polish_CI_AS). Server has
coresponding CS collation (Polish_CS_AS). Most queries and procedures

I have a table with the fileds  empid,empname,designation,branch.. etc I
have 5 types of  designations CEO,BM,PL,Tester,and PRG and the two branches
those are Hyderabad and Visakhapatnam i need the query like
first CEO name next Hyderabad BM Name next Hyderabad PL name next ...

I have been successful at setting up three or four DTS packages to run
using the DTSrun command line utility and the Windows scheduler until
now. The latest package gives me the following error no matter what I
try.

We have just upgraded a 32bit server to 64bit Windows 2003, we had client
alias working correctly before when os was 32bit but now we have gone to
64bit i can't get any aliases to work.
I've tried configuring exactly the same alias on a 32bit machine and that

I have a table of customers.
I have a table of products they have ordered.
How can I find all customers who have ordered productA and productB at
any time.

Hi,
When trying to modify or add a table using enterprise manager I got this
message error:
Enterprise manager: not enough storage is available to complete this

How would I find out how many bytes are in row in a SQL Server 2000 table?
If there is a stored procedure to do this that would be great since I need
to figure this out for many tables.
Thanks

having a spot of trouble writing this one. if you are so inclined and have a
moment, i'd really appreciate your insight.
i have what amounts to a purchase order type of setup...a descriptive header
associated with line items. i have 3 tables...header, lineitem, and