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
| asked by
SQL Server Ask the Experts
SQL Server 2005, Enterprise Manager, User Interface
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
| asked by
Gini 2
SQL Server 2000, SQL Server backup, SQL Server 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?
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
| asked by
SQL Server Ask the Experts
SQL Server 2000, Enterprise Manager, Indexes
Scheduling a DTS Package
HiOn 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?ThanksP
View Answer
| May 13 2008 11:48 AM GMT
| asked by
Pmwhelan
DTS Package Scheduled Task, SQL Server Enterprise Manager, SQL Server
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
| asked by
SQL Server Ask the Experts
SQL Server, SQL Server security, MMC
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
| asked by
SQL Server Ask the Experts
SQL Server security, SQL Server Enterprise Manager
