SQL Server Tag Directory

Featured SQL Server Questions

  • SQL database recovery from corrupt database file!

    Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few days ago I lost some part of my data due to accidental deletion. I backed it up, so I tried to restore the database from the .bkf file. The problem comes...

    chengchong365 pointsBadges:
  • How to repair backup of .mdf file database?

    One of our clients gets the following error when trying to backup a database:quote:________________________________________System.Data.SqlClient.SqlException: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x121db60d; actual: 0x521db60d). It occurred during...

    jordan26henderson5 pointsBadges:
  • BCP utility in SQL Server 2005

    Hi, how to send logins from server to another server using BCP utility?

    241219840 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:
  • 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:
  • Error message in the Copy Database Wizard in SQL Server 2005

    I am attempting to make a copy of a database using the Copy Database Wizard in SQL Server 2005, but I am receiving the following error: TITLE: Copy Database Wizard ------------------------------: The action you attempted to perform on a remote SQL Server instance failed because the action requires...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 ‘alter user’

    Hello, I have been trying to run the following instruction in QA use database_name alter user db_user_name with login = [domain\login_name] but keep getting the error Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'login'. I know this method exist in SQL Server 2005, are any of you able...

    Db23290 pointsBadges:
  • How to schedule SQL query to run in Microsoft SQL Server

    I have a query that I want to automatically schedule to run daily. How do I do this?

    House5 pointsBadges:
  • How to restore Sql Server 2000 mdf and ldf data

    I have MDF and LDF files with different modified dates. How could I attach these to SQL Server 2000

    Databaseserver20 pointsBadges:
  • encryting output file from BCP

    I am exporting data using BCP util, in SQL native format, creating an output format. The proces executes a stored procedure, creating a temporary table, and then the BCP exports the table to an output file, in native SQL. Is there a method to have this output file encrypted without a 3rd party...

    jswayne19645 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:
  • Automated Query iSQL

    I am very new to SQL and only have experience running my queries though iSQL Version 10 Build 3960 where I manually type (copy & paste) my queries. I would like to schedule a specific query to run at certain hours each day and then save the results to an excel or text file. Is this possible? How?

    Loveisalluneed325 pointsBadges:
  • Getting specific values from a SQL table to the ComboBox

    How do I get specific values from a SQL table to the ComboBox in the running mode?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Add an Active node to SQL Server Active Passive Cluster

    how will i add an active node to an existing Active/passive SQL Server 2005 Cluster. so that when any active node fails the passive will be used.will there be a down time for the current cluster Jasina

    Jasina30 pointsBadges:
  • Microsoft SQL Server BCP Utility password

    I am executing a Microsoft SQL Server Job that runs a BCP Utility.  The utility loads a table from a file using the 'in' argument, a format file and an error file.  I have 'hard coded' the user name and password in the command line using the 'U' and 'P' arguments. I am looking for a method...

    Redwine20 pointsBadges:
  • .mdf file backup in Visual Studio

    I developed one Visual Studio .Net(C#) Project.After Publishing I couldn't access Database(.mdf file). can yuo tell how to backup?

    Zamak5 pointsBadges:
  • Combo Box Selection Locks Form

    I have a combo box that locks/corrupts all of the controls on a Access 2003 form.  The locking symptom only seems to occur when the list index is greater than 0. The problem control may not be the combo box.  It may be one of two list boxes that are affected by the combo box's 'after update'...

    McNitro255 pointsBadges:
  • Using mdf file in website

    When you've developed e website with vis stud, including an aspnetdb.mdf file and a database file for the webcontent, how can you use these mdf files on the isp server where sqlserver 2005 is running? A normal connectionstring in the web,sonfig file gives an error about the attachdbfilename being a...

    Makoe5 pointsBadges:
  • dblookupcombobox has a null row

    Hello I'm Arnika. I have a question with dblookupcombobox. I have a program that hase a database I wrote.all things that I want it has,except when I open dblookupcombobox it must be have a row whit null value that when user wants to click nothing he can, but here there is'nt.

    Arnika5 pointsBadges:
  • Upgrade SQL 2005 Cluster to SQL 2008

    We have a remote sql 2005 server set we will be replacing with a Windows 2008 Cluster. The db supports a 3rd party app. The app has not completely endorsed for sql 2008. If I build an active/passive cluster with sql 2005 on Windows 2008, is there the ability to upgrade the sql server to a SQL 2008...

    tcstl95 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