Yes they are read only but is so much quicker than using snapshots.

I think it can vary by vendor as in our environment SQL has no idea it's being mirrored using HP SAN mirroring. You can access the databases if you need...

Also, you will need licenses for your mirror site when SAN miroring. With SQL mirroring you don't as the databases are inaccessible.

You could try setting the query timeout on the server to a lower value.

At least then they are limited on how long their query will run and therefore impact your...

Looks more like the last service pack date to me i'm afraid.

Not very funny.

Hears mirror shatter.

Hi,

The connectors between steps can be 'on success', 'on failure' or 'on completion'.

I'd say it was the last one you require.

Have fun.

Had this earier today and it turned out my column delimiter was inside a column (was using tab). Changed the delimiter and all was well. Message is a bit spurious...

SQL Diagnostic Manager is excellent as being able to roll back through the history and see what was happening at a particular time helps with overnight diagnostics.

Also, the SQL Mobile...

On our SQL 2005 Enterprise 64bit 96gb clusters we usually leave about 8gb so sounds about right.

Colin,

Could you please explain why you would recommend 12gb of RAM just for the O/S?

Thanks.

I've tried your code and there is nothing wrong with it so it still looks like permissions.

You might want to have a look at LINQ or one of the many VB.net or C# application builders.

I'd try....

Log in using the windows SQL account your SQL services are running under.

Stop SQL Server so the fielstream file is not locked and then see if you can move...