0

In my sqlserver 2008 R2
I have a database script which generate successfully, but when I am trying to execute that script its only shows Executing query message and nothing happen.
I had waited at-lest 10 minutes for result but force fully I have to stop executing that query.

Note: All other queries are working normally, but only database script is not executing as explained above.

I doesn't know what's going on...

More details: This thisng is not happen on particular DataBase, it is make problem to all the database of my sqlserver.

Even no any single DataBase's script working, as explain below.
Its being remain to show Executing queries...

Improve this question
7
  • If you leave it long enough, it might finish (in which case it's just a lack of suitable indexes/poorly designed query). Perhaps it's a locking problem. Commented Jan 22, 2013 at 12:26
  • Its, still executing and my Db is not much larger, only 15 tables are there and not much table value... Commented Jan 22, 2013 at 12:29
  • Could you please post the query/details of any indexes/any isolation level settings you know of to help any future answerers? Commented Jan 22, 2013 at 12:35
  • On terminate query its shows following details "Msg 5069, Level 16, State 1, Line 1 ALTER DATABASE statement failed." I hope it will be use full... Commented Jan 22, 2013 at 12:57
  • It seems like some major problem in sqlserver Commented Jan 22, 2013 at 13:01
Related questions
2
"cannot execute script" error in SQL Server Management Studio
0
Problem running scripts against SQL Server
0
Can't open script file in SQL Server 2008 R2 job
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.