• 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?

    ITKE351,965 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%

    ITKE351,965 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,080 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...

    ITKE351,965 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...

    ITKE351,965 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...

    ITKE351,965 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?

    ITKE351,965 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!

    ITKE351,965 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)...

    ITKE351,965 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,080 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...

    ITKE351,965 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!

    ITKE351,965 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?

    ITKE351,965 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.

    ITKE351,965 pointsBadges:
  • Auto-increment in SQL Server 2008 R2

    I've just created a new table in SQL Server 2008 R2 and I'm trying to get the index on auto-increment. Is there a way to do this?

    ITKE351,965 pointsBadges:
  • How to store TOP 2 variables in SQL Server 2008?

    How can I make it so that I can store the top 2 results in 2 variables?create table t(id int); insert into t (id) values (1),(2),(3),(4); declare @id1 int declare @id2 int select top 2 @id1 = first id, @id2 = next id from tIs there a way to make this happen in one query without using a loop?

    ITKE351,965 pointsBadges:
  • Items keep hanging in SQL Server Management Studio 2012

    When I'm using SQL Server Management Studio 2012, I'm clicking on the "Databases" node in Object Explorer but it just keeps loading items until it finally hangs. This is only happening when I'm connected to a remote server, not when I'm accessing it through my PC. Does anyone know what the problem...

    ITKE351,965 pointsBadges:
  • SSRS reports in SQL Server 2012?

    I’ve been working with SQL Server 2008 R2 in conjunction with Visual Studio 2008 and 2010. I just installed SQL Server 2012 and have SQL Server Data Tools running. Now I’m trying to create SSRS reports in SQL Server 2008 R2, but I can't find them in Programs. I realize that common advice is to...

    ITKE351,965 pointsBadges:
  • Trying to ID SSRS reports

    Our company currently has over 50 SSRS reports. We're trying to assign an unique ID to each report and we're wondering if there's a way to leverage system generated information in SQL Server 2012 databases rather than manually assigning each report one-by-one.

    ITKE351,965 pointsBadges:
  • Uninstall error using SQL Server 2012

    I just went ahead and uninstalled an instance from SQL Server 2012. However, when I tried to uninstall a second instance but I keep receiving an error message saying I don't meet the requirements. What's the problem here?

    ITKE351,965 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