How can we help you today? How can we help you today?
gsoules
Activity overview Badges (0) Posts (2) Comments (2)

Comments

Sort by recent activity
I see what happened. 1. To test SQL Compare I had removed a column (Customers.TourGroupName) from my local DB. 2. SQL Compare emitted T-SQL to remove the remote column, but at the end of the script it dropped me (mapsalive) as a user on the remote DB. The script is below. 3. With the user gone, I could no longer access my DB. Is this a bug or a feature? George 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 PRINT N'Altering [dbo].[Customers]' GO ALTER TABLE [dbo].[Customers] DROP COLUMN [TourGroupName] GO @TRANCOUNT>0 ROLLBACK TRANSACTION GO @TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END GO PRINT N'Creating [dbo].[AppPages]' GO CREATE TABLE [dbo].[AppPages] ( [Id] [int] NOT NULL IDENTITY(1, 1), [PageName] [nchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) GO @TRANCOUNT>0 ROLLBACK TRANSACTION GO @TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END GO PRINT N'Creating primary key [PK_AppPages] on [dbo].[AppPages]' GO ALTER TABLE [dbo].[AppPages] ADD CONSTRAINT [PK_AppPages] PRIMARY KEY CLUSTERED ([Id]) GO @TRANCOUNT>0 ROLLBACK TRANSACTION GO @TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END 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 PRINT N'Dropping users' GO DROP USER [OW\sqlservice] GO DROP USER [mapsalive] GO / comments
  1. Community
  2. SQL Bundle 5 Beta
  3. DB modified though permission error caused sync to fail
I see what happened. 1. To test SQL Compare I had removed a column (Customers.TourGroupName) from my local DB. 2. SQL Compare emitted T-SQL to remove the remote column, but at the end of the scri...
0 votes
Okay -- it's not a bug or a feature. It was user error, I think. Having never seen the SQL Compare user interface before, I had been clicking around here and there to familiarize myself with the product. Somehow -- and this is the strange part -- I thought I had only one table checked for synchronization when in fact all User objects were checked. Because there were users in the remote DB (added by my web host) that did not exist in my local DB, SQL Compare dropped them. I have since used the Filter feature to exclude and hide User objects so that this cannot happen I again. As a happy ending, I used SQL Compare to synchronize all of my local asp_net tables and views with the remote versions (they differed in auto-generated contraint names) and it worked perfectly. / comments
  1. Community
  2. SQL Bundle 5 Beta
  3. DB modified though permission error caused sync to fail
Okay -- it's not a bug or a feature. It was user error, I think. Having never seen the SQL Compare user interface before, I had been clicking around here and there to familiarize myself with the p...
0 votes
Total activity
5
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1