I'm trying to find out if we can use bulkcopy via odbc in sql server 2005.
With sql server 200 we could use the odbcbcp.dll.
I can not find any info regarding this for ms sql server 2005.
Thanks,

I have a table as below
---------------------------
name    linkcode    level
---------------------------

Do you know of a good reference, or alternatively a rough-and-ready rule of
thumb, about indexing for purposes of analysing a database? I take a
snapshot of a fairly large database and analyse it ... so I'm not concerned
with the index performance issues associated with, say, ...

I have an ODBC 3.0 Application on Windows NT Server maintaining a
connection to a SQL Server 2000 database on the same machine. When an
error occurs, I'd like to be able to determine whether the error is
serious enough that the database connection has been lost, so I can

A stored procedure was running slowly so I took the code, removed the
subselect and included a join, then took the max and included as part
of a correlated subquery.
The result is below, however, this is no improvement over the original.

Hi to all.
Many times i saw that some people wrap the single insert, delete or update
statements to transaction.
My question is suppose i have procedure , and inside this procedure i perform

Most questions of exam 70-228 have a selection of answers that all seem
correct, but in reality, the right answer is the one that best solves the
question.There a few trick questions like how to allow someone access to
SQL Server using the Guest account over the Internet, and i ...

Is there a major speed difference if WHERE col like 'abc%' is used against
WHERE col = 'abc' in a select statement in stored procedure?
Thanks
Regards

I've installed SQL Server 2005 Express Edition on my machine (version
9.00.1187, the "June 2005 CTP"). Do you know the precise version number for
the .NET Framework that must be installed with it?
(.NET Framework v2.0.50215.45, which is the latest version that I can find

I have a problemo - basically i have one large SQL2000 DB. This is
edited / updated etc by users of the website i am developing. However i
also wasnt a SQLCE component as i want certain users to recieve
user-specific information from the database to their PPC's (I don't

I have a VB app which stores information in an Access 2000 db. The VB app
handles multiple users (it's a logbook type of application, users share
lookup tables but don't share information among themselves - IOW, I couldn't
see your log entries and you couldn't see mine).

Would it be possible to install both sql server express 2005 and sql
server 2000 on the same server win2k machine?

How to find total number of SQL Server which is running in local
network m/cs, through C# or from one of SQL Server? - Thanks in adv.

I want to create a select statement showing -->
John -- happy  -- Alice -- Mad   -- Sunday
John -- Mad     -- Alice -- happy  -- Monday
Here is my table structure:

Can I use asp 3.0 applications with SQL server Express 2005?
If yes, how easy is it to upgrade slq server 2000 databases to sql
server express 2005? (All the databases are under 4gb)