• SQL error. There is already an object named ‘InitCap2’ in the database.

    I am running the following code in Microsoft SQL Server Management Studio Express, and after I run it, I get the following error, even though it is returning the record set that I am looking for. I would like to get rid of this error. Thanks. The error is: Msg 2714, Level 16, State 5, Procedure...

    Mmoreno5 pointsBadges:
  • Moving a database from SQL Server 2000 to SQL Server 2005 and back again

    I moved my database from SQL Server 2000 to SQL Server 2005, but now, if possible, I'd like to move it back. When I open SQL Server Management Studio 2005 and check my database's properties, its compatibility is "SQL Server 2000(8.0)". Can I move my database back to SQL Server 2000, and if so, how?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Exception from HRESULT: 0x80040104 (System.Windows.Forms)

    Program Location: at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous) at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args) at...

    Kambiz5 pointsBadges:
  • Deleting a Row

    I have been tring to remove this one row, but cannot. I keep getting this error. Microsoft SQL ServerManagement Studio No Rows were deleted A problem occurred attempting to delete Row 1. Error Service: netSQLClient Data Provider. Error Message string or binary date would be truncated. The statement...

    Bosco32225 pointsBadges:
  • SQL server – Management Studio tool

    Hi, Thanks for your help, But on SQL Server (SQLEXPRESS) it prompts for only account name and password but no IP so I still can login to my clients server to access thier database. Please how do it. Thanks Chuk

    Chukbillo20 pointsBadges:
  • Backup/Restore a DB from Microsoft SQL Enterprise Manager to SQL Server Management Studio Express

    Hi Is it possible to copy a DB from a server that has a genuin SQL Enterprise Manager to a server that has SQL Server Management Studio Express installed? Both servers are on the same net. I get following error when trying: Restore failed for Server 'PROGTST\SQLEXPRESS'....

    Lissy5 pointsBadges:
  • unable to attach sample database in SQL 2005

    Hi, I installed SQL server 2000 and SQL 2000 SP4. Than I installed SQL Server 2005. But when I am trying to attach the AdventureWorks Sample database, I am getting the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ An error occurred when attaching the...

    Ismav5 pointsBadges:
  • how to upgrade server to SQL 2005

    I have a system with MS SQL Server 2005 installed and am running the MS SQL Server Management Studio Express but when I query the database version it comes back as SQL 2000 - 8.00.194. How do it change to using SQL 2005?

    Cjdechris5 pointsBadges:
  • schedule a restore plan

    using sql 2005, management studio,, how to schedule a daily database and restore plan.

    DRE125 pointsBadges:
  • How do my database sql2005 database to another server with management studio

    Has sql 2005, using management studio to do a full backup of my database. Using maintenance wizard to set the backup. I only see my local drive and not my share folder created onthe other server where i want to place the .bak file. Any idea will be helpfull.

    DRE125 pointsBadges:
  • having problem with SSIS package

    i have created the SSIS package from sql server Server management and its work fine but the problem I’m having, when I try to run it from SQL Server Management jobs. Every time when train it from Sql jobs it failed. Please advice on ….

    Atif5 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.