I don't have BOL in front of me but look for a procedure with a name like sp_resetstatus.

Once you have done that you should be able to DROP the database.

This mind intentionally left blank

If you do WHERE {Function(field)} = {value} then you will probably do a TABLE SCAN because the value isn't an indexed value.

Probably won't matter in a small-ish database but in...

So am I correct in thinking that it is if a single transaction requires a growth in excessive of current free space limits plus one expansion?

That is (Company Removed) added to my SPAM filter and blocked internet sites!

SQL2000 also makes use of the INFORMATION_SCHEMA views. You can see the definitive list within the MASTER database.

Some of the system tables have changed in SQL2005 so I would...

bcp is one way. I use BCP to export the results from stored procedures.

You can use SQL Query Analyser .See The best kept secret about SQL Query Analyser....

It depends what you mean by huge

I had a requirement to produce a search that had certain compulsory search terms and a number of optional ones.

What I did was have...

I take it that these were not Windows Account users?

A login has an SID number which is unique to the box. SID 1 is the SA account.

If you recreated...

Try this article

Frank Buchan and David Reed both make the point about weaknesses in business analysis contributing to poor code quality.

Quality is something that needs to be something applied to throughout a...

The INT method does not require any padding.

The user wants to query for a range of dates then

CREATE PROC dbo.MyQuery

@StartYear INT ,

@StartMonth INT ,

@EndYear INT ,

@EndMonth INT

AS

DECLARE @StartPeriod INT ,@EndPeriod...

You could use an INT (4 bytes) and record February as 200602

You could use SMALLINT (2 bytes) and record February as 602. Of course your would face the a...

I saw something like this years ago in an Australian television program.

I believe that these windmills are called Darrius windmills.

The BBC played part of George Bush's state of the...

Try RESTORE DATATASE [Your-database-name]