• Can’t bring master database back online

    hi,i bring master database into offline. after that i tryed so many times to make master database as online.But i did't get that one into online(production side)wht is root cause for that?

    241219840 pointsBadges:
  • What is the best way to replicate SQL 2008 DBs to a failover site?

    We are looking to replicate our SQL 2008 databases to a hot failover site.  We can't use DB mirroring due to the number of databases we have.  Has anyone replicated databases to a hot site using a replication solution and what was your experience.

    DaveMPA55 pointsBadges:
  • Delete all tables in SQL Server database?

    How to delete all tables of a database in SQL Server?

    Prcvjr220 pointsBadges:
  • Using Excel 2010 to pull data from SQL Server?

    How can I use excel 2010 to pull data from my sql server? I have an odbc connection set up and need data from a specific table in a specific database. I want excel to do some projections and calculations.

    NewnanIT1,110 pointsBadges:
  • Rolling back a SQL server 2005 database.

    We need to roll back a copy of our database 5 hours. We are running sql 2005 on a windows 2003 server. How can we do this? We do not want to effect production data but want to report against the 5 hour old data.

    Karl Gechlik9,860 pointsBadges:
  • How to find Windows Operating system values for SQL database: OSId, Descr, Edition, ver, arch,

    I'm managing a large group of virtual machines using SysCenter Virtual Machine manager (SCVMM). I want to add data to the SQL Database for SCVMM application so that additional operating systems will be available in the properties of the SCVMM application. I know how to do the statements which add...

    007jet5 pointsBadges:
  • Help navigating SQL Server 2008 database?

    Hi all, I'm facing an interesting challenge... Lets say: I have a payment coming in and of course my client has not specified which of the 45 open invoices he is paying. The amount does not match any single invoice so it has to be a combined payment for 2 or more invoices. Now, I can get my...

    Palloquin95 pointsBadges:
  • How to display values in one table by referring and checking values in another table?

    how to display values in one table by refering and checking values in another table

    Sqldb5 pointsBadges:
  • sql 2008 export to txt for backup and incremental backup

    Hi i have one db that i want to back up, so thought id export to txt file/flat file then back that up and then daily increments into that file? cant find the steps to do it..have the wizard..

    Jordaan5 pointsBadges:
  • Mirroring SQL Server 2008 to a disaster recovery machine twice a day

    I want to mirror my SQL Server 2008 to a disaster recovery machine two times a day. Is there any free software to do this on a running SQL Server? If not, are there any cheap alternatives? Can scripts be run to copy the files over while SQL is running? Can I use shadow copy for this?

    ITKE346,060 pointsBadges:
  • SQL To Excel Data Dumping with the help of SSIS flow task.

    I am trying to do a Sql To Excel Data Dumping with the help of ssis flow task.I create a sql connection and give the query in the sql source.I aslo have a excel template to map in excel destination ready which has around 400 columns/fields.In bettween i use a dataconvrsion for unicode/non unicode...

    Ssis5 pointsBadges:
  • Best way to back up SQL Server 2008 database?

    What's the best way to back up my SQL Server 2008 database? We are currently backing up the SQL data files during off hours but soon we'll be going 24/7 and we'll need to use maintenance plans and shadow copy. Can someone provide help?

    ITKE346,060 pointsBadges:
  • Connecting to the SQL- SERVER from VS-2008 C#

    How can I connect to the SQL SERVER from the VS-08 C# and how can I insert, modify and view the database in SQL SERVER.

    Rajeshu135 pointsBadges:
  • Linking users of Access 2003 to SQL Server 2008 database

    We plan to go to SQL Server 2008. We need to link our Microsoft Access 2003 users to the databases created in SQL Server 2008. Will we be able to do this considering ODBCAD32 is what we use, and the databases we create will now be 64-bit?

    Mike8005 pointsBadges:
  • Import data file into SQL database

    I need to import tis .dat file into sql database table having four column client-007092~WITCO clname-CORPORATION ,matter-0005,mattername-LAZY OIL V. WITCO

    Anamika8315 pointsBadges:
  • SQL server 2000 sp3 database remote access

    hi i want to access a sql server 2000 sp3 database in remote system where no sql server 2000 is installed. can anyone help me for this?

    Itdonsavi30 pointsBadges:
  • SQL Server user name issue

    We have a server in which Windows 2003 is installed and we have created users in the domain (e.g. - aaa). The server is installed with SQL Server 2000 and data is stored in the database. The user name for the server is “administrator.” When we login from the user computer with the same name and...

    SQL Server Ask the Experts2,585 pointsBadges:
  • DB mirroring with SQL Server 2005: Standard vs. Enterprise

    On the subject of database mirroring in SQL Server 2005… Besides snapshot access and high safety mode having to be on, as well as the redo thread count, are there any other limitations placed on mirroring, utilizing Standard edition vs. Enterprise edition? I was under the assumption that to allow...

    SQL Server Ask the Experts2,585 pointsBadges:
  • MS DNS query logging to sql server?

    Does anybody know if it is possible using 2003 server r2 dns to log querys to a sql server database instead of a file?

    Ryan99795 pointsBadges:
  • Merging MDF files on SQL databases after restoring from a backup

    I recently restored our SQL Server database from a backup, but unfortunately I used a Wednesday backup instead of Thursday, and it is now Friday. Is there a way to merge MDF files, to join all the data together because, as of now, we are missing Thursday’s data.

    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.

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