It looks like that you need to relocate the used pages so that you can shrink. If there is a fragmentation in allocated space, DBCC SHRINKFILE without option just won't...

If you post the sample update statement and table/database schema on T-SQL section of the forum, you might get good feed back about how to tune the query from SQL...

Hi Everett,

I thought so, I'd do that all the time.. ^^;;

Right Jacek, I've seen so many times many developers made that kind of mistake about CHAR w/ space. I only uses for rare case that needs absolute performance gain and...

Hi Everett,

I don't mean to rude or anything so forgive me if I ask this question.

Is there a reason that you set the data type for year, month and day...

The first suggestion wasn't third party software.. well sending email part is third party software but that is freeware and rock solid program so easy way solution.

You can make it...

Try run this and get the result and try run it from commend. I don't know much about SQL Express 2005 but assume they are the same as regular sql..

DECLARE...

looking for this? sp_help '<table name>'

or

SELECT *

FROM INFORMATION_SCHEMA.COLUMNS

WHERE table_name = '<table name>'

No, you don't have to create device first. Just choose the "From Device" and click the "Select Devices"  and type the file name by using UNC name.

I don't know how to do that from pure SQL query but I know how to do that from Windows "Performance Logs and Alerts"

From coomputer Management->Performance Logs and Alerts->Alerts and...

Please anyone correct me if I am wrong..

1. No, you only need one license for Active/Passive one. LogShipping, on the other hand, you need two licensees (too obvious?)

2. Yes, you...

Another dump question that might be..

Can you try to use 'sa' from NT workstation to see if you get the option back? Just trying to isolate the permission problem..

It seems dumb question but are you using the same account? like 'sa'?

I just had to throw this out

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q165918

if "sp_resetstatus " doesn't work, I dont' recommend to do detach/attach route. I've done several times w/ testing environment and when it doesn't work, you have almost zero chance to...