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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2010-05-24 : 11:13:28
|
In my SSMS when ever I execute a DDL I get date time in the result set. For e.g. create table t1 (id int) when I execute the above code, in the result set I get ------------------------------------------------2010-05-24 10:07:13.437(1 row(s) affected)------------------------------------------------Instead of - “Command(s) completed successfully.”This is happening only for a single database. (Hence, can't be a ssms setting issue.) I checked DB settings but didn’t find anything unusual. This is not very critical; however, somethimes very annoying. Does anyone have come across this?------------------------I think, therefore I am - Rene Descartes |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-05-24 : 11:15:56
|
| Check if there is any DDL trigger set for that databaseMadhivananFailing to plan is Planning to fail |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2010-05-24 : 11:26:02
|
| Thank you Madhivanan!You saved me. It was sooooooooo annoying. DDL trigger was the culprit. Ha Ha Ha. ------------------------I think, therefore I am - Rene Descartes |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-05-24 : 11:33:24
|
quote:
Originally posted by ravilobo
Thank you Madhivanan!You saved me. It was sooooooooo annoying. DDL trigger was the culprit. Ha Ha Ha. ------------------------I think, therefore I am - Rene Descartes
You are welcome  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Weird data time in the SSMS result set.