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 |
|
Grifter
Constraint Violating Yak Guru
274 Posts |
 Posted - 2010-03-25 : 08:04:38
|
| Hi allI have a create table script I am running from sql query analyser (Open > fileCreateTable.sql) and when I have ran the file I cannot see the table in enterprise manager until I commit, if I do not commit the database hangs. My problem is I want to just test the scripts run, see the tables in the list and undo my changes but do not want to commit the changes just now.I know I can run the script and if I get no errors I can assume the tables have created fine but wonder why it is I cannot get into the database without it hanging. When I go into Management > Current Activity it hangs and I get this error:Error 1222: Lock request time out period exceededThe db does not hang when I run a script that creates only one table but hang and get above error when I go into management > Current Activity; it will hang when I run a bigger script, that is, after pressing F5 to refresh enterprise manager.Do I have to commit to see the table in the list in enterprise manager?Thanks for any suggestionsG |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-25 : 13:46:33
|
| you have a begin tran in the script? tried removing it?can do this too:select name from sysobjects where type = 'u' |
 |
|
|
|
|
|
Hanging Problem