Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [visual-studio-2010]

27 questions
42
votes
7 answers

Why should I use Visual Studio 2010 over SSMS for my database development?

Visual Studio 2010 introduces database projects and a whole array of related features that supposedly facilitate database development. I've used SQL Server Management Studio (SSMS) for many years to do my database development without issue. Why…
Nick Chammas
  • 14,810
  • 17
  • 76
  • 124
17
votes
3 answers

How can I guarantee that inserts to SQL Server 2008 R2 are cached in RAM first?

Imagine a stream of data that is "bursty", i.e. it could have 10,000 events arrive very quickly, followed by nothing for a minute. Your expert advice: How can I write the C# insert code for SQL Server, such that there is a guarantee that SQL caches…
Contango
  • 411
  • 3
  • 7
7
votes
1 answer

Visual Studio 2010 deployment script creates objects in wrong order - trigger after stored procedure

I created a view that selects from multiple tables in a complex query. Due to the complexity, I created insert/update/delete INSTEAD OF triggers to handle these operations on the view. I also created stored procedures that update the view. When I…
Dor Rotman
  • 253
  • 1
  • 2
  • 6
7
votes
2 answers

What is the difference between SQLEXPRESS and MSSQLSERVER?

I am using SQL Server 2008 R2, when I looked into the services for SQL Server I saw there are two different services with different instances. SQLEXPRESS MSSQLSERVER Can anyone help me to get clear the difference between #1 and #2? Thanks in…
Vikrant More
  • 251
  • 2
  • 4
  • 11
6
votes
2 answers

SSRS - Set Page Break within table

I had to modify a report that was assembled entirely within table (with 1 column and 10 rows). After my modifications, the report now spans multiple pages and I need it to break naturally at one point (i.e. beginning of Row 8). Is there a way to…
ddubs
  • 61
  • 1
  • 3
5
votes
1 answer

Problems while building plpgsql_check on Windows

I try to build plpgsql_check extension by @PavelStehule (Erwin Brandstetter recommended it to me in this answer) on Windows XP 32bit with Visual Studio 2010 (I used this article as a manual). However, I got following errors: error LNK2001:…
Pavel V.
  • 757
  • 3
  • 13
  • 30
5
votes
1 answer

Non-English characters are not imported using SSIS or Visual Studio Deploy

I'm having problems with importing data into a SQL Server 2008 database. If I execute the following statement in SSMS, it works fine. INSERT INTO [dbo].[ObjectiveRatingTranslation] ( [ObjectiveRatingId] , [TranslationId] , …
Dwight T
  • 223
  • 1
  • 7
4
votes
2 answers

Remove Database from SQL Management Studio Database List

I'm working with MS SQL Express 2008 and Visual Studio 2010. If you are attached to a local MDF file how do you remove it from the Databases list without deleting the file? The reason is to purge the list of databases for old projects. The next time…
Rich Shealer
  • 151
  • 1
  • 4
3
votes
1 answer

SET QUOTED_IDENTIFIER issue

I have created a Database Project in Visual Studio 2010 for a database which is in 2008. I am having issues in deploying the database as I don't know why, but at the time of deployment in some procedures QUOTED_IDENTIFIER is set to OFF But I…
Ashish
  • 727
  • 2
  • 14
  • 25
2
votes
0 answers

How to manage dynamic tables in Visual Studio 2010 Sql Server Database Projects

I am migrating a common set of databases in to a VS 2010 Sql Server Db project so we can keep it in source control, and deploy common changes etc. The databases are for the most part the same, except for a couple schema changes based on the current…
Chris
  • 303
  • 2
  • 6
2
votes
1 answer

Warning SQL01271: The unnamed foreign key between tables [dbo].[Match] and [dbo].[Team] will be checked by checking the table

I received this error while deploying a SQL Server DBProject DBProj.dbschema(0,0): Warning SQL01271: The unnamed foreign key between tables [dbo].[Match] and [dbo].[Team] will be checked by checking the table. Name the foreign key to avoid…
codingbiz
  • 123
  • 1
  • 6
1
vote
3 answers

find table used in SSIS Package script

I have a number of SSIS Packages I am trying to locate a table that is populated by one of the SSIS Package is there an easy way to find in the project where database.dbo.tabledata has been used in a script within the project please help team
pete
  • 11
  • 2
  • 4
1
vote
1 answer

Business Intelligence Development Studio installation for Visual studio 2010 problem

I want to install Business Intelligence Development Studio for doing report development in Visual Studio 2010, however in my installation process, I cannot find BIDS in the feature selection. What I have done is: Install Visual Studio 2010 Upgrade…
silvyG
  • 13
  • 1
  • 4
1
vote
1 answer

DSV - SSAS Project - New 2 Columns In Table Change More then I Planned

I encountered a very weird thing. I added in my DWH table 2 new columns but when I refreshed the DSV after adding this to my multidimensional project I saw that more (3) columns have been "changed". I did not touch these 3 columns(Marked in red )…
Shmuel Milavski
  • 111
  • 2
  • 9
1
vote
0 answers

Date picker is dynamic in SSDT but not in SSRS

Running SQL Server 2012 SP1 and SSDT from same distribution. (VS2010) When I display a report in SSDT the date selector on a date parameter is dynamic or responsive. When you click on the date (month/year) the date picker can zoom in/out. Or drill…
Sir Swears-a-lot
  • 3,253
  • 3
  • 30
  • 48
1
2