SQL Server Tag Directory

Featured SQL Server Questions

  • How to extract key phrases from a log file using a batch file.

    How can I  extract key phrases from a log file using a batch file.  I am new to this. I need to know how to extract key phrases from a log file using a batch file. I need to create the batch file first to extract the phrases from the log file.  I don't need to pull the whole log file.  Just...

    Stretch2160 pointsBadges:
  • Restore SQL Server 2000

    Our server crashed, I installed SQL 2000 on another server and would like to restore the databases from a backup copy. Please help.

    sfcharry5 pointsBadges:
  • Backup and Restore different SQL Server 2012 Editions

    Does anyone know if it is possible to backup a database on a SQL Server 2012 Enterprise Edition and restore it to a SQL Server 2012 Business Intelligence Edition using SQL Server Management Studio? I would like to go the other way as well.

    TLMercer45 pointsBadges:
  • Forget SQL Server Password?

    Last week, I have forgotten SQL Server password and I am not able to get any solution from anywhere. It’s very important for me. Please give me such software that helps me to reset or recover SQL password. Thanks in advance!

    ClientsQuery10 pointsBadges:
  • hyper-threading technology

    What are the examples of processor architectures that have hyper-threading technology?

    okellomorris15 pointsBadges:
  • Restore SharePoint 2003 database/s on SQL Server 2005

    I am not sure if this should be addressed by the SQL Server group or SharePoint Server group. Since I am more familiar with SQL Server than SharePoint I started here. We have SharePoint Server 2003 installed on Windows 2003 server running SQL Server 2005. We have been backing up daily, two of the...

    TLMercer45 pointsBadges:
  • SQLRPGLE Cursors and Recursion

    I'm trying to recursively call a PI in my SQLRPGLE program. Problem is, I get an SQLCODE error of -519 and I'm sure it has to do with cursors and the prepare statement in my PI. Here's the code: pprintPrograms    b      dprintPrograms    PI      d...

    Dcantwell470 pointsBadges:
  • SSRS authentication in workgroup environment

    Can a workgroup be configured to authenticate to reporting services to run reports? If so, could someone please assist me in this security setup as we are currently experiencing difficulty. Our Windows 7 "server" authenticates fine but none of the current client computers are able. Thank you.

    ConFlicker210 pointsBadges:
  • SQL Server 2008 restore error

    error message : The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server....

    Kazem10 pointsBadges:
  • Backing up and restoring images to Windows Server 2003

    How can I backup images and restore images to my Windows Server 2003?

    NewnanIT1,110 pointsBadges:
  • Rolling back Windows Server 2003 in bulk to a restore point

    We need to roll back 23 Windows Server 2003 to a restore point. Can this be automated?

    TeachMeIT975 pointsBadges:
  • Running a disk check on Windows 2000 Pro

    When running a disk check on a Windows 2000 professional computer it creates files in the root of the C: drive. What are these files and can they be used to restore data?

    NewnanIT1,110 pointsBadges:
  • Restoring LTO3 tape without the app that backed it up

    Is it possible to restore data on a LTO3 tape without the application (ArcServe2000) that backed it up?

    NewnanIT1,110 pointsBadges:
  • Microsoft Sequel Server 2005 VSS backup

    What's seems to have happened is that the SQLVDI.dll files in the 2 directories: C:\Program Files (x86)\Microsoft SQL Server\80\COM C:\Program Files\Microsoft SQL Server\80\COM are out of sync. This seems to have happened as a result of a service pack for MSSQL which was applied in Dev. The...

    LeonT140 pointsBadges:
  • SQL Server 2005 Reporting Services Move

    I am trying to move an entire report server to a different server. When I move the databases and config files all of my shared data sources do not have a connection string and credentials in them. How can I move SSRS data sources with connections strings and credentials to another server?

    Rick Martinez585 pointsBadges:
  • Recursion in Visual Studio 2010

    I'm running Microsoft Visual Studio 2010 Professional on a Windows 7 laptop and trying to learn C#. I'm working on recursion and want to prompt the user to enter a specific word into a console application and then use a recusive method to print each character of the user-supplied word on a separate...

    QMac10 pointsBadges:
  • GDG restoration from tape backup

    hi, can anyone please tell me iwant to restore generation which is multi-volume (G0001V00) from tape on dasd with renameu option.and i have tried with first creation with base gdg nad without base also. i m getting this error(G0001V00 IS A MULTIVOLUME DATA SET ).can anyone share the jcl. I m trying...

    Djainpune5 pointsBadges:
  • T-SQL with Recursion – Display top ID on all levels below (To: Kent Milligan)

    Hell Kent, I read through "V5R4 SQL Packs a Punch" http://www-03.ibm.com/systems/resources/systems_i_software_db2_pdf_rcte_olap.pdf    I would need the query in figure 20 and the result in figure 21 which do not show up in the article.  I have a query similar to the example (parts of an iSeries...

    Cavallino30 pointsBadges:
  • Infinite recursion in SQL Server 2000

    consider a recursive query in SQL.How to handle infinite recursion to make the query evaluation optimized?

    Gomsbk35 pointsBadges:
  • Connect to remote SQL server from MySQL

    we have read only access to a remote sql server. the requirement is to read few tables from sql server and load to mysql tables (installed on Unix box). Please suggest the possible ways of achieving this.

    Nitibansal5 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