Have you rebooted? Does this server run as local system or an account? You've tried both methodsin 814844?

Sorry, not sure what to do, but curious. Have you checked the log...

Received in email:

the DBA created a SQL 2000 database and converted the PeopleSoft 7.5 / Oracle . The instance 's that were compared both are on SQL 2000...

Do they run manually (interactively) or as scheduled jobs or both?

What is in the packages that doesn't work?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Have you tried DTS? Is this directly from Oracle to txt? Or is MSSQLServer in between?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Apologies for the delay, was on vacation.

I have to disagree. A low priority process, that moved minimal data in real time, could be a real boost to performance. How often...

I added a section. Select "My Account" above and there is an entry for "Recent Posts". Let me know if it works.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

I'd forgotten about that one .

For the reports, I'd add a big DRAFT under the header. When he asks, tell him that the report is in test....

I'd use an ASP page. Take the old and new, submit both to sp_password and get the success or failure.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Thanks, but no. Our TAM from MS came through a little later. BTW, I now have SP 3, 4, 5a for 6.5, 1, 2, 3, 4 for 7 if anyone...

Thanks, I noticed as well. Hopefully I'll fix this soon.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

The search was modified originally to support our saved searches that send you email results over time. Since then, we've implemented another peice of search software that works very well,...

You need CALs.

The basic item is if you have users who are authenticating, then they need CALs. If you are on the Internet, with non-authenticated users, then this is a...

entregra from Lumigent might be better.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

How many processors? It's 2 x # of CPUs. And it can depend. It you have very short queries, but lots of them, then you may not notice issues, but...

We've got a fwe SANS here, used for various things. What we've seen.

3 run fairly flawlessly, one has had numerous failures. To be fair, this is the oldest one and...