Comments
Sort by recent activity
Thanks for the response.
Yeah I was doing some other activity on the same server and found some other oddities. We discovered serveral stored procedure suddenly could not be viewed/executed and that all of the constraints (and only the constraints) were suddenly unavailable to be viewed. We found that all of the permissions were missing on these objects.
DBA is at a lost to how this happened, since a month ago I was working with the same objects with no problem. So it is permissions and they will need to at least grant the view definition rights. But scary how no one knows what caused the change in the first place, and it only happened on this one server.
From the other topic: Note that some SQL Server 2005 objects may have the VIEW DEFINITION permissions revoked for a user. It may be necessary to grant VIEW DEFINITION to your user for the database. / comments
Thanks for the response.
Yeah I was doing some other activity on the same server and found some other oddities. We discovered serveral stored procedure suddenly could not be viewed/executed and tha...
I downloaded the SQL Snapper production (nice, btw) and it shows an error on the same database at the point it is Reading Constraints from the database.
Double checked the SQL Compare and it also shows that message when the error occurs. / comments
I downloaded the SQL Snapper production (nice, btw) and it shows an error on the same database at the point it is Reading Constraints from the database.
Double checked the SQL Compare and it also s...