database-project
Visual Studio DB project fails to detect changes to stored procedure parameters. Is that normal?
Whilst working on a SQL Server 2008 database project in Visual Studio 2010 I added a new parameter to an existing stored procedure definition.When I built the project开发者_Go百科 it failed to detect[详细]
2023-03-28 00:24 分类:问答Visual Studio database project can't create a view over a synonym
I have the situation where I\'m working in a new database, built using a Visual Studio 2010 database project, which has a number of synonyms defined which point to our legacy database.[详细]
2023-03-27 09:24 分类:问答Synchronizing Schema View and Solution Explorer
DB_A -> DB project DB_B -> Schema Comparison with DB Project Apply Update Script to DB Project Schema View shows changes, but Solution Explorer does not.[详细]
2023-03-24 05:09 分类:问答Visual Studio 2008 SP1 with GDR2 - DBMDL could not be created
I get the following 开发者_JAVA技巧dialog when I try to load any DB project in Visual Studio. There is nothing else locking it, nor are the permissions on that specific folder restrictive.[详细]
2023-03-20 23:53 分类:问答Database Project; Cross-Database Intellisense
I\'ve been trying to move all my SQL databases to VS 2010 SQL Server 2008 database projects this weekend and have noticed that Intellisense is messed up when setting up cross-database relationships. N[详细]
2023-03-19 20:49 分类:问答Re-Importing/Updating a SQL Server database project after I modify the DB in Mgmt Studio
My team is working with a .NET 2008 DB Project in their solution so we have some way to persist the schema between machines and through development and keep things consistent.[详细]
2023-03-16 12:42 分类:问答Schema Compare and Update comments out unused code
I have a Visual Studio 2010 Database Project.It works great for most stuff. However one thing is very annoying.Say I have a table called dbo.MyCoolTable.If I go the the database and rename it to dbo.[详细]
2023-03-16 07:20 分类:问答SQL Server: Separate schemas or separate databases
We have two products t开发者_运维技巧hat get implemented at customer sites, one of which requires the presence of the other. I implemented a separate schema within the same database as the main produc[详细]
2023-03-14 07:45 分类:问答How do you rename columns using a Visual Studio Database Project?
I\'m using an SQL Server 2008 Database Prject in Visual Studio 2010 and now I need to rename one of my table columns. Using the SQL Server Data-tier Application project this can be done by right click[详细]
2023-03-10 05:54 分类:问答When deploying a database project with vsdbcmd I get the error "Vardecimal support is enabled for the database but disabled for the project"
I get: SQL01265 Vardecimal support is enabled for the database but disabled for the project I\'ve tried changing the .sqlsettings files to have: \"<VardecimalStorageFormatOn开发者_运维技巧>True[详细]
2023-03-08 17:49 分类:问答