dbo Schema issue

Early Access Program for SQL Source Control

Moderators: Chris Auckland, David Atkinson, sherr

dbo Schema issue

Postby jimithing1980 » Mon Mar 08, 2010 11:59 pm

It looks like the Source Control system ignores certain default schemas such as dbo. The problem is, we have changed the schema a bit - we have used the following against this schema:

Code: Select all
GRANT VIEW DEFINITION ON SCHEMA:: [dbo] TO [cy_reader]


Due to this, the dbo schema always wants to load into source control, but when you try to load it into source control, an error is thrown likely because the program explicitly ignores the dbo schema and it doesn't see any changes that need to be made (The error says "The array must contain at least one element").

I've sent the error report, but I thought I'd bring it up here since I'm sure others will encounter this soon.
jimithing1980
 
Posts: 8
Joined: Mon Mar 08, 2010 11:26 pm

dbo Schema issue - Nothing to Commit Error

Postby sherr » Tue Mar 09, 2010 12:57 pm

Thanks for sending in the error report and posting this issue here.

I think you see an error like "Nothing to Commit" because the dbo schema shows up on the Commit list, but then it doesn't actually recognize this change so it thinks there is nothing to commit.

We are currently working this issue. Our internal reference number is SOC-799.

For now, please just ignore this on your commit list. If there are multiple objects to commit, it will NOT error because there will be something else to commit.

There is a manual workaround if you want to get this object off your commit list and you don't expect it to change much. (If it changes a lot, you'll have to re-do this workaround each time.)

Workaround: Manually create the schema file if you are familiar with TSVN:
1. Check out the repository to a working folder (You can right-click on the URL on the Setup Tab and copy it.)
2. In the Security\\Schemas directory, create a text file and rename it to dbo.sql
3. Paste in the text from the db version diff pane on the Commit Tab (You can right-click on the diff pane Select All, right-click again and copy.)
This was:
-- Permissions

GRANT VIEW DEFINITION ON SCHEMA:: [dbo] TO [cy_reader]
GO

4. Remove the "-- Permissions" and the empty line from the top of the file
5. Save the file
6. Use TSVN to Add and Commit this change back to the repository
7. In SSMS, refresh your commit list

The dbo schema should no longer appear on the commit list.
sherr
 
Posts: 126
Joined: Thu Mar 19, 2009 12:45 pm
Location: Cambridge


Return to SQL Source Control EAP

Who is online

Users browsing this forum: No registered users and 0 guests