Red Gate forums :: View topic - object reference not set to an instance of an object
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

object reference not set to an instance of an object

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
dbdmora



Joined: 21 Nov 2011
Posts: 33
Location: Atlanta, GA

PostPosted: Fri Mar 02, 2012 4:45 pm    Post subject: object reference not set to an instance of an object Reply with quote

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
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Mon Mar 05, 2012 4:45 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
dbdmora



Joined: 21 Nov 2011
Posts: 33
Location: Atlanta, GA

PostPosted: Tue Mar 06, 2012 3:42 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group