We are running SQL Server 2000 on Windows 2000 Server SP4, and our SQL Restore takes at least 10 minutes to launch in Enterprise Manager. We had to roll back after an upgrade, and we find that when selecting "Restore Database", Enterprise Manager runs remarkably slow. I'm sure we could run the...
On SQL Server 2000, how can I make it so that the server will prompt me for a password when I am click on my database through Enterprise Manager?
whenever i use enterprise manager to perform backup or other functions on my laptops it usually requests for host credentials.whenever i give it my operating systems credentials it gives me an error message.what could be the problem?Nothing can be done with the enterprise manager without using the...
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?
Hi everybody, I'm an IT student and i'm doing professional practices. A simple project was assigned to me. This company uses SMS to collect information of all his PC's and stores this information in a MSSQL database. A manager checks this information and fills another database located in another...
Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?
Hello, I am new SQL server DBA. I can create a new user. The request came in also ask for the password. Is there anyone can help me on how to set password to a user in in Enterprised Manager in SQL server 2000? Thanks,


