Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
subhaoviya
Posting Yak Master
135 Posts |
 Posted - 2014-06-13 : 11:19:38
|
| Hi, I have dropped one computed column from my table and tried to recreate it with persisted option. it takes more than half an hour so i cancelled the query. the query cancellation is execution for more than 1 hour. and the query status is suspended. what action needs to be taken?thankssubha |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-06-13 : 11:47:04
|
update Administratorset Action = max(Patience)where SchemaChange = 1and Size >= Medium
Too often we enjoy the comfort of opinion without the discomfort of thought. - John F. Kennedy |
 |
|
|
subhaoviya
Posting Yak Master
135 Posts |
Posted - 2014-06-13 : 11:56:42
|
| I am not having administrator table, can you please explain your response.thankssubha |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-06-16 : 14:51:47
|
You need to be patient and the rollback will complete... The fact that the schema changed takes time. The fact that the database is fairly large takes time. The "Code" is just a (perhaps not very clever) joke saying that YOU, the administrator, need to maximize your patience when the rollback involves schema changes and the database is bigger than medium size.
Too often we enjoy the comfort of opinion without the discomfort of thought. - John F. Kennedy |
|
|
|
|
|
|
Computed column query