Showing status

rdobrich

Hi,
I just compare two databases, and have different result with old and beta SQl compare.
Old shows correctly result.
Beta shows in upper window some stored procedures and functions to be different ( they are identicly), but in detail windows shows that they are the same for every row.

I have screen shot, but I don't know how I can post it[/img]

rdobrich

I just found what was the problem.

I options I have option 'ignore permision' uncheck.
For that functions and stored procedures I have different permisions.
I have permisions into role on that objects.

When I try to sinchronize them nothing happens.
I have the following script (the scripts are the same for including role filter or excluding. )

I don't know how I can see difference in role security.

/*
Script created by SQL Compare from Red Gate Software Ltd at 30.11.2005 9:51:52
Run this script on bogibatina.birin to make it the same as server3.birin
Please back up your database before running this script
*/
SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE id=OBJECT_ID('tempdb..#tmpErrors')) DROP TABLE #tmpErrors
GO
CREATE TABLE #tmpErrors (Error int)
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
BEGIN TRANSACTION
GO
IF EXISTS (SELECT * FROM #tmpErrors) ROLLBACK TRANSACTION
GO
@TRANCOUNT>0 BEGIN
PRINT 'The database update succeeded'
COMMIT TRANSACTION
END
ELSE PRINT 'The database update failed'
GO
DROP TABLE #tmpErrors
GO

Andras B

rdobrich wrote:

I just found what was the problem.

I options I have option 'ignore permision' uncheck.
For that functions and stored procedures I have different permisions.
I have permisions into role on that objects.

When I try to sinchronize them nothing happens.
I have the following script (the scripts are the same for including role filter or excluding. )

I don't know how I can see difference in role security.

Hi,

could you send me just the permissions on this stored procedure pair. Also could you indicate which permission is assigned to a role or a user. My email is:
Andras.Belokosztolszki "AT" red-gate.com

Regards,
Andras