Read it. But, we're not running multiple instances of sql on the same server. We had some ODBC users denied access because of the hide feature port change...

Yep, here's an exapmle of our format:

DTSRun /S "XXXXX" /N "P_12345" /U "domain\userid" /P "XXXXX" /M "XXXXX" /W "0" /E

I'm told that enabling the hide SQL option changes 1433 to 2433. Is this true? When we enabled it and restarted the system all of the scheduled jobs...

All--

Thanks for the quick reply. We figured it out. Apparently something did change. The option in SQL server to hide port 1433 was set. But it doesn't play nice...

All--

Thanks for the quick reply. We figured it out. Apparently something did change. The option in SQL server to hide port 1433 was set. But it doesn't play...

We're just looked at an 8-way and when you add of the cost of licensing SQL Server EE. The cost is well into the six-figure range. Total cost...

Thanks for the reply. There is nothing encrypted that I can tell.

Just my opinion:

I have a mainframe DBA background (now sql server) and have seen all kinds of things over the years from max 8 characters in Assembler to whatever...

I forgot to say that we are running SQL2000 SP3.

We've installed about 6 without any major incident. However, on one install we are seeing a memory error for sqlmanager on startup.

One Question:

When rolling back SP3 is it necessary...

Several websites shows the highest processor for a DL760 as 900/2mb L2 cache. Where did you see the 2ghz/2mb??

Hi, I new and just read the article. We use DB maintenance plans to do our index rebuilds and a third-party product called TSM to handle backups (it has...