Tagged Questions

2
votes
2answers
115 views

Is there a SQL Server 2008 R2 specific target for SSDT projects?

I am making a SQLCLR stored procedure in Visual Studio 2012. I have these options for target platform: Is there not a SQL Server 2008 R2 specific option? Is this because SQL 2008 R2 shares the same ...
1
vote
1answer
60 views

Visual Studio DAC with Schemabound View containing hierarchyid::GetRoot() - Two part name needed?

In Visual Studio, when trying to create a DAC which has a schemabound view which contains hierarchyid::GetRoot() this error is generated and the project does not build. However, the t-sql is ok as if ...
2
votes
3answers
117 views

What SSMS and/or Visual Studio tools sync SQL Server environments?

I need to sync table structures, stored procedures, triggers, data, etc. between environments. There are dev, QA, and production environments. I am in a Microsoft-centric environment. What tools ...
2
votes
1answer
243 views

Export SQL Server varbinary field to string using Visual Basic script in SSIS?

I'm using SSIS to export data from a set of tables to flat files. The export is running great except for one table with a varbinary field. The export is running a Visual Basic script task to load the ...
1
vote
1answer
1k views

“Procedure: XXXX has an unresolved reference to object XXXX” errors

After using for some time MS SQL Server Management Studio for creating and editing databases I tried to use Visual Studio 2010 "SQL Server 2008 Database Project" for this. I used the SQL 2008 Wizard ...