Curtis is totally correct. It may be Agent that polls  every several seconds.

Brian,

I think it may be a bug, I tried to look it up on the web today and found the following:

http://support.microsoft.com/?scid=http%3a%2f%2fwww.support.microsoft.com%2fkb%2f281633%2fen-us%2f

FIX: SQLOLEDB Provider incorrectly leaves transaction open

This article...

Almost everything in the list could be obtained from

On the server level:

select name, dbid,filename form sysdatabases

select count(name) from syslogins

on the database level for each database:

select

I think that the query and MS have their own connections each. Try to use sqlcmd command-prompt utility which is very similar to osql to run your query

Another option is...

#1: View - Registered servers. Create your registrations. When login, you will see a list of registered servers. I registerd 2 as Windows Authentication and one as SQL Server authentication...

Xavier,

There are 3 things that you have to  have in mind when storing images in the file system:

1. Backups. Your  backup plan should include database backups and attachments directory backup....

I know there are several scenarios for the failover for Mirroring and some are automatic some are manual and there are more features in Enterprise Edition.

Please see Table 1 in...

FOUND IT!!!

I had a moment and tried your statement from SQL Server 2000 towards SQL Server 2005 with running a profiler in 2005. The first (almost) thing it did was

set implicit_transactions...

Rudy,

The original question was posted by Anthony probably exactly because the ports between his network and DMZ are restricted.

To Chris:

I can only refer to SDK documentation in regards what is not supported for named instances in 2000:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_9i5u.asp

Working with Multiple Instances

The isql utility does not support named instances.