White circle is normally caused (if the server exists) by you not having permissions to query the state of the service on the machine (i.e different domains)

Simon Sabin

Co-author of SQL...

Just to clairfy SET XACT_ABORT is used to ensure exactly this. That if one inset fails then the whole process will abort.

Often this is not needed as the changes...

If you have maintenance plans they should tell you if they set a db to single user.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

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

I can't iterate this more using coalesce in the manner shown means indexes can't be used, if you are doing this on large tables, and this is the primary filter...

Surely you should backup the log rather than just truncate it?

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

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

The crdate tells you when it was created and the schema_ver increments every time a change is made. You would need to hold this information somewhere and check if it...

How are you trying to restore the database. Are you selecting the restore over existing database. If so try deselecting this. I am only guessing as I haven't seen this...

A word of warning trying to maintain a generic database of this nature will cause a serious maintenance and support overhead. In addition to increasing development time considerably. I have...

So in summary if your app is doing something like

sp_prepare "some sql"

execute

execute

execute

execute

sp_prepare "another sql"

execute

execute

then it will be faster but if you app. only fires the execute once for each...

Sub tree cost is a figure that is mainly used by the query engine to determine when to kick adhoc sql plans out of the cache. It is an indication...

You will need to install the client tools to use bcp.

You could hack it and start by copying bcp and then see what happens

Simon Sabin

Co-author of SQL Server 2000...

Looks like your reading loads of data.

Look at the number of requests compared with the number or actual reads. If there are not significantly different your are reading a very...

What version of SQL are you using?

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

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

Ok you can do it with one helluv a hack http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_20169020.html

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

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

You can find out if the column is involved in a read or write action or a select * action from the last columns

selall bit...