Viewing 15 posts - 826 through 840 (of 1,884 total)
Curtis is totally correct. It may be Agent that polls every several seconds.
May 15, 2006 at 3:00 pm
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
| Article ID | : | 281633 |
This article...
May 15, 2006 at 2:56 pm
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
May 15, 2006 at 10:42 am
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...
May 15, 2006 at 10:22 am
#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...
May 15, 2006 at 9:55 am
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....
May 15, 2006 at 9:41 am
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...
May 12, 2006 at 3:20 pm
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...
May 12, 2006 at 3:04 pm
Rudy,
The original question was posted by Anthony probably exactly because the ports between his network and DMZ are restricted.
May 12, 2006 at 12:47 pm
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.
May 12, 2006 at 12:30 pm
Hi,
This is only a guess: you are using Trusted Connections (your Windows authentication). It just could be that your token somehow could be used by MSDASQL but not SQLOLEDB. Did...
May 11, 2006 at 2:25 pm
Greg,
Running a named instance is a bigger problem than running 2 versions:
1. Named Instances don't support all features
2. Each service has to run on its own Port Or IP Address....
May 11, 2006 at 2:06 pm
Use sp_trace_setfilter in your code if you do it as a server trace. Use Database ID. I could not make Database name work as a filter, but Database ID works...
May 11, 2006 at 1:56 pm
Steve,
How to implement a linked server between a network and DMZ?
May 11, 2006 at 10:17 am
If you did disconnect and re-connect with your EM than make sure you are connecting to the correct database or correct server. This is NOT a joke, this is from...
May 11, 2006 at 10:16 am
Viewing 15 posts - 826 through 840 (of 1,884 total)