How are you connecting to the server? ADO?

Here is an ADO connection that sets the timeout.

Set cn = New ADODB.Connection

cn.ConnectionTimeout = 60

cn.CommandTimeout =...

It should be faster if other concurrent accesses to the table(s) were getting locked out. The trade off is concurrency versus data integrity.

By lowering the isolation level you are...

(Cont. Part 2 of 2)

1996-1998Olicon Imaging Products, Inc. Responsible for the design and implementation of MS-SQL database to track medical images for product under FDA approval. Designed and...

Lee,

As a programmer and a DBA let me acknowledge that there are some programmers that do know their way around a database from both a design and administrative viewpoint. ...

1) LOL SQL# (Shouldn't that be SQL#.Net++)

2) Ask any DBA worth their salt and they'll tell you that programmers don't understand databases. In particular, they don't understand the...

How to make sure that the objects created are owned by dbo:

1) What we do - You can specify the owner name as part of the create statement. (e.g. CREATE...

This link leads to a DMO based application that can be used to move indexes from various

filegroups.

http://www.ocsqlsug.org/

Look under the Downloads section.

HTH

Steve Hendricks

shendricks@afsconsulting.com

Why would you want to express millisecond, a three digit quantity, in six digits? The system clock only has a granularity of approximately three milliseconds. The extra digits...

If you need to move a few indexes, Enterprise Manager will let you change the location. Bring the table up in Design mode, show the "Table and Index Properties",...

I have found that the tool will sometimes return a false negative. After using the tool to find the missing patches, I have applied the patch and re-run the...

The preamble intrigued me because it mentioned new Query Analyzer features would be covered. Instead, we are covering SQL security modes (regardless of Query Analyzer) and how to resolve...

Andy,

Thank-you. This is useful information.

The .GetIndexedColumnDESC is in the Object Browser (Surprise! Surprise!). I must have been blurry-eyed when I was trying to find this.

It looks like the...