After installing the VSTS Database GDR and importing a SQL Server 2005 database that includes the ASP.NET provider schema tables, I get the following warnings: TSD04151: Procedure: [dbo].[aspnet_Users_DeleteUser] has an unresolved reference to object [dbo].[sysobjects].[name]. TSD04151: Procedure: [dbo].[aspnet_Users_DeleteUser] has an...
Hi, I'm using VSTS Database Edition GDR Version 9.1.31024.02 I've got a project where we will be creating multiple databases with identical schema, on the fly, as customers are added to the system. It's one DB per customer. I thought I should be able to use the deploy script to do this. Unfortunately I always get the full filenames spec...
I have just installed the GDR RTM version of Visual Studio Team System Database Edition GDR RTM. It all seems to work wonderfully, but I seem to have to edit XML (Database.sqlpermissions) for specify SQL Permissions. Am I missing something? For that matter where is the schema diagram tool? I understand GDR exposes alot for extending ...
I am playing around with the Visual Studio Team Suite Database Edition GDR, and I've imported several of our databases. I have literally thousands of warnings, most of which are unresolved references. I understand when we don't have SchemaName.dbo.TableName for external references, but why would there be warnings (even errors) when the...
3.5 SP1 was released, which also included 3.0 SP2 and 2.0 SP2. All three of these service packs potentially introduced a number of incompatibilities if you were using these versions of any of the frameworks and installed the update. There was a lot of bad press regarding the SP1 update and the number of issues it introduced. e.g. http://...
I'm using Visual Studio Team System 2008 with GDR Version 9.1.40413.00 and am trying to resolve the issue of deploying a single DB project to multiple databases. For instance if I have a Performance.DB project I would like to deploy databases called Performance, Performance2, Performance3 etc. However it seems if you go to the properti...
I am working on quite a large DB based project and I like the look of a few of the power tools. Looking through the related downloads, I found out about GDR R2, I cannot find out that much information about it - Not even sure what GDR stands for, but one thing that caught my eye - "this release incorporates many previously released Pow...
Using the VS 2008 GDR update, I have created a database project. I have created a SQL Server deployment package. I have created a database unit test. Using some wizards, the stuff got into my tfsbuild.proj file so near the end of the automated build process a database is created. I lack a little control of the whole process, I now see....
I have a Visual Studio 2008 GDR Database Unit Test (Data Dude) with some TSQL that calls a sproc. I then have a single select statement that produces a 1-row result set with 2 columns. I want to pass the test if the values are equal and fail if it is not equal. I do not understand how to config/code this, can anyone point me in the right...
Hi all, im having major issues trying to mirror our newly upgrade database solution (to GDR)... specifically the database project settings. when i run a schema compare, i get differences on the IsTornPageProtectionOn variable, however when I go to the settings of the database project this setting is nowhere to be found! i have tried ...
I have Visual Studio Team System 2008 Team Suite, that included Visual Studio Team System 2008 Database Edition. I have VS 2008 SP1, .net framework 3.5 sp1. In a project SQL parser, we need to add two assembly references two: Microsoft.Data.Schema.ScriptDom.dll Microsoft.Data.Schema.ScriptDom.Sql.dll those assemblies: are in Vi...