alter column

hi,
I have a production table with 2.6 million records, I need
to alter one column from numeric to varchar, does it will
affect the users? blocking the table? ThanksHi,
Obviously Yes....Dont do it when users are accessing the table.
Thanks
Hari
MCDBA
"Jen" <anonymous@.discussions.microsoft.com> wrote in message
news:088d01c3ced5$34b021e0$a601280a@.phx.gbl...
> hi,
> I have a production table with 2.6 million records, I need
> to alter one column from numeric to varchar, does it will
> affect the users? blocking the table? Thanks|||Changing the column data type (ALTER TABLE ... ALTER COLUMN) will acquire a
schema modification lock for the duration of the operation. In this case,
all data pages be updated so you probably want to do this during a
maintenance window.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Jen" <anonymous@.discussions.microsoft.com> wrote in message
news:088d01c3ced5$34b021e0$a601280a@.phx.gbl...
> hi,
> I have a production table with 2.6 million records, I need
> to alter one column from numeric to varchar, does it will
> affect the users? blocking the table? Thanks

All subscriptions will not run finish- status stays set to New

All of my subscriptions, old and new, will not run. They were working
last week, and nothing should have changed that would affect
subscriptions.
The status stays set to "New Subscription" and nothing gets logged in
the logs. I looked through the SQL Jobs and watched it as I made a
new subscription- this ran successfully (no sql errors and status was
"Succeeded"), yet nothing was written to the directory and the status
didn't change. I have tried various directories and I have also
verified that the timezone is correct.
What else can I check?
Thanks for your help.I was able to figure it. I noticed that the reportserverservice logs
were not being created. I restarted the reportserver windows service
and that fixed the problem.
On Jul 17, 10:28 am, Just Another Reporter <Crystal.War...@.gmail.com>
wrote:
> All of my subscriptions, old and new, will not run. They were working
> last week, and nothing should have changed that would affect
> subscriptions.
> The status stays set to "New Subscription" and nothing gets logged in
> the logs. I looked through the SQL Jobs and watched it as I made a
> new subscription- this ran successfully (no sql errors and status was
> "Succeeded"), yet nothing was written to the directory and the status
> didn't change. I have tried various directories and I have also
> verified that the timezone is correct.
> What else can I check?
> Thanks for your help.