Some feel it is a happy medium to go with a number of tempdb files to match the number of processor chips not cores...

You can do it with SQL 2008, the biggest two suggestions I have are.

1) Create a SQL Server login (native) with full DBO rights to that database and give it...

I see that a lot with dynamic SQL I used to search my reversed dynamic SQL for erehw and remove it if it started the trimmed string, but 1=1...

So when you say invisible, are you saying that when you go to read the trace file it does not appear or if you are running two traces at the...

Well, there is a lot to this.

The first thing I would recommend is try running the db migration wizard from Microsoft

http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx

And take a look at what it scripts...

You may have better luck on the SQL 2005 forum. Also did you look at your install logs? What do they have to say?

Well the first thing that comes to mind is, what version of SQL Profiler are you using? You mention a 2K database are you using 2K profiler or 2K8...

Do you want to delete all of the data?

If so take a look at truncate table.

Well since both Access and SQL Server are Microsoft products it would be logical to assume the transition tools would be better.

Also the SQL Server install is more straight forward...

You might want to look at some third party stuff then. The other option would be to do a trace, edit the SQL and add waits and then...

I think what you asking for is something that I don't think profiler does what you are looking for...

I think you are looking for this.

That the SQL get replayed with...

Take a look at

http://squirrel-sql.sourceforge.net/paper/SQuirreL_us.pdf

And search for Stored Procedure, the second entry seems to indicate you need the SQL Server plugin to generate the correct syntax for JDBC

Ok, does the job just have t-sql step(s) or does it shell out or anything like that.

Don't think you can do instance management. One thing to watch out for is memory usage, Resource governor doesn't manage memory so if you have two instances and...

If you do an sp_who2 does it appear to be running? What kind of job is it?