Default installation to named one

Hi,
I have installed sql server on one of my box as a named installation and now
I want to change it to default one without re-installing sql server.
Please suggest how should I go for it. Also, whether it is possible or not.
Thanks in advance
Manu JaidkaHello,
You will have to install a default instance and copy the databases including
system databases over to default instance
using Backup and restore or detach and Attach.
Thanks
Hari
"manu" <manu@.discussions.microsoft.com> wrote in message
news:7A299083-671F-4457-B9CE-263AE17838C0@.microsoft.com...
> Hi,
> I have installed sql server on one of my box as a named installation and
> now
> I want to change it to default one without re-installing sql server.
> Please suggest how should I go for it. Also, whether it is possible or
> not.
> Thanks in advance
> Manu Jaidka
>

Default installation to named one

Hi,
I have installed sql server on one of my box as a named installation and now
I want to change it to default one without re-installing sql server.
Please suggest how should I go for it. Also, whether it is possible or not.
Thanks in advance
Manu Jaidka
Hello,
You will have to install a default instance and copy the databases including
system databases over to default instance
using Backup and restore or detach and Attach.
Thanks
Hari
"manu" <manu@.discussions.microsoft.com> wrote in message
news:7A299083-671F-4457-B9CE-263AE17838C0@.microsoft.com...
> Hi,
> I have installed sql server on one of my box as a named installation and
> now
> I want to change it to default one without re-installing sql server.
> Please suggest how should I go for it. Also, whether it is possible or
> not.
> Thanks in advance
> Manu Jaidka
>

Default installation to named one

Hi,
I have installed sql server on one of my box as a named installation and now
I want to change it to default one without re-installing sql server.
Please suggest how should I go for it. Also, whether it is possible or not.
Thanks in advance
Manu JaidkaHello,
You will have to install a default instance and copy the databases including
system databases over to default instance
using Backup and restore or detach and Attach.
Thanks
Hari
"manu" <manu@.discussions.microsoft.com> wrote in message
news:7A299083-671F-4457-B9CE-263AE17838C0@.microsoft.com...
> Hi,
> I have installed sql server on one of my box as a named installation and
> now
> I want to change it to default one without re-installing sql server.
> Please suggest how should I go for it. Also, whether it is possible or
> not.
> Thanks in advance
> Manu Jaidka
>

Debugging Triggers

I was wondering if it is possible to pop up a dialog box from a SQL trigger.

This would be a great way to debug triggers as you could report variable values in the dialog box.

If not, does anybody have any suggestions as to the best way of reporting out variable values whilst a trigger is running?Sometimes I will feed values and sql strings into a table, sometimes I will use profiler with all of the XXXcompleted events turned on for th Transact-SQL and stored prpcedures classes.|||Install the stored procedure debugging package from the MS-SQL CD? I haven't used it in a while, but it lets you set breakpoints, watches, etc. very much like Visual Studio.

-PatP

Debugging my sprock

From this msg im guessing that SQLE.DLL nee to be installed on my SQLServer box, is that correct? Where would i find this dll?

Server: Msg 508, Level 16, State 1, Procedure sp_sdidebug, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to debugger on APOLLO-ClintonSQL (Error = 0x800401f3). Ensure that client-side components, such as SQLLE.DLL, are installed and registered on PUR-CO-Clinton2. Debugging disabled for connection 59.Start here (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_servtools_5cfm.asp).

-PatP