• Having problems connecting to SQL Server 2008 remotely

    I am trying to connect to my database in Visual Studio 2010 using the named instance by 123.123.123.123/instanceNameBut, I get the following error message: error provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server I have the following aspects enabled: open Port...

    ITKE352,485 pointsBadges:
  • Pagination in different versions of SQL Server

    What's the best process (performance wise) to paginate results in different versions of SQL Server (2000, 2005, 2008 and 2012) if you also want to find the total number of results (before pagination)? Thanks!

    ITKE352,485 pointsBadges:
  • Cannot connect to SQL Server 2012

    I'm having trouble connecting to SQL Server 2012 database using C#. I get the following error message when I try to connect: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance...

    ITKE352,485 pointsBadges:
  • Stored Procedure code in SQL Management Studio

    I'm trying to find a way to step into a stored procedure code in SQL Management Studio (in SQL Server 2008). I've heard its possible with Visual Studio but I'm looking for a debugging solution for Management Studio.

    ITKE352,485 pointsBadges:
  • Using a table variable as input in a stored procedure

    Have just run into a problem. Currently our web service has been adding data to our SQL server 2008 tables by building a dynamic SQL INSERT command. It has started failing because of the data coming in. It contains a single quote in the name data ex. O' Brien. I am looking to pass the tables from...

    ToddN200015,605 pointsBadges:
  • Restore SQL Server 2000

    Our server crashed, I installed SQL 2000 on another server and would like to restore the databases from a backup copy. Please help.

    sfcharry5 pointsBadges:
  • Need to delete tons of records in SQL Server 2012?

    I have over 740 million records in a table and I need to delete all records with two field values. I can’t find a way to do it automatically and of course manual makes no sense at all. Is there any way I can do this?

    ITKE352,485 pointsBadges:
  • SQL Server 2008: Query for names

    Now in SQL Server 2008, is there a way that I can query for names in all tables that contain the column with name. Something along these lines:%myName%

    ITKE352,485 pointsBadges:
  • Insert data to DB2 database using VB and SQL stored procedure

    I have spent a few days trying to find a solution using Google. Has anyone had luck with this problem? Simply put we are trying to send data from our web service to our I-Series. We need to do this via a SQL stored procedure. When we do the insert dynamically it works as long as there are no single...

    ToddN200015,605 pointsBadges:
  • How to calculate previous row value?

    Here is the model I am using: Data: Date Hours Worked FullDay 9/4/2013 7:13:00 No 9/6/2013 10:52:00 Yes 9/7/2013 6:43:00 No 9/10/2013 9:26:00 Yes FullDay column to be updated as 'Yes' if previous day worked hours is at least 8 hours. How can I calculate whether or not the previous row value is...

    ITKE352,485 pointsBadges:
  • Administrator privileges in SQL Server 2008

    I recently installed SQL Server 2008 R2 onto my local machine. However, I can't create a new database because I'm getting the following message:CREATE DATABASE PERMISSION DENIEDAfter I saw that message, I tried to switch my administrator privileges but I received this:"User does not have permission...

    ITKE352,485 pointsBadges:
  • Does SQL Server 2014 backup to early versions of SQL Server?

    I’m looking to go up to SQL Server 2014 version and am testing a large database to handle it. Is there any way restore SQL Server 2014 backup in SQL Server 2008? I know it’s possible to restore SQL Server 2008 backup in SQL Server 2005, but was removed in 2012 to 2008. Has this been restored in...

    ITKE352,485 pointsBadges:
  • How to paginate and view results in SQL Server 2012?

    I’m trying to set pagination within SQL Server 2012 so that you can follow the total number of pages while adding data. Anyone know how to do that?

    ITKE352,485 pointsBadges:
  • Error message while trying to login to SQL Server 2008 R2

    I've been working on this for weeks now but I continue to get this error message when I'm trying to login in SQL Server 2008 R2. 80040ed4 Failed login for user 'myuser' Can anyone explain to me what this error message means and how I can solve it? Thanks!

    ITKE352,485 pointsBadges:
  • Having problems with THROW SQL Server 2008 R2

    I’m having issues in SQL Server 2008 R2 Management Studio where it does not recognize my throw as detailed below: incorrect syntax near Throw I am trying to set things up so that my website throws an error whenever someone enters the same value twice Begin Try insert into BusinessID (BusinessID)...

    ITKE352,485 pointsBadges:
  • Dynamic vs. Stored Procedure table inserts

    I just finished making some code changes to get around a problem. I changed my code from doing a dynamic insert to using a stored procedure. Originally it was 20 lines of code for the dynamic process. Doing it the stored procedure way, by the time you defined all the parms it was 107 lines of vb...

    ToddN200015,605 pointsBadges:
  • Stored procedure error in SQL Server 2008 R2

    I’m trying to change an existing stored procedure. I’m using the command: ALTER 'name_of_stored"procedure' When I do so, the name comes up with red highlighting, denoting that it is an invalid object. Although I am able to execute the command successfully, I want to know why SQL Server 2008 R2...

    ITKE352,485 pointsBadges:
  • Windows Forms and SQL Server 2008 database

    Now, I have created two different things: A local database and a Windows form. With the Windows form (In Server Explorer), I added the database's connection. How can I begin querying it using LING-to-SQL? Thanks!

    ITKE352,485 pointsBadges:
  • Need to generate automatic IDs for SRSS Reports

    I am running almost 75 SSRS reports. IS there a way to assign a unique ID to each report? Is there a way to leverage system generated information somewhere in the SQL Server 2012 databases rather than manually assigning each report an ID, for example using spreadsheet?

    ITKE352,485 pointsBadges:
  • Difference between nvarchar(max) and NText

    Now, I'm a beginner using SQL Server and I'm looking to learn more about the advantages / disadvantages between "nvarchar(max)" and "NText" data types. Now, I don't need to know backward compatibility so I already know that "nvarchar(max)" isn't supported by previous SQL Server releases.

    ITKE352,485 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