thanks for your quick response!

however, how come you use "rows" and not "rowcnt"?

Billy

not b2b... just thinking about how security should be addressed if the topic ever comes up.

thanks for your info. I'll keep the SSL in mind.

Billy

Thanks for your response. I am just thinking about furthering security on the sql server db we have. Putting a sql server open to the net, not sure...

Just doing a bit of research on the net...

the title of this thread should really be called:

"restricting access to SQL Server based on IP Address"

is it true that I only...

Thanks for all your responses!

Because the table I want to audit has many inserts from many locations, I was hoping that there is something simple I can use to audit...

So how do I determine and verify that a dual processor machine running ss2k has the appropriate licensing? am I just limited to the physical end user license agreements...

Did you check for any triggers on that table?

I don't think what you say is design behavior of SS. See below:

SET NOCOUNT ON

GO

USE TEMPDB

GO

PRINT 'Creating a table with no...

Thanks Gregory, Steve and all for your responses.

If I could get SQL Analyzer to execute those scripts, then it would make life a lot simpler because I can access my...

Thanks for the KB. SS2K was not shutting down but I think that the problem might have something to do with multiple threads.

The sql statement I was trying to...

thanks...

it shows that my previous reply needs to be correct...

PRINT CONVERT(varchar(8),GETDATE(),101)

...does not give you the correct date because the result requires 10 chars, not just 8.

Billy

nevermind...

PRINT CONVERT(varchar(8),GETDATE(),101)

yes, i sometimes finding working with dates in sql server requires a bit more work. like in your scenario, I have to format my date so that it is...

thanks...

the sysproperties table was not in the SQL Server 2000 System Table map I was using...

the system table map I got it from:

http://www.microsoft.com/sql/techinfo/productdoc/2000/default.asp

Billy

thanks!