The view you are trying to use is only available in SQL Server 2005 onwards. Your database is in SQL Server 2000 compatibility mode. Is there any reason...

Yes, of course I'm serious, and I even took the trouble to explain why. Note that I used the word "consider" - I didn't say it was appropriate for...

I would recommend backing up the databases first, in case the worst happens, which it has done for me before. Given that you have taken a backup, you may...

The top row by what? Age of vehicle? Price of vehicle? Date vehicle added to invoice? Please also provide some table DDL and sample data.

John

Yes, it will - it is likely to cause physical fragmentation on the disk (at least...

You need to understand why the log file grew to the size it is. If it was through normal database activity, then there's no use shrinking since it will...

If it helps, you can set up a custom counter in performance monitor to return the number of rows in each of the tables you are interested in.

John

That's interesting - it contradicts what you said in your original post. Never mind - please will you describe how you're doing the backup of your database? If...

Excellent. Always good when the product behaves as documented.

John

From this page:

John

I'm still not entirely clear what you mean, but if you mean what I think you mean, this should get you started:

DECLARE

@Nowdatetime

,@Startdatedate

,@Enddatedate

SELECT

@Now= CURRENT_TIMESTAMP

SELECT -- startdate is date portion of two...

So what are you looking for, dockets that are more than two months old, less than two months old, or exactly two months old? Not sure whether your second...

Steve, I think this[/url] is the link you refer to.

We use the verify option on all our backups here, but we also have an automated process for test restoring our...

George

I think it depends. The ideal solution is for them to develop the solution on their own systems (possibly a copy of your database) and provide you with a...

You don't specify defaults in the query, you put them in the table definition. See the ALTER TABLE topic in Books Online for details. If you can't,...