msde sp4

Why can't I execute sp_attach/sp_detach in MSDE? It said it didn't have
those 2 store procedures.
.~. Might, Courage, Vision. http://www.linux-sxs.org
/ v \
/( _ )\ Linux 2.4.31
^ ^ 8:33pm up 4:06 0 users 1.06 0.75Hi
Maybe because you are using the wrong names?
Try
execute master.dbo.sp_attach_db
execute master.dbo.sp_detach_db
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"man-wai chang" <toylet.toylet@.gmail.com> wrote in message
news:e0SpEyMoFHA.2580@.TK2MSFTNGP09.phx.gbl...
> Why can't I execute sp_attach/sp_detach in MSDE? It said it didn't have
> those 2 store procedures.
> --
> .~. Might, Courage, Vision. http://www.linux-sxs.org
> / v \
> /( _ )\ Linux 2.4.31
> ^ ^ 8:33pm up 4:06 0 users 1.06 0.75|||man-wai chang wrote:
> Why can't I execute sp_attach/sp_detach in MSDE? It said it didn't have
> those 2 store procedures.
>
sorry... I forgot. It should be sp_attach_db..
.~. Might, Courage, Vision. http://www.linux-sxs.org
/ v \
/( _ )\ Linux 2.4.31
^ ^ 8:43pm up 4:16 0 users 0.63 0.63|||
> Maybe because you are using the wrong names?
> Try
> execute master.dbo.sp_attach_db
> execute master.dbo.sp_detach_db
yes.. sorry. :)
.~. Might, Courage, Vision. http://www.linux-sxs.org
/ v \
/( _ )\ Linux 2.4.31
^ ^ 8:49pm up 4:22 0 users 0.52 0.58