SQL Server Management Studio Questions and Answers

Recent IT Questions

1 - 17 of 17
<<PREVIOUS 1 NEXT>>

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

View Answer   |  Jun 26 2009  4:44 PM GMT
SQL Server 2008, SQL managment Studio, Automated backup
asked by Phrathepmali

  30 pts.

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?

asked by Ssutton9

  10 pts.

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?

asked by Justadeveloper

  5 pts.

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

asked by Therockatmsu

  15 pts.

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

View Answer   |  Feb 7 2009  2:52 PM GMT
SQL Server 2008, SSMS 2008, SQL Server migration
asked by Tsp1965

  20 pts.

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!

asked by Sbkent2000

  5 pts.

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

View Answer   |  Dec 5 2008  8:21 PM GMT
SQL, SQL Server errors, SQL Server Management Studio
asked by Mmoreno

  5 pts.

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?

asked by SQL Server Ask the Experts

  2445 pts.

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

asked by Kambiz

  5 pts.

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.

asked by Hashki

  20 pts.

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

View Answer   |  Sep 29 2008  9:34 PM GMT
SQL Server errors, SQL Server Management Studio
asked by Bosco322

  25 pts.

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

View Answer   |  Sep 24 2008  0:37 AM GMT
SQL Express, SQL Server Management Studio
asked by Chukbillo

  20 pts.

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

View Answer   |  Aug 28 2008  12:12 AM GMT
SQL Express, Backup, SQL Server Management Studio
asked by Lissy

  5 pts.

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?

asked by Cjdechris

  5 pts.

schedule a restore plan

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

asked by DRE1

  25 pts.

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.

asked by DRE1

  25 pts.

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

View Answer   |  Apr 30 2008  7:12 PM GMT
SSIS, SSMS, SSIS Package
asked by Atif

  5 pts.

1 - 17 of 17
<<PREVIOUS 1 NEXT>>