Thanks to everyone who has posted.

One feature I would really like to see on SQL Server Central (but it is in the big bucks content management arean) is the ability...

I've done a lot of work with web CMS and doc management systems and many of those store binary objects in the DB.

This is done so that those systems can...

I must admit I didn't look at the possibility of a high initial value but with a small range.

Following it through logically all the selects would come into play so...

Certain facilities (such as full text indexes) require there to be a primary key on a table.

Quickest way, without indexes or scripting is

SELECT * INTO tblReturn FROM tblDelivery WHERE 1=0

not sure why you are getting the error you mention. If you are doing a search/replace...

I would say that as far as the power of the workstation it really depends on what you want to do.

Personally, I would be more concerned with RAM than processor...

When their voices go up you way YES when the voices go down you say NO. This has got me through 12 years of marriage.

I've had whole conversations with...

I was given a cell phone 3 years ago. Presumably because socks were more expensive.

It had £10 of free calls on it and I still have £1.50 left on...

At least America is big enough to form a self-contained market!

Britain is probably the most open place as regards aliens buying up its industries and asset stripping.

I remain convinced the...

I don't know if it is still true, but if you wanted a cheap car that had twice the life of any other, never broke down and did better mpg...

Try the old DOS For command

for %f in (n*.sql) do OSQL -U dhuserid -P dhpass -S server2000 -d dh_db -i %f -o %f.log -n

Try putting

SET NOCOUNT ON at the head of your script but be warned, it doesn't suppress the message in all cases.

It IS consistent, but I have found that when using...

SQL uses single quotes not double

INSERT INTO tbMenus

(tbMenus_ItemID,

tbMenus_Item,

tbMenus_Parent_ItemID,

luDirectory_ID,

tbMenus_Item_Link,

tbMenus_Item_Link_Image,

tbMenus_Item_Full_URL,

tbMenus_Sequence,

tbMenus_Condition_text)

VALUES

(335,

'| GSL Account Search',

,

6,

,

,

'javascript:window.open(\''http://addcsr11:8080/CSR/Jsp/search.jsp\'',\''ExpressPay\'',\''\'').focus();void(0)',

12,);

If the next version of SQL Server has as bloated a tool as Management Studio it better have a code name of "Guantanamo Bay".

Until Christmas this year I have been...

I've found that when the date is in a clustered index on SQL2000 I got slightly better performance with BETWEEN.

I tend to use BETWEEN because it makes the code more...