You are welcome.

CEWII

Basically what I am getting at is that for specific conditions you might issue a:

SET TRANSACTION ISOLATION LEVEL [isolation levlel]

within the sproc. I usually only change the level when...

Also, SQL Server Management Studio WILL NOT create new DTS files, even with the backward compatibility tools, you can edit them but not create new ones from scratch. MS...

I am interested in the answers to the other 2 posters questions as well.

But I can almost guarantee that even if it is a permissions issue it will ALSO be...

The most common is "Read committed", it is also the default. What you are using is what is commonly referred to as "dirty reads". The isolation levels you...

My guess would be market penetration. The 4GB limit has caused me to waive off Express a few times because the base data was already too close to that...

I think I see the problem.. It is deciding what record IT wants to work on.. It should accept either an ID for the record it should be...

You are very welcome.

CEWII

From the GUI on the bottom of the window does it list the file on E:, if it does (and it should) it should say error or something next to...

So they exist on a SAN or are they on some kind of local storage array? I'm trying to get your topology in mind..

CEWII

I tend to agree, that is a pretty good synopsis, although to continue the line of thought, you can upgrade a DTS to SSIS but it isn't always 100%. ...

That is a lot clearer.. I would probably have switched to backing up to a file server instead of local drives, but that is me..

CEWII

I believe those are registered in the GAC. I don't think that anything NOT registered in the GAC can be referenced in SSIS. Sorry.

CEWII

Ok, so what happens to backups when the SQL servers on Node 3 failover to Node 2 or Node 1?

CEWII

Lookup "Internal Activation", I think this is exactly what you are asking for.

CEWII