• vb.net 2008 and sql server 2008

    How can i connect to the sql database using the app.config file over a network and also have the ability to edit the app.config during installation or when the application is installed on another machine on the lan

    Semauel8515 pointsBadges:
  • Reading xml url into SQL Server 2008 Table with OpenXML

    I am parsing an xml file that contains an xml url and a text file url as values. OpenXML appears to be unable to read neither the xml url nor the url to the text file. It reads the urls to pdf and html locations fine. How can I get the process to get the xml url as text into my sql table.  My...

    Rscheinberg595 pointsBadges:
  • Problem with Visual Studio 2010 and SQL Server 2008.

    Hello friends! I am new here in this forum. I have a simple question. I am using Visual Studio 2010. But the SQL Server 2008 that comes with it does not have Management Studio with it. So I have installed SQL Server 2008 again seperately in my machine. Now I want to know how to attach SQL Server...

    Imraja25 pointsBadges:
  • Sql Server 2008R2 on Windows Sever 2008 R2

    When i attempt to install it tells me that my operating system is not supported, rule "Operating system supported edition" failed. however when i check the list of valid operating system it is listed, anyone had this issue before or know why i wont recognize, thank you

    Coopfirst5 pointsBadges:
  • Cost to upgrade to MS SQL Server 2008

    My company is implementing new features in our product line that will force customers to upgrade to SQL Server 2008. I can't make sense of MS's pricing for SQL Server upgrades any longer (i.e., it seems they've gone away from the notion of a SQL Server 'upgrade' license). Does anyone know a...

    Robcom8815 pointsBadges:
  • Is it possible to install SQL Server 2008 R2 on Windows 7 Home Basic 64 bit?

    Hi, Is it possible to install MS SQL Server 2008 R2 installation on Windows 7 Home Basic 64-BIT OS?

    Prateek5520 pointsBadges:
  • SQL Server 2008 R2 won’t install

    I receive the following error when installing SQL Server. I have installed .net 4.0 full x64 bit as some sites suggest but I can't get past the failure. The following error has occurred: An error occurred during the installation of assembly 'policy.8.0.microsoft.vc80.crt, version='8.0.50727.4027',...

    Grabber60 pointsBadges:
  • Read Excel from Sql Server 2005/2008 SQLEXPRESS

    How to read the excel data's from Sql Server 2005/2008 SQLEXPRESS

    Sridhar12350 pointsBadges:
  • how can make this SQL Server query faster

    All, how can I make this query faster? Here is my code of stored procedure: ALTER procedure [dbo].[GetLMPReport] ( @typeId tinyint, @dataType varchar(2), @date date ) AS begin select distinct p.name, ISNULL (td24.price, 0) as '00', ISNULL (td1.price, 0) as '100', ISNULL (td2.price, 0) as '200',...

    Singhal120 pointsBadges:
  • Looking for detailed synchronization logging in SQL Server 2008

    We are in the process of performing a side-by-side upgrade from SQL Server 2000 to 2008 (Standard Edition in both versions). A merge publication is included in the upgrade, and it appears to be working fine on the new server, so there is no functional issue. However, I have grown accustomed to the...

    SBatSI415 pointsBadges:
  • Link Tables in AS400 to SQL Server 2008

    Has anyone set up a link server to their AS400 from SQL Server 2008/5?

    Jaymz69765 pointsBadges:
  • Case sensitive variables in SQL Server 2008

    Our company is using SQL Server 2008 with several databases. We just want one database to be case sensitive to names of variable but we don't want the others this way. We want to change the settings so we can run the following script without errors:DECLARE @A int DECLARE @a intHow can you change...

    ITKE344,955 pointsBadges:
  • SQL Server 2008: INSERT statement

    One of my family members needs some help! He has a table in SQL Server 2008 with the attributes name and ID. The ID is a generated value like this: INSERT INTO table (name) VALUES('bob');Now, he's looking to get back the ID in the same step. How can he do this?

    ITKE344,955 pointsBadges:
  • Can you create an Active Directory users group in SQL Server 2008?

    I am trying to connect a .net application to SQL Server 2008 using windows authentication. However, I can’t get it to work right because there are a lot of Active Directory users. I Know I could create separate login account for each of the Active Directory users in SQL Server instead of having...

    Chris Leonard4,300 pointsBadges:
  • Notification change in SQL Server 2008

    Now, I have an application in SQL Server 2008 that consists of a database and several services. One of the services adds information to the database (which is triggered by a user).Another service queries the databases for changes and uses the new data for processing.I used a configurable timer that...

    ITKE344,955 pointsBadges:
  • What is the most efficient way to implement pagination in SQL Server 2008?

    I am trying to find the most efficient way to implement paging within SQL Server 2008, using ASP.NET MVC and LINQ. Should I use LINQ's Skip() and Take()or implement my own pagination with a SQL query?

    Chris Leonard4,300 pointsBadges:
  • Creating instance for SQL Server 2008 installation

    I've recently installed Visual Studio 2012 Professional and SQL Server 2008 SP1. My next move was to install SQL Management Studio x64 and I did get the option to set the instance name. I had several options including:Instance Feature Shared features 1. Management Tools-Basic 2. SQL Client...

    ITKE344,955 pointsBadges:
  • Convert string to Datetime in SQL Server 2008

    In SQL Server 2008, I have a string column in my table that displays data like this: "CXL P/D 08/15/13" Now, I'm trying to convert it to datetime but I can't understand how to extract only the date and change the data type. Could someone help me find the right statement?

    ITKE344,955 pointsBadges:
  • Who is using a database in SQL Server 2008?

    I’ve never seen this problem before. I went to change the name of a database in SQL Server 2008, but got hit with an error message saying that the db has to be exclusively locked to do this. So obviously someone else is using the database, but I don’t know who. We have a rather large...

    ITKE344,955 pointsBadges:
  • Exporting SQL Server 2005 database to SQL Server 2008

    This is more a basic question but is it possible to import (or migrate) SQL Server 2005 databases to SQL Server 2008? Or can I have 2005 and 2008 running on the same machine (without any complications)?

    ITKE344,955 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following