I own a small business office and deal a lot with SQL servers and exchange servers. I get the following error when I try to use Microsoft Visual Studio 2005 Service Pack 1 design tools to open a database connection with Microsoft SQL Server 2008.

Microsoft Visual Studio

This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.

I have Microsoft Visual Studio 2010 Ultimate installed on Windows Server 2008 (x86 & x64) with Service Pack 2, 1GB RAM, 30GB of HD space, DirectX 9 capable video card running at 1024 x 768 .

While I was trying to debug a stored procedure, I got the following error message

There is no source code available for the current location

I tried logging in as a Sysadmin but it comes up with the same error. I tried performing `Allow SQL/CLR debugging` and restarted MS visual studio but the error persists. Could not find much in the web and this error is quite annoying ….

I have SQL server 2005 installed on my Win XP SP 2 machine. When I try to do a modification on my DataBase, it throws up an error message.

“A bad Database error has occurred “in SQL server.

Upgraded my XP machine to latest SP 3, but the error does come back. It is a fresh installation of SQL and I do not have any previous version installed. Not sure if anyone can help me with this error.

Recently I purchased a new Dell Laptop pre-installed with Windows 7. After finding out that all editions of SQL Server 2005 SP3 and SQL Server 2008 SP1 are supported on Windows 7, I purchased SQL server 2005( SP3) and installed it on my laptop. When I try to open up Visual Studio 2008 and connect to SQL Server database, I get an error message:

Unable to add data connection.
Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

Hello there,

Hi,

I´m currently using a SQL Server on top of VMWARE Server with Win 2008 64 bits, with 4 GB of RAM. I´ve assigned 3 GB to SQL Server and the rest left it to OS management. But I always keep getting the impression that the box needs extra memory. Currently we´re running primarily batch processes. Are there any best practices out there regarding SQL?

Regards.

Hi friends,

I have tried to use Row Count Task in SSIS. I just want to count the incoming rows and to save the count value in a variable. I tried all the possible properties and options in this task.  It was hard for me to configure this task. It was always giving an error in the Editor page itself. Please help me to configure and get the desired results.

Thanks.

Hi mates,

The Bulk Insert Task in the SSIS is not getting executed and it's displaying an error regarding the execution. I have checked the configurations, it is correct. I have tried many times, but it was giving different errors during each time of execution. I don’t know what is happening with this Bulk Insert Task in SSIS. Please help…..

Thanks.

Hi fellows,

I have an excel file which consist of file name and location path. I want to take those two values for variables in SSIS. For example, in the excel sheet, in the first row, I have entered “file_a” in the first cell and the “c:aa.txt” the file location path. I have created two variables “file_name” and “file_path”. I want those two values in the excel to be assigned to these two variables.

Variable          Value
File_name        file_a
File_path         “c:aa.txt”

Hi,

I have a comma separated data file (csv). I have to load this file to a SQL table using Data Flow task in SSIS. Below is the sample data from the source file.

Id, name, city
1, A, NY
2, B, LA
3, C, NY
4, D, NY
5, E, LA

I want the data where the city is equal to “NY” only to be inserted. Like this,

Id, name, city
1, A, NY
3, C, NY
4, D, NY

I have tried writing a SQL query, but I can’t. One way is dumping all the data into one table and again inserting into a new table using conditions. But the data size is around 20 GB. So it takes more time and large space. Is there any alternate way?

Thanks.