Thanks for the responses.

To clarify, the connection attempt is being made directly to the server through TCP/IP on 1433.

The netmon suggestion would certainly work and is probably...

If I've understood zach_john's situation correctly (unlikely I know), the FTP server only needs to allow access by a limited number of known machines (maybe even just one?)

Assuming...

Be careful using Replace alone to eliminate dodgy apostrophes and the like - it can give a false sense of security. Read the papers on Advanced SQL Injection on...

Firstly I'ld love to know just what is so sensitive about your SQL.

Secondly, to get an idea of just what you are up against, take a look at some of...

I sense some over-reaction to the evils of IIS - but I think the advice is sound on this occasion. With IIS you do need to monitor patches constantly,...

Obviously an emotive subject 🙂

I think there is a case for both generalisation and specialisation, it simply depends on what is expected of the employee and what the employee expects....

🙂

I'll be using that. Thanks everybody.

If designing a table in Enterprise Manager, set the Identity property of your primary key (which would typically be an 'int') to "Yes".

Simon

Thanks for the suggestion. However, unless I am missing something, I don't think I can use your extremely elegant solution for two reasons.

The first is that it would 'allow'...

I can't recreate the problem as I don't have any NT machines to connect to, but I recently spotted these two short articles which might be relevant (?)

One possibility is that you haven't enabled template queries or specified a directory for them.

When you set up your IIS/SQLXML configuration,

(Start -> Programs -> SQL XML3.0 -> Configure IIS Support...

Thanks Antares - I couldn't find any way to do it in the documentation, but without your reply I would have wasted plenty of time looking for it here there...

In response to myself (inspiration strikes too late again!) ....

I guess one way to validate a uniqueidentifier field is to test thus, but anyone know a cleaner more generic way...

Thanks for all your comments. I think we have a concensus!

I certainly agree with the idea of having fixed templates throughout all languages (as far as possible) and documenting any...