• To get password fron SQL Server?

    How to get SQL server's login and password? Please: I know query for get it.

    AD2115 pointsBadges:
  • Cost to upgrade to MS SQL Server 2008

    My company is implementing new features in our product line that will force customers to upgrade to SQL Server 2008. I can't make sense of MS's pricing for SQL Server upgrades any longer (i.e., it seems they've gone away from the notion of a SQL Server 'upgrade' license). Does anyone know a...

    Robcom8815 pointsBadges:
  • Acquiring the AdventureWorks database for SQL Server 2005

    How can I get the AdventureWorks database for SQL Server 2005 SP1?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Don’t run the SQL Server Account as Local Administrator or member of the Administrator Group?

    Based on the advice "Don't run the SQL Server Account as Local Administrator or member of the Administrator Group" Will this setup prevented you from using critical features? How did you get around this? The link below makes reference as to how a critical feature "Automatic Server Restart Feature"...

    Aswad10 pointsBadges:
  • Installing SQL Server 2000 Enterprise Edition on Windows XP

    When I try to install SQL Server 2000 Enterprise Edition on Windows XP Professional Edition, it is giving me an error message that says my operating system is not supported. How can I install SQL Server 2000 Enterprise Edition on Windows XP Professional Edition?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Merging the MDF and NDF files of SQL Server databases

    How can i merge the MDF and NDF files of SQL Server databases?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Why can’t I connect to SQL Server 2005 through ODBC?

    Hello people, the situation is this: we have 2 computers, one is for local store (let's call it backend) and the other is a web server (let's call it frontend). Both are PCs running Windows Server 2003 SP2 and both have the SQL Server 2005 Enterprise Edition installed. The webserver is using IIS...

    MrGeorge65 pointsBadges:
  • Where can I download SQL Server 2005? All trials are no longer available.

    I desperately need to install SQL Server 2005 to learn it for a new job starting monday. Does anyone know where I can download a trial.

    Tresortx5 pointsBadges:
  • Problems installing SQL Server 2012

    I am having problems installing SQL Server 2012 on 64-bit windows 8. Here’s what I’ve tried: Click setup.exe and wait for the installation center to come up. Click "New SQL Server stand-alone installation" and then the Setup Support Rules page comes up. I click OKInput the product key and click...

    ITKE1,048,075 pointsBadges:
  • Access SQLServer remotely.

    Can somebody tell me how can I access the SQL Server instance which is running on a different network? I'm developing a website which should access the instance of sql server running on user's computer. The user can be on a different network. I'm not able to find a way to achieve this.

    ITKE1,048,075 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:
  • Storing images in SQL Server 2005 and retrieving them from VB.NET

    How can I store images in SQL Server 2005 and retrieve them from VB.NET?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Calling a stored procedure in a SELECT list on SQL Server 2000

    I am using SQL Server 2000, and my question is: is there any way to call a stored procedure in a SELECT list?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server Job Example using sp_start_job

    I need to use sp_start_job to schedule two jobs in SQL Server: the second job may run only if the first succeeds. Can you give me an example of a job running this store procedure to do this? Is there another method to do this in SQL Server? Thanks in advance!

    VINSALA25 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 to Modify SSIS packages created by Copy Database Wizard in SQL Server 2005

    Hello, I recently read Jeremy Kadlec great article titled, "Step-by-Step Guide: Migrating to SQL Server 2005 with Copy Database Wizard". Question for anyone: I used the wizard to copy 12 databases from ServerA to ServerB. However, I now want to set the order of those databases. Unfortunately, I...

    Pjunk5 pointsBadges:
  • Creating a user in SQL Server 2000

    How do I create a user in SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Bulk update in SQL Server 2005

    I need to update Column A1, Column A2 data in table A with Column B1, Column B2 data in table B for over 100,000 rows. How do I write a procedure to accomplish this in SQL Server 2005?

    Rl10 pointsBadges:
  • On Error Resume Next SQL Server 2005

    Is there to achieve On Error Resume Next? insert into table1 select top 1000 columnname from table2 It should continue inserting the next record even if there is an error. It should not stop the execution. It should simply skip the errors. Thanks in advance.

    Jsql155 pointsBadges:
  • How to restore a SQL Server 2000 database using a backup

    Could you please educate us on how to restore a database using a backup? We have a Mambilla PR software (.NET application) and SQL Server 2000 back end. We run the backup before any major change to the database.

    SQL Server Ask the Experts2,585 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.

Thanks! We'll email you when relevant content is added and updated.

Following