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

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

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

    ITKE351,965 pointsBadges:
  • How to convert SQL Server 2008 R2 BPA output into CSV?

    I have been using SQL server 2018 R2 BPA for getting data from Microsoft. When using SQL Server 2005 to export results I could do so in a CSV format. When we upgraded two servers to Server 2008 I found that I could no longer run BPA 2005 on these. We then upgraded to 2008 R2, which again does not...

    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:
  • 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:
  • 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:
  • Detecting SQL Server 2008 R2 on Windows

    Now this may seem like a simple question, but I'm looking to detect SQL Server 2008 R2 on different versions of Windows. Here are the ways I've come up with: Via registry Via file system Via installer exit code Which way would be the easiest?

    ITKE351,965 pointsBadges:
  • Does SQL Server 2008 R2 Express have Intellisense?

    Is Intellisense available in SQL Server 2008 R2 Express Management Studio? It seems like it should be there. Is it inactive or am I doing something foolish?

    ITKE351,965 pointsBadges:
  • Server upgrade 2003 to 2008

    I'm upgrading my server hardware, I currently have server 2003. I also want to upgrade to server 2008 too. The new server I'm getting comes with its own new drives. How can I upgrade to a completely new server and upgrade to 2008, while retaining all of my data and Active Directory, etc.

    dthomas51865 pointsBadges:
  • mdm.udpValidateModel can be run twice with no side effect.

    I am new to MDS, client give me the mdm.udpValidateModel SP with @username etc. parameter. i don't know i parsed first time or executed. I again executed. will there will be any side effect . please guide me urgently. urgent. SET @User_ID = (SELECT ID FROM mdm.tblUser u WHERE u.UserName = @UserName...

    Manishkumar198010 pointsBadges:
  • Binary Math windows server 2008 sql server 2008 r2

    Operating System: Windows 2008 2 Database: SQL Server 2008 Enterprise R2 issue: I am trying to creat a binary matrix that manages user permissions. My largest number at present is 135069719 the binary representation is : 101001001110000101001 The largest number I eventually have to handle is a 20...

    m768535 pointsBadges:
  • File server

    I have a server 2008 R2 that while in Explorer on the left navigation pane show "Network" and under that a list of workgroup computers (it’s a file server) I have one computer in that network thats name is blue and underlined. Is there significance to this?

    Thenmen5 pointsBadges:
  • Scrip an select from linked Oracle database in Management studio gives multiply fields

    In SQL Server 2008 R2 Management studio under Linked servers I want to script a select from an Oracle database table. The result is that many of the fields occur three times. What can the reason for that be? See this example: SELECT [RATETYPE],[RATETYPE],[RATETYPE]            ...

    AnnaLena5 pointsBadges:
  • How do I create jobs using steps in SQL Server 2008 R2 Management Studio

    How do I create jobs using steps in SQL2008 r2 Management Studio? I am really having a problem with the syntax when using operating-system commands and transact-SQL commands. Examples would be great.

    Stingeree5 pointsBadges:
  • sys.conversation_endpoints build up

     It Seems that there is a lot of problems with SB cleanup? I have SQL 2008 r2 running on two different servers. The target system processes the millions of records in the queues but will not clean out the sys.conversation_endpoints, or the sys.conversation_endpoints tables. This is part of the...

    Shellz5 pointsBadges:
  • connecting to SQL server with mdf files

    What is the best way to connect a website on a VPS to sql server 2008 R2 express, using MDF files as databases. The VPS is running on server 2008 R2. I installed the same environment on the development computer. IIS gets a connection because it sees the users that are in the ASPNETDB.MDF file....

    Makoelaw5 pointsBadges:
  • Challenge improving query performance on large tables

    Hi, Here's the structure of the db I'm using: * Table frs_ArticlesBDFournisseur which contains article main data.One row per article/color. Key is Refrefart (int). Size is over 220000 rows at the momemt. Only index is the PK (clusterred). * Table frs_ArticlesBDFournisseurTaille contains all the...

    Sport200025 pointsBadges:
  • Error Message in SQL Server 2008 code.

    Hi, I am currently going through the Tutorials on SQL Server Management Studio 2008 R2. One of the samples instructs me to run the following code: SELECT  Mgr.EmployeeID AS MgrID, Mgr.LoginID AS Manager,  Emp.EmployeeID AS E_ID, Emp.LoginID, FROM EmployeeDemo AS Emp LEFT JOIN EmployeeDemo AS Mgr...

    JKJK45 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