object reference not set to an instance of an object

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

object reference not set to an instance of an object

Postby dbdmora » Fri Mar 02, 2012 4:45 pm

I am on SQL Compare Pro 10.0.0.143. I am updating my DB with alter permissions only that were commited to SSC and using the deployment Wizard and I get this Error message (object reference not set to an instance of an object) and the wizard won't deploy the script automatically. I copy the script into SSMS and run it, and it works. What am I doing wrong or a bug with software?

/*
Run this script on:

Prodserver1.db1 (Rev. 51526) - This database will be modified

to synchronize it with a database with the schema represented by:

DevServer1.db1 (Rev. 52003)

You are recommended to back up your database before running this script

Script created by SQL Compare version 10.0.0 from Red Gate Software Ltd at 3/2/2012 10:32:14 AM

*/
SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
PRINT N'Altering permissions on [dbo].[ML_FreeTilMayPromo2]'
GO
GRANT ALTER ON [dbo].[Table1] TO [dbuser1]
GRANT SELECT ON [dbo].[Table1] TO [dbuser1]
GRANT INSERT ON [dbo].[Table1] TO [dbuser1]
GRANT DELETE ON [dbo].[Table1] TO [dbuser1]
GRANT UPDATE ON [dbo].[Table1] TO [dbuser1]
GO
dbdmora
 
Posts: 34
Joined: Mon Nov 21, 2011 9:55 pm
Location: Atlanta, GA

Postby Chris Auckland » Mon Mar 05, 2012 4:45 pm

Sorry your hitting this issue.

It sounds like a bug, but I don't think we know about it. When you encounter this error, do you get a chance to submit the error report (with your email)?
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby dbdmora » Tue Mar 06, 2012 3:42 pm

I don't remember, next time I come across this issue, I will see if it allows me to email the error. Thanks for the reply
dbdmora
 
Posts: 34
Joined: Mon Nov 21, 2011 9:55 pm
Location: Atlanta, GA


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests