All Questions

Filter by
Sorted by
Tagged with
1
vote
1answer
4k 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 ...
0
votes
1answer
5k 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 ...
2
votes
1answer
974 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 ...
6
votes
2answers
12k 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 ...
5
votes
1answer
630 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] ( [...
3
votes
1answer
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 ...
17
votes
3answers
618 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 ...