that worked THANKS.

Used:

use database

alter table dbo.table

alter column coumn1 [decimal](9, 2) NULL

took less than a second.

Thank you everyone, it was very helpful.

Not quite, I only want the values between 8PM and 9PM for all of January and February...

Thanks, but I was trying to make it look like: 925071744

This is an application that is over 10 years old. There is not one specific query. There are many reports/queries that can be run. The problem is that if users...

The app will die on any PC  or server it runs on. Basically, when too much data is requested, the query runs, and as the app loads the data, you...

Ok, so do I need to run an ALTER INDEX on every table separately?

The reality is that this is a small IT shop. We need a DBA to support the database infrastructure, but the maintenance work is probably not more than 2 to...

Ok, sounds like it should be DBA/Data Systems Developer. We're back with your hybrids.

Does Data Systems Developer sound right?

Some addition info to the above:

Job Title: ?

Thanks for the info. I'm checking out DBArtisan right now. From a price point, there is no comparison, Quest charges per CPU. I have a couple of hundred servers to...

I think I understand your concerns and why you'd want to store pointers to PDF files instead of loading them to SQL. However, in my environment, it currently makes more sense...

This worked after I enabled it in the Agent profiled, and stopped and started the service.

Thanks...Nali

Greg, that worked, thanks.