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 |
|
rdosramos
Starting Member
4 Posts |
 Posted - 2011-01-13 : 13:25:11
|
| Hi AllWe installed SQL 2008 R2 on a new server and no matter what query we run the query just carries on process (debugging) and doesn't stop. Is their something wrong with the installation or is something to do with 2008?Any help would be great |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rdosramos
Starting Member
4 Posts |
Posted - 2011-01-13 : 13:28:25
|
| Forgive my stupidity but I have no idea on how to check that. How would I go about checking that? |
 |
|
|
rdosramos
Starting Member
4 Posts |
Posted - 2011-01-13 : 13:59:00
|
| NM |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-01-13 : 15:44:42
|
| How are you executing the code? Are you clicking on the green arrow button, or the red exclamation point (Execute)?If you are clicking on the green arrow, that is starting a debug session and is probably waiting for you to stop debugging. If you just want to execute a query - then use the Execute button (or Ctrl-E or F5).Jeff |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-01-14 : 00:51:28
|
| just execute 'sp_who2'.you will get list of spids.kill the spid which is present in 'Blkby' column. |
|
|
|
rdosramos
Starting Member
4 Posts |
Posted - 2011-01-14 : 01:14:47
|
| Thanks for all the help. sorted out the problem. Server was being over utilized and it could not run the script. |
|
|
|
|
|
|
SQL does not complete any queries