That should work.

Andy

You can also run select serverproperty('licensetype'). Returns 'disabled' on my machine with personal edition installed.

Andy

Use a locking hint like TABLOCKX. Why do you need to lock the entire table?

Andy

You can still return it as part of an ADO recordset, but then you have to use the "chunk" methods to write it out to disk. Depends on what you're...

Steve, could you offer more details on that position?

Andy

Steve, what about using OpenRowset? I admit to a preference for linked servers myself.

Andy

Usually easier to use the ADO stream object to load/retrieve images. Just saw a post today with sample code:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3356&FORUM_ID=9&CAT_ID=1&Topic_Title=Working+with+images&Forum_Title=General

Andy

SAN's are pretty expensive still. Take a look at this article, an interesting point of view from Jim Seymour at PCMag.

http://www.pcmag.com/article/0,2997,s%253D1502%2526a%253D22768,00.asp

Andy

Often a good idea to reboot the workstation first.

Andy

Make sure you're using the full four part syntax, including the spelled out object owner.

Andy

Sounds like maybe a simple group by with a having count(*)<=3 would do it. If you post some sample data and DDL we can help you a little better.

Andy

There is a difference between opening multiple recordsets and returning multiple recordsets. You can open a basically unlimited number of recordsets using one connection. Good practice to disconnect them if...

I use set when I'm assigning a value to a variable directly or from a passed parameter, select if the value is coming from a table. Jimmy Nilsson had a...

Not really. Which table was missing? Hard to believe they just randomly disappeared?

Andy

Hey Bill,

This isn't an answer, but maybe will help anyway - you could run it as .vbs and write the results to a file (or even throw in ADO and...