• Software to automate backups for SQL Server 2008 databases

    I am running SQL Server 2008 and I know how to create backups of this data manually using SQL managment studio but we are looking for a way to automate the process. Does anyone know of a product that can be utilized to do this? Or a way the managment studio can be set up to do this? It's not...

    Phrathepmali30 pointsBadges:
  • Creating instance for SQL Server 2008 installation

    I've recently installed Visual Studio 2012 Professional and SQL Server 2008 SP1. My next move was to install SQL Management Studio x64 and I did get the option to set the instance name. I had several options including:Instance Feature Shared features 1. Management Tools-Basic 2. SQL Client...

    ITKE342,195 pointsBadges:
  • Items keep hanging in SQL Server Management Studio 2012

    When I'm using SQL Server Management Studio 2012, I'm clicking on the "Databases" node in Object Explorer but it just keeps loading items until it finally hangs. This is only happening when I'm connected to a remote server, not when I'm accessing it through my PC. Does anyone know what the problem...

    ITKE342,195 pointsBadges:
  • SQL Server Management Studio Restrict Access

    Is there anyway to add restrictions to the Object Explorer in SQL Server Management Studio to prevent Table objects being expanded? And is this something that can be added to the sa account or would I need to add a new account for this?

    Darraca290 pointsBadges:
  • SQL Server Management Studio Express 2005

    I have installed Studio Express on my system but I am not able to start with it. I am not able to connect to the server. Error-40 and Error-26 is coming.What is the procedure to connect?

    Sweetu20 pointsBadges:
  • How do I create jobs using steps in SQL Server 2008 R2 Management Studio

    How do I create jobs using steps in SQL2008 r2 Management Studio? I am really having a problem with the syntax when using operating-system commands and transact-SQL commands. Examples would be great.

    Stingeree5 pointsBadges:
  • Error Message in SQL Server 2008 code.

    Hi, I am currently going through the Tutorials on SQL Server Management Studio 2008 R2. One of the samples instructs me to run the following code: SELECT  Mgr.EmployeeID AS MgrID, Mgr.LoginID AS Manager,  Emp.EmployeeID AS E_ID, Emp.LoginID, FROM EmployeeDemo AS Emp LEFT JOIN EmployeeDemo AS Mgr...

    JKJK45 pointsBadges:
  • Select Value question in SSMS

    I am trying to select "log_comment" field with the max("stamp_date") field from "action_log" table where "field_index" field ='1007' I am getting more than just the row with the maximum stamp_date. Can someone please tell me what I'm doing wrong? Field_Index    Stamp_Date   Log_Comment...

    Sadams115 pointsBadges:
  • sql server 2005 local connection

    I have installed sql server 2005 in local machine and I am trying to connect to that locally. but it is not working. I tried both istalling as default and also by naming as instance. sql server configuration manager shows the services running but I can not connect to in management studio.

    Hashki20 pointsBadges:
  • SQL Server Management Studio

    SQL Server management studio will no longer run on my client PC. It ran fine for about 12 months, but now warns with: Evaluation Period has expired..... I am only running the mgmt piece only. How do I get this ability back on my pc?

    Ssutton910 pointsBadges:
  • Developer Access to Sql2005 Management studio

    In sqlserver 2005, many tools were integrated into the management studio. How do you limit access to portions of the manaagement studio, such as only allowing devleopers access to the query analyzer, while allowing Administrators full access to all tools?

    Justadeveloper5 pointsBadges:
  • Can’t create ODBC connection to sql 2005 instance

    I have a server 2003 two node cluster with SQL 2005 installed. The orginal instance is working fine and there is no connection problem. I have created a second instance and can connect with the SQL Management Studio. When i try to create a ODBC connection from my client os both XP and VISTA both...

    Therockatmsu15 pointsBadges:
  • Copying view from remote to local SQL Server with SSMS

    Hi I'm currently trying to get to grips with an upgrade from sql server 2000 to 2008, forced by an upgrade at my ISP. I'm used to using Enterprise Manager to export data from my ISP to my local machine for backup, and this process copying tables as tables, views as views and so on. But using Export...

    Tsp196520 pointsBadges:
  • eMail SQL Server Logs

    I'm new to SQL Server Management Studio...... Is it possible to set it up to eMail Server Logs to myself? Thanks!

    Sbkent20005 pointsBadges:
  • 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: 0×80040104 (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:

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