Comparing table structure

Is there any tool to compare table structures between two databases?
For example: When comparing Table_A and Table_B, which fields are
missing, which relations are missing, etc.
Thanks,
GasparHello,
SQLCompare from Redgate software is a good DB structure and Data compare
software.
http://www.red-gate.com/products/SQL_Compare/index.htm
Thanks
Hari
"Gaspar" <gaspar@.no-reply.com> wrote in message
news:egp9yfLYHHA.3984@.TK2MSFTNGP02.phx.gbl...
> Is there any tool to compare table structures between two databases?
> For example: When comparing Table_A and Table_B, which fields are missing,
> which relations are missing, etc.
> Thanks,
> Gaspar

Comparing table structure

Is there any tool to compare table structures between two databases?
For example: When comparing Table_A and Table_B, which fields are
missing, which relations are missing, etc.
Thanks,
Gaspar
Hello,
SQLCompare from Redgate software is a good DB structure and Data compare
software.
http://www.red-gate.com/products/SQL_Compare/index.htm
Thanks
Hari
"Gaspar" <gaspar@.no-reply.com> wrote in message
news:egp9yfLYHHA.3984@.TK2MSFTNGP02.phx.gbl...
> Is there any tool to compare table structures between two databases?
> For example: When comparing Table_A and Table_B, which fields are missing,
> which relations are missing, etc.
> Thanks,
> Gaspar
sqlsql

Comparing table structure

Is there any tool to compare table structures between two databases?
For example: When comparing Table_A and Table_B, which fields are
missing, which relations are missing, etc.
Thanks,
Gaspar
Hello,
SQLCompare from Redgate software is a good DB structure and Data compare
software.
http://www.red-gate.com/products/SQL_Compare/index.htm
Thanks
Hari
"Gaspar" <gaspar@.no-reply.com> wrote in message
news:egp9yfLYHHA.3984@.TK2MSFTNGP02.phx.gbl...
> Is there any tool to compare table structures between two databases?
> For example: When comparing Table_A and Table_B, which fields are missing,
> which relations are missing, etc.
> Thanks,
> Gaspar

Compare Permissions Between Databases

I need to compare the permissions for a specific user between two databases
for views, tables, and stored procedures, to make sure that they are the
same.
If I could just figure out how to extract the data from each database, I
don't mind a certain level of manual comparison in Excel.
I have been digging around the syspermissions table, but can't find the
access level that has been granted/denied.
Any suggestions?
Thanks!Look up the PERMISSIONS function in SQL Server Books Online. It returns a
bitmap which can be massaged in t-SQL to retreive the object/statement
permissions.
Anith