Try RAISERROR instead of print.

if @search_type <> 'ausId' and @search_type <> 'email'

begin

RAISERROR ('Search Type...

I'd suggest doing it as one statement. If you do the count first and then the insert, there's a chance that another insert could occur in between and make the...

Sure. It's one of those not-so-intuitive queries (understatement)

This will work providing you have no table partitioning. If you do, it may give strange results

select object_name(p.object_id), ds.name as FilegroupName

...

skjoldtc (12/2/2008)

---

I have a question for the frequent posters? Do you spend you employer's time answering questions here or are you doing it on your own time. If on your...

For...

Full backup does not truncate the tran log. Never has. Only a transaction log backup, an explicit truncate or a switch to simple recovery will truncate the tran log.

Don't bother with lock pages on a desktop. Since it prevents SQL from been swapped out, it could give you perf problems with other apps.

Lock pages is important on servers...

That's going to have to be a procedure, since you have dynamic SQL.

Remove the select ISDATE ('5/1/2008') from before the Create Proc

You're missing begins for two of those ifs

If ISDATE(@DateMin) = 0

BEGIN

Raiserror('Please enter valid date format...

Monitor that regularly and when the available space gets low, manually grow the file.

That's going to take a while.

What's the availability requirements? Can you get a weekend where the DB isn't in use? It may not take that long, but just for...

He told us (panel interview, myself, two other DBAs and a...

nate (12/2/2008)

---

Then, I moved on to a different table that had no clustered indexes. Once I removed 5 unused columns and rebuilt the non-clustered index, the 'Data Space' value...

Script all the objects (perhaps excluding the foreign keys) to files, bcp all of the data to file. Create a new database, run all of the script files, bcp all...

It's got nothing to do with space available. Grows are very intensive operations and will cause the entire system to slow down due to the IO impact.

As for monitoring, try...