• Having trouble connecting Windows Server 2008 R2 to SQL Server 2008 R2

    I've reinstalled Windows Server 2008 R2 on my machine. After that I installed SQL Server 2008 R2 without a problem but I'm having issues when I try to connect with Microsoft SQL Management Studio via my Windows Administration account. Any idea why I can't connect? Thanks!

    ITKE345,085 pointsBadges:
  • Row by Row Stored Procedure in SQL Server 2008 R2

    Hi all, Hopefully someone will be able to help me here - I'm nearly there but can't get it right, I'm trying to create a stored procedure that when it runs, it will do a query and then send send an email out for each of the rows that it returns. e.g. If I have a DB with 4 columns (ID, Days,...

    Turdywills65 pointsBadges:
  • SQL Server 2008 SSIS Update Command Performance Issue

    Hello, In SQL Server 2008 R2, I have created an SSIS package to pull from an ODS and feed a Data Mart. To build the OLAP cube, I am using identity keys as the primary keys to the tables. TableA has 4,000,000 rows and I am updating each row with a foreign key from TableB with 500,000 rows using a...

    Sflatbush60 pointsBadges:
  • Performance benchmarks for SQL Server 2008 R2

    Have performance benchmarks for SQL Server 2008 R2 been published somewhere?

    ITKE345,085 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:
  • 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:
  • How do I convert SQL Server 2012 files to SQL Azure?

    Currently, I’m running SQL Server 2012 with Visual Studio Beta 11 as well as SQL Server 2008 R2 version of the .mdf file because the staging server uses R2. I’ll be moving up to SQL Azure for a project I’m working on. What is the best way to port files over? Do I actually need to make changes...

    ITKE345,085 pointsBadges:
  • SQL Server 2008 R2: User table with clustered indexes

    I recently found that a couple of my tables in SQL Server 2008 R2 with no clustered indexes defined. However, there are non-clustered indexes defined (so basically they're on HEAP). After I did some searching, I learned that some select statements were using a filter on the columns defined (in...

    ITKE345,085 pointsBadges:
  • Uninstalling SQL Server 2008 R2 manually

    When I'm using my Windows 7 Ultimate x64, I honestly can't do anything with the existing instance of my SQL Server 2008 R2. I made the mistake of uninstalling some requirements related to SQL Server before running the main uninstaller.It seems like the uninstaller is doing its job (it's saying all...

    ITKE345,085 pointsBadges:
  • Query database sizes in SQL Server 2008 R2

    I'm using SQL Server 2008 R2 that has over 500 databases. What would be the easiest and most efficient way to query databases of all sizes. The output should have the following columns:DatabaseNameDataFilesSizeLogFilesSizeThanks for all the help!

    ITKE345,085 pointsBadges:
  • How to transfer SSIS Tasks from 2008 R2 to 2012

    I am about to switch from SQL Server 2008 P2 to SQl Server 2012. I use a number of custom SSIS Tasks on 2008 R2 and I’d like to know if it’s possible to transfer them to 2012; and of course if it is possible, how to do it. I tried just opening my DTSX packages in Visual Studio 2010 but they...

    ITKE345,085 pointsBadges:
  • Should I use SQL Server 2008 R2 or Postgre 9?

    I'm rewriting an application for my company which requires a database. I will be updating the database using SQL Server 2008 R2. Now, here's my big question: Should I use PostgreSQL 9?Note: I won't be doing any conversions so that's not a problem.

    ITKE345,085 pointsBadges:
  • Having problems with remote access: SQL Server 2008 R2

    I have configured my server with a static IP and installed SQL Server 2008 R2 with ITAPP. The following happens when I use the IP to access SQL Server: Client Machine: sqlcmd -S XXX.XXX.XXX.XXX -U sa -P mypass A successful connection! But when I use: sqlcmd -S XXX.XXX.XXX.XXX\ITAPP -U sa -P mypass...

    ITKE345,085 pointsBadges:
  • Receiving error message connecting to SQL Server 2008 R2

    I'm trying to connect to SQL Server 2008 R2 using Windows authentication. However, I can't because I keep getting this error:Login failed for user 'AVATOPIA\ian'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]Now, I can log in...

    ITKE345,085 pointsBadges:
  • Intellisense isn’t working in SQL Server 2008 R2

    We just got a new machine but everything was already installed on it, including SQL Server 2008 R2 and Visual Studio 2010 SP1. However, I don't have any intellisense in SQL Server Management Studio (aka it's not working). What should I do?

    ITKE345,085 pointsBadges:
  • Remote Call issues in SQL Server 2008 R2

    I’m having problems connecting to my database remotely in SQL Server 2008 R2. I get the following error. 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 name is correct...

    ITKE345,085 pointsBadges:
  • How to create a table variable in SQL Server 2008 R2?

    How can I create a table variable (virtual in-memory table) with columns that match the stored procedure resultset? I tried to execute the procedure using column names I specified. Does the data type of the columns need to be the same as the stored procedure? Here is what I tried:DECLARE @Table...

    ITKE345,085 pointsBadges:
  • Creating a trigger in SQL Server 2008 R2

    I have three tables in SQL Server 2008 and they all have the PK-FK-FK-relationship. 1st table: I have a column name with the name as "STATUS" that contains the value "active" or "inactive". 2nd table: I have the column with the name FKNEWLoanReviewfieldid, which has multiple values 3rd table: The...

    ITKE345,085 pointsBadges:
  • Upgrading to SQL Server 2008 R2

    This might be a simple question but I have SQL Server 2008 in my machine and I'm looking to upgrade to SQL Server 2008 R2. What's the easiest way possible to do it? Any documentation would be great.Thank you!

    ITKE345,085 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