I wrote a small stored proc for job monitoring.

This is usefull when you are not present in office (specially weekends) and you want to know whether all jobs run...

I always wanted category namme to be customised. Didn't knew that EM has got option to manage Categories.

Good one.

1. NET STOP is a Windows OS command & not a TSQL command. so you have to run it from a command prompt or bacth file.

2. ADO can shutdown SQL...

infact,

MS EM allows you to see and copy and save the script that EM will execute in order to do the change.

just click on 3rd icon on toolbar of...

yes, both this ways exists !!

net stop MSSQLServer

and

objSQLServer.Shutdown ( TRUE ) -- for normal shutdown

objSQLServer.Shutdown ( FALSE ) -- for immediate shutdown

I did the same,& found it working well.

also make sure that SQL service Account has access to the paths / files specified.

sp_attach_db N'test' , N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\test_Data.MDF', N'c:\Program...

BOL says

If you attach a database to a server other than the server from which the database was detached, and the detached database was enabled for replication, you should run...

I am also currently in a process of creating some scripts for Multi-server Admin. Although I manage only 6 servers now, the number will soon increase.

This are some of ideas...

SQL Resource Kit 2000 has got a tool called Bulk Image Insert (BII). Use that.

I actually haave used a command line dialer program called AutoDial.

I used it to connect & disconnect to /from internet within a DOS BATCH file.

see if it supports VPN...

Before attempting any of this solutions below make sure you have done following

shutdown server , copy ur mdf to some other location (as a backup) & also have a master...

I have checked SQL Agent Log. It says "[353] Mail session started (using MAPI1)".

so The mapi profile does not seem to be an issue.

may be u can simplify your plan by ommiting installation instructions, by creating setup settings files ( *.iss ) refer to BOL or setup disks for this.

small correction

Update TELESCRP

set xpriority = 99, xcallback = NULL

from TELESCRP , TESTSQLVW , DONTDIAL.dbo.DontDial,

where

TELESCRP.XTELELINK = TESTSQLVW.XTELELINK

and

DONTDIAL.dbo.DontDial.Phone

in ( TESTSQLVW.phone, TESTSQLVW.phone1, TESTSQLVW.phone2, TESTSQLVW.phone21, TESTSQLVW.phone3...

Try this

Update TELESCRP

set xpriority = 99, xcallback = NULL

from TELESCRP , TESTSQLVW , DONTDIAL.dbo.DontDial,

where

TELESCRP.XTELELINK = TESTSQLVW.XTELELINK

and

DONTDIAL.dbo.DontDial.Phone

in ( phone, phone1, phone2, phone21, phone3...