Chris,

I believe that the unicode portion comes through properly. I have a SQL Server 2000 (SP 4) ETL process that uses DTS from our DB2 system, and don't have...

Sameeg,

You will need you use "MSDASQL" provider (This is the provider for using ODBC connections). I was actually able to use the ODBC System DSN and ODBC Linked Server...

Andrew,

I would be an "Oracle biggot" too if I had been working with the technology since 1998, been an Oracle employee since 1993 and is currently the Vice President of...

Although a lot of this information is several years old, the "basics" still apply. There are several companies that will perform the migration for you, but that does not...

Be sure that you are given access to Oracle's Metalink, and create a Metalink Account. This is Oracle's version of patches, Knowledge base articles, and being able to log...

Loner,

I look forward to the Question of the Day. My Correct scores also come in around 25%. (Some weeks I get 4/5 correct, then hit a slump of...

Stephen,

The script below can also be modified to suit your needs. It should crawl all database objects and report on ownership for you. Thanks to Scott Coleman for...

In an nutshell the Import/Export Wizard creates an SSIS (SQL Server Integration Services) package for you. The SSIS engine is the second generation DTS engine from SQL Server 2000.

The...

Pete,

Glad to hear you were able to finally get to the root of the connectivity issue!

Thanks for sharing your notes on the "Fix".

See you around the forums ...

David,

I feel for you!

You mentioned that your company business deals with clinic/insurance. If you are an insurance company, I assume that you have an accrediting body that certifies your...

The "Server Name" column output of the script below will give you the

"Virtual SQL Server Name (Cluster)" for your cluster, allowing you to use it as your value for...

Pete,

Murphy's law! I had a 50/50 chance ...

-- will check master database

DBCC CHECKDB ('master')

If the DBCC CHECKDB come back with *any* errors, make sure to post everything that...

How to make an ODBC TRACE

(Quick and Dirty Draft)

CLIENT:

Get a client machine ready to make the connection ...

DATABASE SERVER:

START >> Control Panel >> Administrative Tools >> Data Sources (ODBC)...

Paul,

Fantastic!

I am glad someone else can benefit from my "pack rat" mentality of taking T-SQL syntax notes.

Now maybe you won't be dreaming about the ODBC connection screens this...

Pete,

Just to rule it out, have you run a DBCC CHECKDB against the SQL Server database being used by the application?