I believe it is an sql server internal extended procedure used by ODBC. So your client is not using it directly. It, I believe, harks back to the days when...

I read those articles and the say the problem is when you are using server side cursors but not that it forces server side cursors.

My app only uses SPs...

You need to look at ansi_null_default. You can set this at a database level but some clients overide this. You can override it to which ever way you want...

When I refer to server side cursor I mean a client side piece of code that is using a server side cursor an looping though the data. i.e. a recordset...

Well joined the party a bit late but will add my 2 pennies anyway.

Rules are great, but should be there as a basis, i.e to be challenged

FKs really have to...

The correct procedure is to restore your master database if your data files are still in the right place then it should all be back as normal.

The second is the...

If you are talking instances then you are still talking active passive. You have to consider an instance as a seperate server (especially with licensing).

So if you have 2 servers...

You should never, in my experience, need to use server side cursors. This is reinforced with .net where everything is client side. With client side recordsets you can do what...

Check hoe SQL Agent is connecting to the server. Right click SQL Agent, select properties and then the connection tab. You are probably using sa and so the password is...

I believe to do a backup to a maped drive you have to set that drive on the profile of the user account SQL Server is configured with. If you...

When comapring data you also make sure you are handling NULLS correctly. i.e. NULL = NULL is not true when ANSI_NULLS is off. either turn it on or use ISNULL...

What you mean MS might not be telling "the whole truth and nothing but the truth"

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

You can copy these columns from one table to another just like any other datatype just as long as you don't use local variables.

Simon Sabin

Co-author of SQL Server 2000 XML...

These are the actual physical costs rather than the theoretical cost, that you obtain though an execution plan.

You will however need to consider the amount of data returned.

Simon Sabin

Co-author of...

If you are using parameters correctly from your client, i.e parameters of the command object.

Then no replacing is needed as the text is handled correctly. it is only if...