map drive

If my computer has a map drive, i want to delete it, how to do it? Is that right if i right click the map drive and click the disconnect?Yes, that should allow you to disconnect the mapped drive.

-PatP|||From a command prompt you can also run

net use z: /del

(replace z: with the mapped drive letter)|||From a command prompt you can also run

net use z: /del

(replace z: with the mapped drive letter)

well if we are in the sql server forum, how about

exec xp_cmdshell 'net use x: /delete'

Manual Starting SQL Server ... delay...

When I start the SQL Server by command prompt for single user mode it is
taking lots of time(15 minutes) to start the SQL Server. My computer is a
slow system but it is not very bad slow computer.
IS it a resonable time or not?
SQL 2K.
Thanks,
Smith
Therefore you should look in the SQLServer logs,how much time the databases
need to come up,on every start the database are checked while opened if any
inconsictencys exsists. If so,the database is "repaired" (open transactions
are rolled back,etc.). The betteryou leave the system duringthe shutdown the
faster it gets up on a restart.
SQL Server logs can be found in the Control node of SQL Server -- Current
Log.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Arora Smith" <Arora_Smith@.hotmail.com> schrieb im Newsbeitrag
news:%233MaZErfFHA.460@.TK2MSFTNGP09.phx.gbl...
> When I start the SQL Server by command prompt for single user mode it is
> taking lots of time(15 minutes) to start the SQL Server. My computer is a
> slow system but it is not very bad slow computer.
> IS it a resonable time or not?
> SQL 2K.
> Thanks,
> Smith
>
>

Manual Starting SQL Server ... delay...

When I start the SQL Server by command prompt for single user mode it is
taking lots of time(15 minutes) to start the SQL Server. My computer is a
slow system but it is not very bad slow computer.
IS it a resonable time or not?
SQL 2K.
Thanks,
SmithTherefore you should look in the SQLServer logs,how much time the databases
need to come up,on every start the database are checked while opened if any
inconsictencys exsists. If so,the database is "repaired" (open transactions
are rolled back,etc.). The betteryou leave the system duringthe shutdown the
faster it gets up on a restart.
SQL Server logs can be found in the Control node of SQL Server -- Current
Log.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Arora Smith" <Arora_Smith@.hotmail.com> schrieb im Newsbeitrag
news:%233MaZErfFHA.460@.TK2MSFTNGP09.phx.gbl...
> When I start the SQL Server by command prompt for single user mode it is
> taking lots of time(15 minutes) to start the SQL Server. My computer is a
> slow system but it is not very bad slow computer.
> IS it a resonable time or not?
> SQL 2K.
> Thanks,
> Smith
>
>

Manual Starting SQL Server ... delay...

When I start the SQL Server by command prompt for single user mode it is
taking lots of time(15 minutes) to start the SQL Server. My computer is a
slow system but it is not very bad slow computer.
IS it a resonable time or not?
SQL 2K.
Thanks,
SmithTherefore you should look in the SQLServer logs,how much time the databases
need to come up,on every start the database are checked while opened if any
inconsictencys exsists. If so,the database is "repaired" (open transactions
are rolled back,etc.). The betteryou leave the system duringthe shutdown the
faster it gets up on a restart.
SQL Server logs can be found in the Control node of SQL Server -- Current
Log.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Arora Smith" <Arora_Smith@.hotmail.com> schrieb im Newsbeitrag
news:%233MaZErfFHA.460@.TK2MSFTNGP09.phx.gbl...
> When I start the SQL Server by command prompt for single user mode it is
> taking lots of time(15 minutes) to start the SQL Server. My computer is a
> slow system but it is not very bad slow computer.
> IS it a resonable time or not?
> SQL 2K.
> Thanks,
> Smith
>
>

Manual Configuration - Installation

I have installed Reporting Services on a computer running Windows Server 2000
with SP4. At the end of the installation it told me it could not
automatically configure/start reporting services and that it needed to be
done. The only thing I can find in the readme file is in regards to
permissions dor IWAM on a domain controller, however this server is not a
domain controller. When I go to the page for ReportManager I get an access
denied and the ReportingServices page has a page cannot be displayed error.
Any help is greatly appreciated.
Thanks,
IanI have made it past that error but now I am getting: The Report Server Web
service has not generated a public key. The service may have not have
started successfully. Check the log files for more information.
I have done everything here:
http://www.sqlreportingservices.net/Ask/354.aspx with no luck thus far.
Please help.
Ian
"Ian T. Jones" wrote:
> I have installed Reporting Services on a computer running Windows Server 2000
> with SP4. At the end of the installation it told me it could not
> automatically configure/start reporting services and that it needed to be
> done. The only thing I can find in the readme file is in regards to
> permissions dor IWAM on a domain controller, however this server is not a
> domain controller. When I go to the page for ReportManager I get an access
> denied and the ReportingServices page has a page cannot be displayed error.
> Any help is greatly appreciated.
> Thanks,
> Ian

Management Tools in SQL SERVER 2005

Hi Team,

Is there any management tools in SQL SERVER 2005? I just installed my standard edition and also developer version in different computer, but seems that both versions doesn't support management tools such as query analyzer.

Can anyone explain to me...

Thanks.

Copy both to your harddrive and rerun setup and choose the repair option and when you get to select components choose Management tools the new Enterprise Manager is called Management Studio and install it in both. Then right click at the top of Management Studio to register the Standard Edition with the Developer Edition because it is the Enterprise Edition with no deployment restriction. Hope this helps.

|||

Thanks Caddre,

I found it.