• Recovering a deleted database in SQL Server 2005

    I've accidentally deleted a database on SQL Server 2005, and I do not have a backup. Is there any way to recover it?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Problem with Visual Studio 2010 and SQL Server 2008.

    Hello friends! I am new here in this forum. I have a simple question. I am using Visual Studio 2010. But the SQL Server 2008 that comes with it does not have Management Studio with it. So I have installed SQL Server 2008 again seperately in my machine. Now I want to know how to attach SQL Server...

    Imraja25 pointsBadges:
  • SQL Server 2000 backup failed

    can not backup a 2000 db, dbcc checkdb ok. see following: Errorlog: 2008-01-08 09:54:40.69 spid62 Starting up database 'CP2005'. 2008-01-08 09:54:41.00 backup BACKUP failed to complete the command BACKUP DATABASE [education] TO DISK = N'C:\fjs1\education_db_200801080954.BAK' WITH INIT , NOUNLOAD ,...

    Fjsittler5 pointsBadges:
  • Hardware requirements for SQL Server 2005

    Hi all, We are looking into creating a SQL 2005 server (Windows 2003 R2 SP2 Enterprise Ed.) with 3 databases. Size of the db 's will be app. 50 GB, 15 GB and 7 GB. Amount of continuous logged on users is app 20. Can anyone recommend the amount of CPU + clockspeed of the CPU's, RAM memory and...

    Arne5 pointsBadges:
  • Sql Server 2008R2 on Windows Sever 2008 R2

    When i attempt to install it tells me that my operating system is not supported, rule "Operating system supported edition" failed. however when i check the list of valid operating system it is listed, anyone had this issue before or know why i wont recognize, thank you

    Coopfirst5 pointsBadges:
  • Lacking a FQDN during database mirroring on SQL Server 2005

    I am trying to work with database mirroring on SQL Server 2005, and I keep receiving the error message, “One or more of the server network addresses lacks a fully qualified domain name (FQDN). Specify the FQDN for each server, and click Start Mirroring again.” I know that the syntax for a...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Explaining triggers in SQL Server 2005

    Can you explain to me the syntaxes of triggers used in SQL Server 2005? Could you also give me a simple example of a trigger?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Retrieving data from SQL server 2005 using VB6? VB6??

    How to create an application in VB6 that can retrive data from microsoft SQL Server2005.Is that possible.Thank you.

    Royal5 pointsBadges:
  • How can I save a picture to the SQL Server database and retrieve it using VB.Net 2005?

    How can I save a picture to the SQL Server database and retrieve it using VB.Net 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Exporting stored procedure results into an XML file in SQL Server

    I need to export the result from a stored procedure into an XML file directly in SQL Server. How would I go about doing this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Lagging Microsoft SQL Express Server 2005

    Hi, I have Microsoft SQL Server 2005 Express Edition with SP3, SP4, on Syperemicro Server, Intel Xeon E3-1220 v2 3.10GHz,8GB RAM and OS Microsoft Server 2008. We use Windows 7 desktop clients machine with enough CPU and RAM and arcgis software who is sync with MSSEE. But works very slowly. I am...

    mICROSOFT1235 pointsBadges:
  • naming column returned from FOR XML EXPLICIT query in SQL Server 2005

    Is there a way to name the column returned from a query that includes a for xml explicit? I get a column named XML_F52E2B61-18A1-11d1-B105-00805F49916B. I'd like to name it something more appropriate for ORM software The code I currently have is: Declare @RoleIDs table (RoleID int) insert into...

    Cramhead15 pointsBadges:
  • Installing SQL Server 2000 on Microsoft Windows XP

    I am attempting to install SQL Server 2000 on Microsoft Windows XP, but I keep receiving this error message: “Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system." What steps can I take to get rid of this message?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Incremental backup in SQL server 2005 and SQL Server 2005 express

    Question: a) steps to backup the daily incremental in sql server 2005. b) steps to backup the daily incremental in sql server 2005 express.

    david2009575 pointsBadges:
  • Finding a table’s name from a trigger name in SQL Server

    How can I find the related table's name from just a trigger name?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Improving performance on a large SQL Server database

    We have a very huge SQL Server database, with approximately 700GB of data. Due to this, queries are running very slow. Could you please suggest few tips to improve performance?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Advantages of SQL Server 2005 over SQL Server 2000

    What are the benefits of upgrading to SQL Server 2005 from SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • export sql server 2005 to dbf

    I have problem with exporting a table to a dbf format file in sql server 2005 Has anyone done it before? Thanks!

    Ellie145 pointsBadges:
  • How to create table using a subquery in SQL Server

    Hi everybody, Everyone knows that a table can be created using a subquery in oracle. How to do the same task in SQL Server. In Oracle I tried as "create table table1 as select * from table2" My requirement is to create dynamic tables in stored procedure based on existing tables. I'm so desperate, I...

    Carbuncle0 pointsBadges:
  • To get password fron SQL Server?

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

    AD2115 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