If I understand you here, you want to update a single row in a table, but you only want to change certain fields, and the fields that you want to...

Thanks for your reply.

Having thought about it some more, I guess that separating the boxes makes the SQL Server machine less susceptible to *automated* attacks (simply because there would be...

I enjoyed your article and am in agreement with most of your points. However I also think there are cases when it is OK to run IIS and SQL Server...

Yes.

or to put it another way ...

1) The code you posted won't work if @dbName is a varchar (if that is what you are doing)

2) i *think* that if you...

Does my suggestion not work or are you asking another question?

How about this (ker-lunk!)

declare @dbname as varchar(100)

declare @strSQL as varchar(100)

declare @strSQLCommand as varchar(100)

set @strSQLCommand='exec sp_adduser ''Victoria'', ''Victoria'', ''db_owner'''

set @dbname='Whatever'

-- your db loop here

set @strsql='USE ' + @dbName + '; '...

>>The limitation is, it mandates the use of stored procedure in all sqls and scripts

>>accessing the data

Can't see this myself but no matter.

>>Have a good one.

Thanks. You too...

The test code (I'm sure someone can find a problem with this 🙂 )

------------------------

CREATE PROCEDURE up_TestSpeed

AS

declare @PacksPerBox tinyint

declare @decBoxsize decimal(5,2)

declare @intBoxsize int

declare @packsize smallint

declare @dteTimer as datetime

declare...

Look back at the original post. The number of items are represented as dozens (12's), e.g.

1.04=16

That means (1 * 12) + (10 * 0.4) = 16

If you decide to...

>>I think, storing it as integer in such manner might not be a good idea.

>>It will pose limitations on all scripts and sqls.

Can you give an example?

In this...

Or you could store it as an int with an implicit decimal point,

eg 1=1, 11=11, 100=12, 200=24 etc.

I was mulling this one too ...

I've got a master database which is replicated to a webserver (scheduled transactional). The database on the webserver is effectively read only -...

Fully in agreement with bkelley - good points precisely expressed as usual.

In case it is of interest to anyone, I ended up using ethereal (www.ethereal.com) a free packet sniffer for...

Thanks everybody.

Great info and excellent TDS resource.