Skip to main content

Questions tagged [visual-studio-2010]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
778 views

An expression of non-boolean type specified in a context where a condition is expected, near 'List'

myconn.Open() Dim command As New SqlCommand("Select * from Food where Food List = @list", myconn) command.Parameters.Add("@list", SqlDbType.VarChar).Value = txtbox1.Text Dim ...
hunter's user avatar
  • 1
1 vote
3 answers
3k views

find table used in SSIS Package script [duplicate]

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 ...
pete's user avatar
  • 11
0 votes
1 answer
76 views

SSIS AND XLSM load time issue Visual Studio 2010

I am having the following issue of SSIS AND XLSM load time issue Visual Studio 2010 I want to speed this up I am reading a .xlsm as my excel source I have noticed its loading / reading every row of ...
pete's user avatar
  • 11
0 votes
1 answer
499 views

Visual Studio 2010 Shell Error - is it Causing this SQL Server error?

Visual Studio 2010 Isolated Shell has the infamous "Invalid License Data. Reinstall" error. I have SSMS 2014. I have tried reinstalling several times, I installed Visual Studio 2013 but SSMS doesn't ...
justwondering's user avatar
1 vote
1 answer
5k views

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 ...
silvyG's user avatar
  • 13
0 votes
2 answers
7k views

Visual studio 2010 missing BI 2010 (SSDT 2010)

Where can I find a link to install SSIS 2010 ( SSDT 2010 or Business Intelligence 2010) I have VS 2010 on my machine.
knahs's user avatar
  • 45
1 vote
1 answer
186 views

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". ...
Shmuel Milavski's user avatar
1 vote
0 answers
139 views

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/...
Sir Swears-a-lot's user avatar
0 votes
1 answer
2k views

Overload resolution failed

I am using reporting services to generate a list of families in my database. After the first family member in the list, I want to put the family's address: family, First 123 la la lane Somewhere, Ca ...
AWippler's user avatar
  • 101
0 votes
1 answer
517 views

SSDT schema compare, removing and then renaming stored procedure result is incorrect

The initial setup contains two scripts: stored_procedure.sql stored_procedureV2.sql What I did is: Remove stored_procedure.sql Rename stored_procedureV2.sql to stored_procedure.sql When I perform ...
Steve Van Opstal's user avatar
-4 votes
1 answer
239 views

ExecuteNonQuery () not fungsional and database failed [closed]

Public Class Form1 Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load Dim SumberDb As String = "Data Source=c:\users\ogieuntung\documents\visual studio ...
Yogie Prasetia's user avatar
-1 votes
1 answer
727 views

SQL Server CE tools to modify database in network share

I am using SQL Server CE 4.0 SP1. I am using Web Developer 2010 Express to connect to database and perform operations like creating table, modifying column etc. But we cannot connect a database in a ...
IT researcher's user avatar
0 votes
0 answers
48 views

SQL Database query working really slowly

I have a database with two columns: 1)Word 2) Times Used When the user enters a word it find the combination of words already typed (ex: combo = hello world) and updates the database using a ...
Dman's user avatar
  • 133
0 votes
1 answer
4k views

SSMS 2014 installation - "Invalid license data" when opening ASP.NET files

I have just installed SSMS 2014 Express on a brand new Windows Server 2012 (x64) so I connect to the SQL Server 2014 instance running on a different Windows Server 2012. This is working without issue ...
freefaller's user avatar
6 votes
2 answers
4k views

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 ...
ddubs's user avatar
  • 61
5 votes
1 answer
519 views

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, ...
Pavel V.'s user avatar
  • 747
0 votes
1 answer
4k views

Install SQL Server 2012 missing vs_Setup.msi from Visual Studio 2010

I am trying to install SQL Server 2012 Enterprise with SQL Server Data Tools included. I understand that SQL Server Data Tools is part of what was formerly known as BIDS. The installation for SQL ...
Ash Machine's user avatar
0 votes
1 answer
6k views

SSIS Connection String Expression at Run Time and during Execution

I have an Excel connection manager which should write to a file which does not exist prior to runtime but rather is created during execution. I have an expression set for the connection string ...
Juan Velez's user avatar
  • 3,253
2 votes
0 answers
679 views

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 ...
Chris's user avatar
  • 303
2 votes
1 answer
2k views

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 ...
codingbiz's user avatar
  • 123
7 votes
2 answers
18k views

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 ...
Vikrant More's user avatar
4 votes
2 answers
6k views

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 ...
Rich Shealer's user avatar
5 votes
1 answer
752 views

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] ( [...
Dwight T's user avatar
  • 223
3 votes
1 answer
4k views

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 ...
Ashish's user avatar
  • 727
7 votes
1 answer
1k views

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 ...
Dor Rotman's user avatar
42 votes
7 answers
14k views

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 ...
Nick Chammas's user avatar
  • 14.7k
17 votes
3 answers
669 views

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 ...
Contango's user avatar
  • 411