1. In the job step go to advanced and enter an output file location.

2. Try this, you can exclude db's as needed...

declare @IDENT INT, @sql varchar(1000), @DBNAME VARCHAR(200)

select...

What is the error from the log?

Check the logins that you use to connect to the two databases, if you are using windows authentication check that the sql server agent...

The only 2 issues that you might run into are slower inserts, updates, deletes as everything will now get logged to the transaction log (this however should not be an...

Things to check: hard drive fragmentation? cpu bottlenecks? memory errors? page file usage?

Awesome, thanks (this'll save me a few hours waiting for the information from thr Oracle DBA)

What if the oracle login does not have permissions to view this system table? Is there another way?

I'd check the network i/o of each box, if you are writing or reading anything from a network and have the nic set on 10 base, or even 100 half...

1)I would purchase Dreamweaver for building a site, it's awesome and allows you to do pretty much everything (hate frontpage with a passion). You can check it out at

A simple way of doing it would be to have a checked_out column with a bit value, set this bit as 1 any time that the record is out for...

Just another piece of food for thought, rather than have a 4 instance active/passive make it a 4 instance active/active with 2 instances running on each node, you'll get far...

I'm running it on several servers and have not encountered any issues as of yet.

Are you logging in using a sysad level account?

This is an extended stored proc in master, and you have to be a sysad to execute.

Check your Windows 2003 server locale settings as it might have been set using a different locale from your other server. Also check the server collation type in SQL (right...

is "tblstore s" the name of the table or are you trying to create an alias for it? If an alias move the S outside the bracket and try again....

How about dropping and re-adding your login in SQL?