Bill,

I took a second look at your original posting, and noticed that you are already connecting with SQL Plus. Shame on me for posting hastily!

There can be a...

CSDunn,

These sites may be of use:

DTS Resources

http://www.sqldts.com

SSIS Resources

http://www.sqlis.com

SQLIS Wiki

wiki.sqlis.com

Best of Luck.

I don't have access to any 64-bit systems, but I recommend the following:

The Oracle Networking errors can be a real pain to troubleshoot.

1) Compare the SID_NAME value in the LISTENER.ORA...

Vivien,

Since I can never have enough information ...

Checking again for "official" MS KB articles yields:

How to identify your SQL Server version and edition

http://support.microsoft.com/kb/321185

Syntax is given for determining SQL...

I use this handy guide from the good folks at SQLSecurity.com to keep myself up to date on SQL Server patches.

SQL Server Version Database

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

Description from the page:

"This is...

Tmp,

This is a long post, but as the old saying goes, I am teaching people to fish ...

Errors such as "Error 7399 :OLE DB provider 'MSDAORA' reported an error." can...

Gresford Thomas,

You are dealing with several phases for your project. I have given a rough outline of how I see your project unfolding, as well as where to get...

Cath,

The script is great.

Note to others, make sure that OLE Automation is enabled within SQL Server.

Howard,

I will send you a Private Message with my contact information so that we can continue to troubleshoot your issue.

hmbtx,

In my environment, we have vendor applications that authenticate with a Windows/Active Directory user, and then the application "spawns" a generic user for SQL activity behind the scenes. Perhaps...

Brandie,

My apologies. My last round of certification exams was for Oracle, and had Case Study questions lumped in with all the others. I guess I have to read...

Brandie,

Like GilaMonster mentioned, you may get 2 Case Study questions in your pool of 25 (or however many) exam questions. You have the entire 90 or 60 minutes of...

Curiosity got the better of me ...

-- Current user login information.

-- SQL Server 2000.

select

spid

,nt_domain

,loginame

,nt_username

,hostname

,login_time

from master..sysprocesses

-- Current user login information.

-- SQL Server 2005.

select

spid

,nt_domain

,loginame

,nt_username

,hostname

,login_time

from master.sys.sysprocesses

Regards,

Patrick,

We are using:

Name: iSeries Access ODBC Driver

Version: 10.00.06.00

Company: IBM Corporation

File: CWBODBC.DLl

Date: 6/6/2005

Using that iSeries Access ODBC Driver to configure a System DSN, on our SQL Server machine.

We then have a...

Using SQL Server Management Studio (SSMS)

Tools >> Options >> Query Results >> SQL Server >> Results to Text >> Output format

Drop down: Comma delimited

UNCHECK "Include Column headers in the result...