To use Log shipping out of the box you need enterprise edition. However ther are scripts available that will do it for you, I recently wrote a set for a...

You need to look at the attribues section of the results

If you AND 32 this will indicate that A is set

Read Only 1

Hidden 2

System ...

The benefit of indexed computed columns when being searched upon will out weigh any performance hit (if there is one) of maintaining them.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

If you get to point 3 then consider the following,

You probably (should) have 5 or 6 main filtering options, that should always be specified. Code this as fixed conditions and...

I concur

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

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

The monitor server should be resilient enough to not suffer from failure. The level you take this to is up to you, raid, processor, memory, network, etc.

The load I believe...

What would also be great is a set of links on someones profile that gives the scripts, articles, case studies that they have posted.

This alos needs to be accessible for...

If you are filtering the data returned using OPENROWSET might be better as this can pass the query to Access to filter. Depends on the link to the Access database,...

Antares66

With respect to coalesce your example misses the point. Using coalesce on static variables is fine, but linking back to a column is the problem. Have a look at this...

Difficulty is that 10ms is the smallest unit went it comes to datediff and dates, so you need to do some looping. In addition should dropcleanbuffers otherwise the first suffers...

What I think is needed is a priority type thing, or a post type that can be assigned to a question. Something like "Discussion", "Request for info", "Help!!!", "Oh god...

With that you must always get a tablescan.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

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

Try this

http://www.sqlservercentral.com/scripts/contributions/528.asp

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

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

You can also execute an SP_ stored procedure based in master on any database

myDatabase.dbo.sp_help fred

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

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

The best book I've seen so far is http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=528

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

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