SQL Server Enterprise Manager Questions and Answers

Recent IT Questions

1 - 14 of 14
<<PREVIOUS 1 NEXT>>

Enterprise Manager problem

Any nvarchar column content is shown as <binary> when using table browsing or view from enterprise manager in SQL Server 2000.

Answer Question   |  Jun 4 2009  12:37 AM GMT
SQL Server Enterprise Manager, SQL Server 2000
asked by Jadwiga

  10 pts.

SQL Server enterprise manager

how to register enterprise manager to connect to database

asked by Cslaybec

  5 pts.

Cannot connect to SQL Server via LAN

I try to add a new server registration using Enterprise Manager in a client machine to the SQL database in the server machine. I somehow keep getting 'Access denied' or registration failed. Then I can finally add the server registration after I open the shared folder at the server. Can anybody...

asked by MissBelle

  5 pts.

Shrinking a SQL Server database

My problem is regarding SQL Server 2000. Whenever I try to access SQL Server Enterprise Manager, I am told that the disk is full, along with the tempdb log. I tried to shrink the database, but for some reason I am not able to do so. Can you help me?

asked by SQL Server Ask the Experts

  2445 pts.

Installing SQL Server 2005 Enterprise Manager in Windows XP Pro

how to install SQL 2005 enterprise manager in XP professional.. When I am trying to install it, it is giving me IIS errors

asked by Advancedjava

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

Common User Interface SQL Serve Management Console

Does anyone know a way to standardize the SQL Serve Management Console so that all of the DBAs will see the same list of servers as we used to have in the SQL 2000 Enterprise Manager?

View Answer   |  Sep 12 2008  3:44 PM GMT
SQL Server 2000, DBA, SQL Server Enterprise Manager
asked by Jerry2

  5 pts.

How do you install SQL Server Enterprise Manager?

how can installed SQL Server Enterprise Manager,

asked by 08051982

  20 pts.

Looking for the user interface in SQL Server 2005 Developer Edition

I just installed SQL Server 2005 Developer Edition and I can’t find the user interface. I’m looking for the place I’d type queries as I did in SQL Server 2000 Enterprise Manager. Where can I find the UI?

View Answer   |  Jun 20 2008  3:28 PM GMT
UI, SQL Server 2005, Enterprise Manager
asked by SQL Server Ask the Experts

  2445 pts.

Restoring SQL Server 2000 database

I want to restore a database in SQL Server 2000, using a specific name. I tried restoring it using Enterprise Manager, but kept getting the error 'You must select a backup set to restore'. Why is this and how do I resolve it?

View Answer   |  Jun 5 2008  10:09 AM GMT
SQL Server 2000, SQL Server backup, SQL Server errors
asked by Gini 2

  5 pts.

Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?

Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?

View Answer   |  May 14 2008  3:24 AM GMT
SQL Server 2000, Data availability, Enterprise Manager
asked by SQL Server Ask the Experts

  2445 pts.

Scheduling a DTS Package

Hi On MS Windows Server 2003 I have a DTS Package in SQL Server Enterprise Manager. The DTS package runs fine in SQL Server Enterprise Manager. How do I add that DTS package as a scheduled task? Thanks P

View Answer   |  May 13 2008  11:48 AM GMT
SQL Server, DTS, SQL Server Enterprise Manager
asked by Pmwhelan

  5 pts.

Is firewall preventing SQL Server from showing up in the EM?

I have a corporate Dell Image laptop running SQL server 2000. Enterprise manager (EM) shows up without my registered SQL server (local or remote). When I try to re-register I see the other registered servers, however, they are grayed out. When I use the MMC Snap-In from computer management, I can...

View Answer   |  Mar 21 2008  8:45 PM GMT
SQL Server 2000, SQL Server, SQL Server security
asked by SQL Server Ask the Experts

  2445 pts.

How can I set the database password by the SQL Server Enterprise Manager?

How can I set the database password by the SQL Server Enterprise Manager?

View Answer   |  Mar 18 2008  11:51 PM GMT
SQL Server security, SQL Server Enterprise Manager
asked by SQL Server Ask the Experts

  2445 pts.

1 - 14 of 14
<<PREVIOUS 1 NEXT>>