BTW, is anyone interested in a script to disconnect the databases that are 30 days old? If you're like me, you try to keep every log you ever generated. The bad news is that this behavior will eventually choke your ISA. Needless to say, I have a script that, run daily (scheduled task), will prevent this behavior (although it limits your log queries to 30 days in the past). Jim Harrison MCP(NT4, W2K), A+, Network+, PCG http://isaserver.org/Jim_Harrison/ http://isatools.org Read the help / books / articles! -----Original Message----- From: Jim Harrison [mailto:Jim@xxxxxxxxxxxx] Sent: Wednesday, December 22, 2004 10:24 PM To: [ISAserver.org Discussion List] Subject: [isalist] RE: MSDE http://www.ISAserver.org Your ISA-local-only osql connection is thus (typed exactly): osql -E -S%ComputerName%\msfw It only accepts secure login (SSPI) and you have to specify the server\instance as above. After that, you should be jes' fine, jes' fine. Jim Harrison MCP(NT4, W2K), A+, Network+, PCG http://isaserver.org/Jim_Harrison/ http://isatools.org Read the help / books / articles! -----Original Message----- From: josephk [mailto:josephk@xxxxxxxxx] Sent: Wednesday, December 22, 2004 1:05 PM To: [ISAserver.org Discussion List] Subject: [isalist] MSDE http://www.ISAserver.org Hi Jim, How come the T-SQL command sp_attach_db with appropriate stuff won't allow attachment to the db? I've been working on some utilities to extract the information I need and I'm unable to attach. What I can do is shut down the services on my ISA box and then copy the Db's and look At them one at a time. And what is the default SQLDB name(instance) MSSQL$MSFW? Thank you, Joseph ------------------------------------------------------ List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ ------------------------------------------------------ Other Internet Software Marketing Sites: World of Windows Networking: http://www.windowsnetworking.com Leading Network Software Directory: http://www.serverfiles.com No.1 Exchange Server Resource Site: http://www.msexchange.org Windows Security Resource Site: http://www.windowsecurity.com/ Network Security Library: http://www.secinf.net/ Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com ------------------------------------------------------ You are currently subscribed to this ISAserver.org Discussion List as: jim@xxxxxxxxxxxx To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=isalist Report abuse to listadmin@xxxxxxxxxxxxx All mail to and from this domain is GFI-scanned. ------------------------------------------------------ List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ ------------------------------------------------------ Other Internet Software Marketing Sites: World of Windows Networking: http://www.windowsnetworking.com Leading Network Software Directory: http://www.serverfiles.com No.1 Exchange Server Resource Site: http://www.msexchange.org Windows Security Resource Site: http://www.windowsecurity.com/ Network Security Library: http://www.secinf.net/ Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com ------------------------------------------------------ You are currently subscribed to this ISAserver.org Discussion List as: jim@xxxxxxxxxxxx To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=isalist Report abuse to listadmin@xxxxxxxxxxxxx All mail to and from this domain is GFI-scanned.