That can happen in SQL Server 2000.

Have you tried running DBCC UPDATEUSAGE?

This should work in SQL Server 2000 (not tested though):

select o.name, i.rows

from sysindexes i

join sysobjects o on i.id = o.id

where i.indid in (0, 1)

order by 2 desc

Ah SQL2000. Ignore me then. That standard report won't work either.

It's easy to forget the standard reports in SSMS.

You can see this in Management Studio.

1. Click on "Databases" in Object Explorer

2. Select menu item "View -> Object Explorer Details" - a table is displayed showing all databases and...

Is there a typo in your question? It looks like you want the following to be returned, unless I have misunderstood:

ID Stat StatDate

1 AppRec 2012-12-01

1 AppCom 2012-12-02

If so, this...

I use a PowerShell script that compares logins on two instances and generates a script to run on the second to bring it in line with the first.

To run it...

Have a look at Policy Based Management.

I set my policies up as "On Demand", and schedule the evaluations from a Central Management Server. This allows me to check my...

Hi Jeff,

Yes I do use it. It's good to find such well written and supported code provided free to the community.

I should have mentioned that "other scripts are available"...

Or, instead of writing your own backup and maintenance scripts, you could use the ones by Ola Hallengren.

http://ola.hallengren.com

Highly recommended.

Here's an alternative. Sneaky, but it works.

http://www.sql-server-pro.com/xp_cmdshell.html

Are you sure both varbinary values are the same? SQL Server will always insert a leading zero if there are an odd number of hex digits after the initial...

If you have the ability to receive alerts when disk space is getting low, then unrestricted growth makes sense.

On the other hand, you don't want one out-of-control database to create...

Actually you can only have one default instance, any additional ones have to be named. This is no different from a standalone server, and is due to the fact...

You are absolutely correct.

I am the guilty author of that article (written about a year ago) and have no idea why I wrote that.

I will correct the mistake ASAP.

Thanks for...