I spoke a little too loosely. Under EM I get the error:

-Unable to modify table:

ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]

Line 2: Incorrect syntax near 'vac_available'

Nothing special about that field...

Tom,

I am talking about the VB Scripts that are inside a DTS connection (to massage Source into Destination. Also, I made the mistake (?) of using table names in my...

I can dump the package to VB (under Sql 2K) but please elaborate on your comment "...then execute to recreate your package." How do I do that?

Other users can access the Sql server under EM using their domain accounts. I'll try stop/start the server, then reboot if necessary.(That is after I check the Event logs!)

Bill

Brian,

Yes the Windows Scripting Host is installed on the Sql server. And I can run the heart of that code as a VB script module on the same Sql box...

Andy,

I can generate a "pseudo"-key based on first and last name, address, and zip. I'm concerned that the Join involved may take "forever" to complete or blow the available resources...

Thanks to all for your responses.

I found SQLRedis.exe contained in Sql Server SP3. I installed it but it doesn't leave a menu or any trace I can find on the...

We have four Sql 7 servers and more on the way. (Each represents a different development effort; one is a web backend, another for special HP-midrange apps, etc) We were...

By "tweak", all I mean is that I set an alias to the sql server and specify that the alias use TCP/IP protocol.

Yes sir. i am the local admin on my machine.

Bill

Sorry about being unclear. I was able to resolve the issue myself. The ODBC DSN mapping under DTS (Sql 7) is so seamlessly done that I didn't recognize it pulls...

Thanks to everyone for their great insights.

Today I was digging around found more facts:

Total Processor Time = 2%

Size of paging file on C = 10-25MB (no wonder 97% utilization!). If...

Thanks you. I don't understand why the page file being so full is bad (after all we do have a page file on drive D). Also, generally the CPU utilization...

Steve,

It was in the January 31st edition of

********************

SQL Server Magazine UPDATE--brought to you by SQL Server Magazine

http://www.sqlmag.com

********************

1. ==== COMMENTARY ====

* WORST PRACTICES REVEALED

Greetings,

...

Both copies of SQL 2K are Standard Edition. One SQL server is the main machine that all user data is saved on ("active"?) while the other server is not accessed...