Activity overview
Latest activity by baschroeder
Compare Tables with Different Names
We have a series of tables in two different systems, the tables were built from the same source, but got different names in each systems database. Would like to be able to compare these two sets of...
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...
An unexpected null value has been encountered while querying
An unexpected null value has been encountered while querying the database system tables. Please make sure the database is in a consistent state by running DBCC CheckDB. If the problems persist cont...
Script one part of a compare, not everything
I have a table compare with both table changes and a missing constraint (index). I would like to script just the index change and not the table change. Is there a way to have it just do one part of...