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

    ITKE352,470 pointsBadges:
  • How do I retrieve data from Visual Basic 6.0 with SQL?

    How can I retrieve data in VB 6.0 from SQL?

    Escabarte5 pointsBadges:
  • SQL code -727

    Does anyone know what -727 SQL return code is?

    Bebiii15 pointsBadges:
  • Matching key question in SQL Server

    Hi, Here is the problem I am trying to solve. I need to extract some information from a table, say Tab2, using a matching key from another table, say Tab1. Tab1 has two columns, Col1 and Col2. Col1 is digits (1, 2, 3...) Col2 has letters (AA, Aa, aA, aa, AB etc) I need to use Col2 to join to Tab2...

    Slowlearner25 pointsBadges:
  • P2V Windows XP SP3 SQL Server 2005 Express

    Hi all, can I do P2V with Windows XP SP3 and SQL Server 2005 Express? Is that is possible and how? I mean what kind of software if its doing cold or hot?

    Fulgen5 pointsBadges:
  • Re-linking SQL Server database user

    Hi Guys, What I am trying to do is relink a database user to a new domain user, and also keeping the same database user name. I am able to do this when I run the following command, and if the database user isn't the same as the login name. use temp alter user TestUser2 with name= TestUser2, login=...

    Db23290 pointsBadges:
  • Retrieving and adding data to tables on different SQL Servers

    Is it possible to retrieve data from two tables, located in two different SQL Servers in one domain, and then add the data and save the result in another table in a third SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Utility to Compare Security Configuration Between SQL Server 2005 Database

    We are trying to restore a SQL Server 2005 database from a production to a QA environment. We are using certificate security, multiple schemas and certificate signed stored procedures. We need to find a utility which can tell us security configuration differences between the two environments. Any...

    Aiguy5 pointsBadges:
  • When submitting a procedure via CL program, I do not get any abnormal end message.

    When submitting a procedure via CL program, I do not get any abnormal end message even though the procedure has not not completed normally, is there anyway by which we can find the cause of the failure of the completion of the procedure normally.

    JohnsonMumbai1,160 pointsBadges:
  • SQL Express used for SSIS?

    Can SQL Express be used for SSIS?

    Lianv10 pointsBadges:
  • SSRS interview questions and answers

    I'm looking for SSRS interview questions and answers. Can someone point me in the right direction?

    LouTermini5 pointsBadges:
  • Restore from .Bak file issue in SQL Server 2000

    First off thanks for reading, I am new to SQL (SQL Server 2000). Unfortunately I just had the array my Data was on and my tape backup get toasted, I was able to do some data recovery on the remaining drives and pull off about 15 different .bak files for the database I need to restore....

    selli285 pointsBadges:
  • T-SQL stored procedure conversion to C# CLR assembly

    I'm wondering why it is difficult to find an example (in literature or Internet) example of converting a T-SQL procedure which contains "out" variables into identical C# CLR stored procedure. Is there something which prohibits this conversion? If not, can someone provide or cite example? Real...

    Tann5 pointsBadges:
  • What wiki software do you recommend?

    Just as the title suggests, what wiki software (DokuWiki, MediaWiki, etc...) do you suggest to run?  The purpose of this is nothing more than to make a remote note-taking sort of scenario, so it's not something for anyone but me to be used.  I know I could do my own thing and stuff, but I'd...

    Eric Hansen2,065 pointsBadges:
  • SQL Report Help

    Hi I'm dave and I'm new to the forum, SQL and SSRS. Thanks in advance for your assistance and patience. I have a recall report that produces letters for every patient who needs to return to the office on a certain date based on their recall plan (a plan that determines when they should return based...

    Blowinup5 pointsBadges:
  • Migrating from SQL Server 2000 to SQL Server 2005 on DTS packages

    Could someone help me with a SQL Server 2000 migration to SQL Server 2005 on DTS packages? I have a Dynamics GP integration that uses the DTS package, but I don't know SQL or DTS packages well enough.

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL processor license

    On a physical server we select 2 processors. We then select SQL 2008 STD 1 socket license. since the server has 2 processors, can we assign SQL to only processor and run? If we can, can the second processor on the server be used by the OS on the server?

    Enterprises5 pointsBadges:
  • SQL Connection

    Using VB6 How can I build a connection code to connect to SQL DB

    Khl5 pointsBadges:
  • Adding files to TempDB

    Do I need to restart SQL Server 2005, if I have added additional files to the TempDB?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SAN configuration best practices for SQL Server using NetApp

    Good day all, Have recently purchased NetApp SAN to be implemented as our primary storage to host our database environment. As I'm not an expert in storage management wondering what would be the best practice / general rule of thumb in order to provide an optimal I/O performance towards our...

    blueivy5 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