Viewing 15 posts - 5,566 through 5,580 (of 49,571 total)
It's not an error. It's a message informing you that the database you're using has been changed.
June 18, 2015 at 7:02 am
I strongly recommend against moving the master database from one instance to another. I suspect it won't even be possible to move them up-version.
For your certificates, back them up...
June 18, 2015 at 3:34 am
Please note: 4 year old thread.
And you can run CheckDB on TempDB. It doesn't do the same amount of checks as for other databases, but it can be run.
June 18, 2015 at 3:14 am
If the index is not in the execution plan, then it's not useful for that query and is not been used.
June 18, 2015 at 2:31 am
Alvin Ramard (6/17/2015)
GilaMonster (6/17/2015)
Please note: 10 year old post.Hopefully the OP isn't still looking for that procedure.
Hopefully the SQL 7 server has long since been relegated to the trash...
June 17, 2015 at 2:54 pm
Please note: 10 year old post.
June 17, 2015 at 2:41 pm
JimmyJones (6/17/2015)
Do you have any 'foolproof' method to check the stored proc usage?
Yup. Extended events run for a full business cycle (usually a year). Use the bucketiser and group on...
June 17, 2015 at 2:28 pm
PearlJammer1 (6/16/2015)
The trace returns the object_id's of many stored procedures. I then query the sys.procedures and plug in the object_id to return the stored proc name.
Why don't you join the...
June 17, 2015 at 5:08 am
JimmyJones (6/17/2015)
This will tell you if a stored procedure in your DB had been run since the last server restart (or freeproccache)
Or other event which removes plans from cache, or...
June 17, 2015 at 5:07 am
Please don't cross-post
No replies here please, replies to http://www.sqlservercentral.com/Forums/Topic1695235-391-1.aspx
June 17, 2015 at 3:48 am
If you change the service account using SQL Server config manager, Config manager will add all the permissions that SQL Server needs. You'll only need to add in optional ones,...
June 17, 2015 at 3:30 am
j.grimanis (6/16/2015)
I am afraid that it is executed during the commit, thats why it cannot read the updated table
That is not possible.
Statements run sequentially. If you have a call...
June 17, 2015 at 3:19 am
j.grimanis (6/16/2015)
June 16, 2015 at 1:15 pm
As I said, Traceflag 1222 is to get the deadlock graph written to the error log.
The error's thrown no matter what, which means that any alert on the error will...
June 16, 2015 at 1:12 pm
Viewing 15 posts - 5,566 through 5,580 (of 49,571 total)