Actually there are a lot of factors that affect this, hardware and design wise. If I remember correctly Microsoft has a stats for the big DB transaction (TPC) for sql...

I don't think it could be too proprietary but I have not discovered how to hook and read the TL encryption myself. Unfortuanetly looking around the only tool I come...

Ok first of in a datetime field even a shortdatetime you technically have a date that is not visible. If you attach Excel to a table and key the time...

Hey Dan, thanks for the link. I had been looking for it myself and will test when I get a chance.

"Don't roll your eyes at me. I will tape them...

Check out the scripts library here and at http://www.planetsourcecode.com. You might also want to look at DBSS SQLPERF(LOGSPACE) and take a look at the output from

use master

go

sp_helptext sp_spaceused

or just...

Yes it should be that it is confused by this line

account_id = @nAccountID and category is not null

Try something like

account_id = @nAccountID and

(case @nCategoryLevel

when 1 then category1

when 2 then...

First are we talking about the Oracle connection? If so then the login account is for the box. Server should be the Oracle instance name. Also try tnsping or tnsping80...

Not really without seeing it for myself. But could be the way duplexing is set up on your network and if this connection was chattering (sending broadcast type garbage) you...

Well it depends. If the file is local to the Server in question then yes it will go faster. The reason is when you execute the wizard from you client...

Thank you, and as for an update, when I was doing SP4 beta it looked like the had casually fixed it there with no mention which is not unusual. However,...

Have you tried using SQL*Plus from the machine you are performing this on to see if the problem is the way you have Oracle Driver or your parameters?

"Don't roll your...

You can use Task Scheduler to start Agent when computer starts use the wizard to Add task and launch Agent that way. May need to create a batch file with...

Run profiler against the recieving server looking at SQL Statements and see what commands are being sent to the destination. COuld be that Wizard has a problem and is causing...

If you want to try the method with profiler you can start a trace on the server and set it so you can see who made the changes as well....

Usually this means you are missing a file that SQL expects to be able to reattach the files. This may be the the primary file, a secoundary file, or the...