Change licensing mode

Hello

Can someone tell me which is the quickest method to change the licensing mode after RS has been installed (per seat -> per processor)

Many thanks!

Worf

Well apparently you can't. The only way you can is by reinstalling RS.

Regards,

Worf

sql

change license mode on SQL 2k cluster

I need to change the SQL server license mode on an installed SQL server
2000 cluster from processor license to per seat.
Does anyonw know?
http://support.microsoft.com/default...b;en-us;870617
http://www.tkdinesh.com/faq/ans/license.html
Simon

change license mode on SQL 2k cluster

I need to change the SQL server license mode on an installed SQL server
2000 cluster from processor license to per seat.

Does anyonw know?http://support.microsoft.com/defaul...kb;en-us;870617
http://www.tkdinesh.com/faq/ans/license.html

Simon

change instance name?

Is it easy to rename an instance, or change an instance to default instance?
Basically I have an SQL 2000 Standard and MSDE installed on same machine,
and I would like to swap around their instances.
Thanks
cj
No, you cannot rename an instance or change default to named or vice versa. Backup, (re)install and
restore is what you have to do. some links that might be useful:
Have a look at this list compiled by Andrew Kelly:
Moving DB's between Servers
http://www.support.microsoft.com/?id=314546
Moving SQL Server Databases to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=224071
Using WITH MOVE in a Restore
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map logins to users
http://www.dbmaint.com/SyncSql Logins.asp
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
Restoring a .mdf
http://www.sqlservercentral.com/scri...p?scriptid=599
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"wcccj" <NOSPAMcjohnson@.wccREMOVE.qld.edu.au> wrote in message
news:eTFhRmIKGHA.3408@.TK2MSFTNGP12.phx.gbl...
> Is it easy to rename an instance, or change an instance to default instance?
> Basically I have an SQL 2000 Standard and MSDE installed on same machine,
> and I would like to swap around their instances.
> Thanks
> cj
>
>
>
|||AFAIK, you can not change instance name, you have to install new
instance and dettach dbs from old instance and attach them to new
instance.
Also you can not change named instance to default instance.
look at
http://vyaskn.tripod.com/administration_faq.htm#q13
Regards
Amish Shah.
|||Ok, that's what I thought :-(
BTW thanks for the list, it is a helpful resource!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Oh3zzoJKGHA.500@.TK2MSFTNGP15.phx.gbl...
> No, you cannot rename an instance or change default to named or vice
> versa. Backup, (re)install and restore is what you have to do. some links
> that might be useful:
> Have a look at this list compiled by Andrew Kelly:
> Moving DB's between Servers
> http://www.support.microsoft.com/?id=314546
> Moving SQL Server Databases to a New Location with Detach/Attach
> http://www.support.microsoft.com/?id=224071
> Using WITH MOVE in a Restore
> http://support.microsoft.com/?id=221465
> How To Transfer Logins and Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=246133
> Mapping Logins & SIDs after a Restore
> http://www.support.microsoft.com/?id=298897
> Utility to map logins to users
> http://www.dbmaint.com/SyncSql Logins.asp
> User Logon and/or Permission Errors After Restoring Dump
> http://www.support.microsoft.com/?id=168001
> How to Resolve Permission Issues When a Database Is Moved Between SQL
> Servers
> http://www.support.microsoft.com/?id=240872
> Restoring a .mdf
> http://www.sqlservercentral.com/scri...p?scriptid=599
> Disaster Recovery Articles for SQL Server
> http://www.support.microsoft.com/?id=307775
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "wcccj" <NOSPAMcjohnson@.wccREMOVE.qld.edu.au> wrote in message
> news:eTFhRmIKGHA.3408@.TK2MSFTNGP12.phx.gbl...
>

change instance name?

Is it easy to rename an instance, or change an instance to default instance?
Basically I have an SQL 2000 Standard and MSDE installed on same machine,
and I would like to swap around their instances.
Thanks
cjNo, you cannot rename an instance or change default to named or vice versa.
Backup, (re)install and
restore is what you have to do. some links that might be useful:
Have a look at this list compiled by Andrew Kelly:
Moving DB's between Servers
http://www.support.microsoft.com/?id=314546
Moving SQL Server Databases to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=224071
Using WITH MOVE in a Restore
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map logins to users
http://www.dbmaint.com/SyncSql Logins.asp
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
Restoring a .mdf
http://www.sqlservercentral.com/scr...sp?scriptid=599
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"wcccj" <NOSPAMcjohnson@.wccREMOVE.qld.edu.au> wrote in message
news:eTFhRmIKGHA.3408@.TK2MSFTNGP12.phx.gbl...
> Is it easy to rename an instance, or change an instance to default instanc
e?
> Basically I have an SQL 2000 Standard and MSDE installed on same machine,
> and I would like to swap around their instances.
> Thanks
> cj
>
>
>|||AFAIK, you can not change instance name, you have to install new
instance and dettach dbs from old instance and attach them to new
instance.
Also you can not change named instance to default instance.
look at
http://vyaskn.tripod.com/administration_faq.htm#q13
Regards
Amish Shah.|||Ok, that's what I thought :-(
BTW thanks for the list, it is a helpful resource!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Oh3zzoJKGHA.500@.TK2MSFTNGP15.phx.gbl...
> No, you cannot rename an instance or change default to named or vice
> versa. Backup, (re)install and restore is what you have to do. some links
> that might be useful:
> Have a look at this list compiled by Andrew Kelly:
> Moving DB's between Servers
> http://www.support.microsoft.com/?id=314546
> Moving SQL Server Databases to a New Location with Detach/Attach
> http://www.support.microsoft.com/?id=224071
> Using WITH MOVE in a Restore
> http://support.microsoft.com/?id=221465
> How To Transfer Logins and Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=246133
> Mapping Logins & SIDs after a Restore
> http://www.support.microsoft.com/?id=298897
> Utility to map logins to users
> http://www.dbmaint.com/SyncSql Logins.asp
> User Logon and/or Permission Errors After Restoring Dump
> http://www.support.microsoft.com/?id=168001
> How to Resolve Permission Issues When a Database Is Moved Between SQL
> Servers
> http://www.support.microsoft.com/?id=240872
> Restoring a .mdf
> http://www.sqlservercentral.com/scr...sp?scriptid=599
> Disaster Recovery Articles for SQL Server
> http://www.support.microsoft.com/?id=307775
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "wcccj" <NOSPAMcjohnson@.wccREMOVE.qld.edu.au> wrote in message
> news:eTFhRmIKGHA.3408@.TK2MSFTNGP12.phx.gbl...
>

change instance name?

Is it easy to rename an instance, or change an instance to default instance?
Basically I have an SQL 2000 Standard and MSDE installed on same machine,
and I would like to swap around their instances.
Thanks
cjNo, you cannot rename an instance or change default to named or vice versa. Backup, (re)install and
restore is what you have to do. some links that might be useful:
Have a look at this list compiled by Andrew Kelly:
Moving DB's between Servers
http://www.support.microsoft.com/?id=314546
Moving SQL Server Databases to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=224071
Using WITH MOVE in a Restore
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map logins to users
http://www.dbmaint.com/SyncSql Logins.asp
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
Restoring a .mdf
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"wcccj" <NOSPAMcjohnson@.wccREMOVE.qld.edu.au> wrote in message
news:eTFhRmIKGHA.3408@.TK2MSFTNGP12.phx.gbl...
> Is it easy to rename an instance, or change an instance to default instance?
> Basically I have an SQL 2000 Standard and MSDE installed on same machine,
> and I would like to swap around their instances.
> Thanks
> cj
>
>
>|||AFAIK, you can not change instance name, you have to install new
instance and dettach dbs from old instance and attach them to new
instance.
Also you can not change named instance to default instance.
look at
http://vyaskn.tripod.com/administration_faq.htm#q13
Regards
Amish Shah.|||Ok, that's what I thought :-(
BTW thanks for the list, it is a helpful resource!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Oh3zzoJKGHA.500@.TK2MSFTNGP15.phx.gbl...
> No, you cannot rename an instance or change default to named or vice
> versa. Backup, (re)install and restore is what you have to do. some links
> that might be useful:
> Have a look at this list compiled by Andrew Kelly:
> Moving DB's between Servers
> http://www.support.microsoft.com/?id=314546
> Moving SQL Server Databases to a New Location with Detach/Attach
> http://www.support.microsoft.com/?id=224071
> Using WITH MOVE in a Restore
> http://support.microsoft.com/?id=221465
> How To Transfer Logins and Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=246133
> Mapping Logins & SIDs after a Restore
> http://www.support.microsoft.com/?id=298897
> Utility to map logins to users
> http://www.dbmaint.com/SyncSql Logins.asp
> User Logon and/or Permission Errors After Restoring Dump
> http://www.support.microsoft.com/?id=168001
> How to Resolve Permission Issues When a Database Is Moved Between SQL
> Servers
> http://www.support.microsoft.com/?id=240872
> Restoring a .mdf
> http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
> Disaster Recovery Articles for SQL Server
> http://www.support.microsoft.com/?id=307775
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "wcccj" <NOSPAMcjohnson@.wccREMOVE.qld.edu.au> wrote in message
> news:eTFhRmIKGHA.3408@.TK2MSFTNGP12.phx.gbl...
>> Is it easy to rename an instance, or change an instance to default
>> instance?
>> Basically I have an SQL 2000 Standard and MSDE installed on same machine,
>> and I would like to swap around their instances.
>> Thanks
>> cj
>>
>>
>

Change in MHTML rendering in SP1?

Greetings.
I recently installed SP1, and am having some trouble with my Custom Delivery
Extension.
My extension renders to MHTML, converts the resulting stream to a
CDO.Message, then manipulates the resulting object. After installing SP1, I
get an exception during this process.
I also noticed that after installing SP1, my report snapshots have gone from
about 55K to 15K.
Has the MHTML rendering changed between RTM and SP1? Is there any
documentation for how it's changed?
Regards, Jonathan
http://kerblog.com/earlyedition/archive/2004/12/09/258.aspxHi Jonathan,
What's the exactly exception you encounter? Have you installed Reporting
Services Services Pack 1 successfully? Even the size the snapshot seems go
down, does the snapshot looks exactly as you expected?
Based on my knowledge, there is only one issue about rendering mhtml fixed
in SP1, see the following knowledge base articles below and no other
changes in rendering were made.
FIX: Bookmark links in a report that is rendered to the Web archive file
format (.mhtml) may not work correctly
http://support.microsoft.com/kb/842534
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Michael,
Thanks for your quick reply.
"Michael Cheng [MSFT]" wrote:
> What's the exactly exception you encounter?
After I Render the report, I convert it to a CDO.Message and then try to
open the body using CDO.IBodyPart.GetDecodedContentStream(). The exception
is basically a COMException.
> Have you installed Reporting
> Services Services Pack 1 successfully?
Yes.
> Even the size the snapshot seems go
> down, does the snapshot looks exactly as you expected?
Yes, it looks fine.
Reporting Services RTM used to render MHTML into a "text/html" type message
if there were no graphics in the report. It looks to me like SP1 now always
renders as "multipart/related." I'm able to traverse the "multipart/related"
message to find the "text/html" part.
No problem, but it would have been nice to document. I only found out after
the change broke my delivery extension.
Regards,
Jonathan
http://kerblog.com/earlyedition/archive/2004/12/09/260.aspx|||Hi Jonathan,
I will try to find somebody from development team to see whether he knows
the answer and there is any documents about this available. I will keep you
updated.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||HI Jonathan,
It seems the snapshot size (in the report server catalog) has decreased,
because they are compressed in SP1 (unless snapshot compression is turned
off). However, I am not sure why SP1 always renders as "multipart/related"
as you said and no relative documents.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Change Drive Letter

With reference to my previous posting, it seems that there
may be some misunderstanding.
We have installed a SQL Server 2000 database on the J
drive. However, we would like to rename the J drive to E
drive (Asked by the Network Administrator).
We would like to know is it necessary for us to do
anything for the change of drive letter ? Is it necessary
for us to detach and attach the database when he changes
the drive name? OR Just change the file location of the
database from J to E in EM?
Thanks
Renaming drive letters is really ugly. If you just rename the drive
letter then SQL Server probably wont even start because it will be
looking for the master database primary data file on the wrong drive
letter (which will no longer exist). This can be changed in the
registry but there are a myriad of other problems you will encounter.
It may be best just to detach all you user DBs, uninstall SQL Server,
rename the drive letters, reinstall SQL Server and reattach your user
DBs again (now located on the renamed drive letter). If you'd already
done a fair bit of server config you may want to backup your master,
model & msdb (and potentially distribution DB if configured as a
distributor participating in SQL replication) databases before
uninstalling SQL Server and then restore them after reinstalling.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Jason wrote:

>With reference to my previous posting, it seems that there
>may be some misunderstanding.
>We have installed a SQL Server 2000 database on the J
>drive. However, we would like to rename the J drive to E
>drive (Asked by the Network Administrator).
>We would like to know is it necessary for us to do
>anything for the change of drive letter ? Is it necessary
>for us to detach and attach the database when he changes
>the drive name? OR Just change the file location of the
>database from J to E in EM?
>Thanks
>
>
|||Actually, this is not as dramati as Mike depicted, but backing up before
doing anything else is always a good idea. Check this article for details:
http://www.support.microsoft.com/kb/224071/EN-US/
"Mike Hodgson" wrote:

> Renaming drive letters is really ugly. If you just rename the drive
> letter then SQL Server probably wont even start because it will be
> looking for the master database primary data file on the wrong drive
> letter (which will no longer exist). This can be changed in the
> registry but there are a myriad of other problems you will encounter.
> It may be best just to detach all you user DBs, uninstall SQL Server,
> rename the drive letters, reinstall SQL Server and reattach your user
> DBs again (now located on the renamed drive letter). If you'd already
> done a fair bit of server config you may want to backup your master,
> model & msdb (and potentially distribution DB if configured as a
> distributor participating in SQL replication) databases before
> uninstalling SQL Server and then restore them after reinstalling.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
>
> Jason wrote:
>
|||That KB article is assuming the binaries directory is not moving too. I
may have misread/misunderstood the OP. I was basing the
uninstall/reinstall suggestion on the presumption that the whole SQL
installation was on the disk to be renamed (binaries, data files, log
files, tempdb, the works). I agree that if the binaries are staying
where they are (eg. on C:\Program Files\...) the you can move DBs
without the need to uninstall/reinstall and if the system DBs (master,
msdb & model) don't need to move then the process is virtually painless
with a simple detach/attach process.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
rdjabarov wrote:
[vbcol=seagreen]
>Actually, this is not as dramati as Mike depicted, but backing up before
>doing anything else is always a good idea. Check this article for details:
>http://www.support.microsoft.com/kb/224071/EN-US/
>"Mike Hodgson" wrote:
>

Change Drive Letter

We have installed a SQL Server 2000 database on the J
drive. However, we would like to change the drive letter
to E.
We would like to know what steps we should do in order to
move the database from J to E drive ? Is it necessary for
us to detach and attach the database ? OR Just change the
file location of the database from J to E in EM?
Thanks
You would need to detatch the database, move the files and then re-attach
the files to bring the DB back online. When re-attaching the files however
you will be able to browse for the .MDF file. If there are any subsequent
files such as .NDF or .LDF you *may* need to search for them separatly.
When detatching a database if you have any full text searches enabled on the
DB, these will need to be re-established once the database is re-attached.
This can be done by right clicking on the table with the full text index and
then proceeding to 'edit' the index.
Hope this helps.
Anubis.
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:018701c5707c$2f643880$a601280a@.phx.gbl...
> We have installed a SQL Server 2000 database on the J
> drive. However, we would like to change the drive letter
> to E.
> We would like to know what steps we should do in order to
> move the database from J to E drive ? Is it necessary for
> us to detach and attach the database ? OR Just change the
> file location of the database from J to E in EM?
> Thanks
|||If it's just a single DB you're talking about, detach/attach would be
the best way. I'd strongly advise *against* hacking the system tables
to change the driver letter in sysfiles.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Jason wrote:

>We have installed a SQL Server 2000 database on the J
>drive. However, we would like to change the drive letter
>to E.
>We would like to know what steps we should do in order to
>move the database from J to E drive ? Is it necessary for
>us to detach and attach the database ? OR Just change the
>file location of the database from J to E in EM?
>Thanks
>
sql

Change Drive Letter

We have installed a SQL Server 2000 database on the J
drive. However, we would like to change the drive letter
to E.
We would like to know what steps we should do in order to
move the database from J to E drive ? Is it necessary for
us to detach and attach the database ? OR Just change the
file location of the database from J to E in EM?
ThanksYou would need to detatch the database, move the files and then re-attach
the files to bring the DB back online. When re-attaching the files however
you will be able to browse for the .MDF file. If there are any subsequent
files such as .NDF or .LDF you *may* need to search for them separatly.
When detatching a database if you have any full text searches enabled on the
DB, these will need to be re-established once the database is re-attached.
This can be done by right clicking on the table with the full text index and
then proceeding to 'edit' the index.
Hope this helps.
Anubis.
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:018701c5707c$2f643880$a601280a@.phx.gbl...
> We have installed a SQL Server 2000 database on the J
> drive. However, we would like to change the drive letter
> to E.
> We would like to know what steps we should do in order to
> move the database from J to E drive ? Is it necessary for
> us to detach and attach the database ? OR Just change the
> file location of the database from J to E in EM?
> Thanks|||This is a multi-part message in MIME format.
--020308090700050707010001
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
If it's just a single DB you're talking about, detach/attach would be
the best way. I'd strongly advise *against* hacking the system tables
to change the driver letter in sysfiles.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Jason wrote:
>We have installed a SQL Server 2000 database on the J
>drive. However, we would like to change the drive letter
>to E.
>We would like to know what steps we should do in order to
>move the database from J to E drive ? Is it necessary for
>us to detach and attach the database ? OR Just change the
>file location of the database from J to E in EM?
>Thanks
>
--020308090700050707010001
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>If it's just a single DB you're talking about, detach/attach would
be the best way. I'd strongly advise <b>against</b> hacking the
system tables to change the driver letter in sysfiles.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
Jason wrote:
<blockquote cite="mid018701c5707c$2f643880$a601280a@.phx.gbl" type="cite">
<pre wrap="">We have installed a SQL Server 2000 database on the J
drive. However, we would like to change the drive letter
to E.
We would like to know what steps we should do in order to
move the database from J to E drive ? Is it necessary for
us to detach and attach the database ? OR Just change the
file location of the database from J to E in EM?
Thanks
</pre>
</blockquote>
</body>
</html>
--020308090700050707010001--

Change Drive Letter

With reference to my previous posting, it seems that there
may be some misunderstanding.
We have installed a SQL Server 2000 database on the J
drive. However, we would like to rename the J drive to E
drive (Asked by the Network Administrator).
We would like to know is it necessary for us to do
anything for the change of drive letter ? Is it necessary
for us to detach and attach the database when he changes
the drive name? OR Just change the file location of the
database from J to E in EM?
ThanksThis is a multi-part message in MIME format.
--070500050405010801060608
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Renaming drive letters is really ugly. If you just rename the drive
letter then SQL Server probably wont even start because it will be
looking for the master database primary data file on the wrong drive
letter (which will no longer exist). This can be changed in the
registry but there are a myriad of other problems you will encounter.
It may be best just to detach all you user DBs, uninstall SQL Server,
rename the drive letters, reinstall SQL Server and reattach your user
DBs again (now located on the renamed drive letter). If you'd already
done a fair bit of server config you may want to backup your master,
model & msdb (and potentially distribution DB if configured as a
distributor participating in SQL replication) databases before
uninstalling SQL Server and then restore them after reinstalling.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Jason wrote:
>With reference to my previous posting, it seems that there
>may be some misunderstanding.
>We have installed a SQL Server 2000 database on the J
>drive. However, we would like to rename the J drive to E
>drive (Asked by the Network Administrator).
>We would like to know is it necessary for us to do
>anything for the change of drive letter ? Is it necessary
>for us to detach and attach the database when he changes
>the drive name? OR Just change the file location of the
>database from J to E in EM?
>Thanks
>
>
--070500050405010801060608
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Renaming drive letters is really ugly. If you just rename the
drive letter then SQL Server probably wont even start because it will
be looking for the master database primary data file on the wrong drive
letter (which will no longer exist). This can be changed in the
registry but there are a myriad of other problems you will encounter.<br>
<br>
It may be best just to detach all you user DBs, uninstall SQL Server,
rename the drive letters, reinstall SQL Server and reattach your user
DBs again (now located on the renamed drive letter). If you'd already
done a fair bit of server config you may want to backup your master,
model & msdb (and potentially distribution DB if configured as a
distributor participating in SQL replication) databases before
uninstalling SQL Server and then restore them after reinstalling.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
Jason wrote:
<blockquote cite="mid142001c5708a$b5113a10$a401280a@.phx.gbl" type="cite">
<pre wrap="">With reference to my previous posting, it seems that there
may be some misunderstanding.
We have installed a SQL Server 2000 database on the J
drive. However, we would like to rename the J drive to E
drive (Asked by the Network Administrator).
We would like to know is it necessary for us to do
anything for the change of drive letter ? Is it necessary
for us to detach and attach the database when he changes
the drive name? OR Just change the file location of the
database from J to E in EM?
Thanks
</pre>
</blockquote>
</body>
</html>
--070500050405010801060608--|||Actually, this is not as dramati as Mike depicted, but backing up before
doing anything else is always a good idea. Check this article for details:
http://www.support.microsoft.com/kb/224071/EN-US/
"Mike Hodgson" wrote:
> Renaming drive letters is really ugly. If you just rename the drive
> letter then SQL Server probably wont even start because it will be
> looking for the master database primary data file on the wrong drive
> letter (which will no longer exist). This can be changed in the
> registry but there are a myriad of other problems you will encounter.
> It may be best just to detach all you user DBs, uninstall SQL Server,
> rename the drive letters, reinstall SQL Server and reattach your user
> DBs again (now located on the renamed drive letter). If you'd already
> done a fair bit of server config you may want to backup your master,
> model & msdb (and potentially distribution DB if configured as a
> distributor participating in SQL replication) databases before
> uninstalling SQL Server and then restore them after reinstalling.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
>
> Jason wrote:
> >With reference to my previous posting, it seems that there
> >may be some misunderstanding.
> >
> >We have installed a SQL Server 2000 database on the J
> >drive. However, we would like to rename the J drive to E
> >drive (Asked by the Network Administrator).
> >
> >We would like to know is it necessary for us to do
> >anything for the change of drive letter ? Is it necessary
> >for us to detach and attach the database when he changes
> >the drive name? OR Just change the file location of the
> >database from J to E in EM?
> >
> >Thanks
> >
> >
> >
> >
>|||This is a multi-part message in MIME format.
--070302090901030006050107
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
That KB article is assuming the binaries directory is not moving too. I
may have misread/misunderstood the OP. I was basing the
uninstall/reinstall suggestion on the presumption that the whole SQL
installation was on the disk to be renamed (binaries, data files, log
files, tempdb, the works). I agree that if the binaries are staying
where they are (eg. on C:\Program Files\...) the you can move DBs
without the need to uninstall/reinstall and if the system DBs (master,
msdb & model) don't need to move then the process is virtually painless
with a simple detach/attach process.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
rdjabarov wrote:
>Actually, this is not as dramati as Mike depicted, but backing up before
>doing anything else is always a good idea. Check this article for details:
>http://www.support.microsoft.com/kb/224071/EN-US/
>"Mike Hodgson" wrote:
>
>>Renaming drive letters is really ugly. If you just rename the drive
>>letter then SQL Server probably wont even start because it will be
>>looking for the master database primary data file on the wrong drive
>>letter (which will no longer exist). This can be changed in the
>>registry but there are a myriad of other problems you will encounter.
>>It may be best just to detach all you user DBs, uninstall SQL Server,
>>rename the drive letters, reinstall SQL Server and reattach your user
>>DBs again (now located on the renamed drive letter). If you'd already
>>done a fair bit of server config you may want to backup your master,
>>model & msdb (and potentially distribution DB if configured as a
>>distributor participating in SQL replication) databases before
>>uninstalling SQL Server and then restore them after reinstalling.
>>--
>>*mike hodgson* |/ database administrator/ | mallesons stephen jaques
>>*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
>>*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
>>
>>Jason wrote:
>>
>>With reference to my previous posting, it seems that there
>>may be some misunderstanding.
>>We have installed a SQL Server 2000 database on the J
>>drive. However, we would like to rename the J drive to E
>>drive (Asked by the Network Administrator).
>>We would like to know is it necessary for us to do
>>anything for the change of drive letter ? Is it necessary
>>for us to detach and attach the database when he changes
>>the drive name? OR Just change the file location of the
>>database from J to E in EM?
>>Thanks
>>
>>
>>
--070302090901030006050107
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>That KB article is assuming the binaries directory is not moving
too. I may have misread/misunderstood the OP. I was basing the
uninstall/reinstall suggestion on the presumption that the whole SQL
installation was on the disk to be renamed (binaries, data files, log
files, tempdb, the works). I agree that if the binaries are staying
where they are (eg. on C:\Program Files\...) the you can move DBs
without the need to uninstall/reinstall and if the system DBs (master,
msdb & model) don't need to move then the process is virtually
painless with a simple detach/attach process.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
rdjabarov wrote:
<blockquote cite="mid575074A1-CCF2-4720-B520-06EBD8D11D34@.microsoft.com"
type="cite">
<pre wrap="">Actually, this is not as dramati as Mike depicted, but backing up before
doing anything else is always a good idea. Check this article for details:
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.support.microsoft.com/kb/224071/EN-US/</a>">http://www.support.microsoft.com/kb/224071/EN-US/">http://www.support.microsoft.com/kb/224071/EN-US/</a>
"Mike Hodgson" wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Renaming drive letters is really ugly. If you just rename the drive
letter then SQL Server probably wont even start because it will be
looking for the master database primary data file on the wrong drive
letter (which will no longer exist). This can be changed in the
registry but there are a myriad of other problems you will encounter.
It may be best just to detach all you user DBs, uninstall SQL Server,
rename the drive letters, reinstall SQL Server and reattach your user
DBs again (now located on the renamed drive letter). If you'd already
done a fair bit of server config you may want to backup your master,
model & msdb (and potentially distribution DB if configured as a
distributor participating in SQL replication) databases before
uninstalling SQL Server and then restore them after reinstalling.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a> |* W* <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.mallesons.com</a>">http://www.mallesons.com">http://www.mallesons.com</a>
Jason wrote:
</pre>
<blockquote type="cite">
<pre wrap="">With reference to my previous posting, it seems that there
may be some misunderstanding.
We have installed a SQL Server 2000 database on the J
drive. However, we would like to rename the J drive to E
drive (Asked by the Network Administrator).
We would like to know is it necessary for us to do
anything for the change of drive letter ? Is it necessary
for us to detach and attach the database when he changes
the drive name? OR Just change the file location of the
database from J to E in EM?
Thanks
</pre>
</blockquote>
</blockquote>
</blockquote>
</body>
</html>
--070302090901030006050107--

Change Drive Letter

With reference to my previous posting, it seems that there
may be some misunderstanding.
We have installed a SQL Server 2000 database on the J
drive. However, we would like to rename the J drive to E
drive (Asked by the Network Administrator).
We would like to know is it necessary for us to do
anything for the change of drive letter ? Is it necessary
for us to detach and attach the database when he changes
the drive name? OR Just change the file location of the
database from J to E in EM?
ThanksRenaming drive letters is really ugly. If you just rename the drive
letter then SQL Server probably wont even start because it will be
looking for the master database primary data file on the wrong drive
letter (which will no longer exist). This can be changed in the
registry but there are a myriad of other problems you will encounter.
It may be best just to detach all you user DBs, uninstall SQL Server,
rename the drive letters, reinstall SQL Server and reattach your user
DBs again (now located on the renamed drive letter). If you'd already
done a fair bit of server config you may want to backup your master,
model & msdb (and potentially distribution DB if configured as a
distributor participating in SQL replication) databases before
uninstalling SQL Server and then restore them after reinstalling.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Jason wrote:

>With reference to my previous posting, it seems that there
>may be some misunderstanding.
>We have installed a SQL Server 2000 database on the J
>drive. However, we would like to rename the J drive to E
>drive (Asked by the Network Administrator).
>We would like to know is it necessary for us to do
>anything for the change of drive letter ? Is it necessary
>for us to detach and attach the database when he changes
>the drive name? OR Just change the file location of the
>database from J to E in EM?
>Thanks
>
>|||Actually, this is not as dramati as Mike depicted, but backing up before
doing anything else is always a good idea. Check this article for details:
http://www.support.microsoft.com/kb/224071/EN-US/
"Mike Hodgson" wrote:

> Renaming drive letters is really ugly. If you just rename the drive
> letter then SQL Server probably wont even start because it will be
> looking for the master database primary data file on the wrong drive
> letter (which will no longer exist). This can be changed in the
> registry but there are a myriad of other problems you will encounter.
> It may be best just to detach all you user DBs, uninstall SQL Server,
> rename the drive letters, reinstall SQL Server and reattach your user
> DBs again (now located on the renamed drive letter). If you'd already
> done a fair bit of server config you may want to backup your master,
> model & msdb (and potentially distribution DB if configured as a
> distributor participating in SQL replication) databases before
> uninstalling SQL Server and then restore them after reinstalling.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W* [url]http://www.mallesons.com[/url
]
>
> Jason wrote:
>
>|||That KB article is assuming the binaries directory is not moving too. I
may have misread/misunderstood the OP. I was basing the
uninstall/reinstall suggestion on the presumption that the whole SQL
installation was on the disk to be renamed (binaries, data files, log
files, tempdb, the works). I agree that if the binaries are staying
where they are (eg. on C:\Program Files\...) the you can move DBs
without the need to uninstall/reinstall and if the system DBs (master,
msdb & model) don't need to move then the process is virtually painless
with a simple detach/attach process.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
rdjabarov wrote:
[vbcol=seagreen]
>Actually, this is not as dramati as Mike depicted, but backing up before
>doing anything else is always a good idea. Check this article for details:
>http://www.support.microsoft.com/kb/224071/EN-US/
>"Mike Hodgson" wrote:
>
>

Change Drive Letter

We have installed a SQL Server 2000 database on the J
drive. However, we would like to change the drive letter
to E.
We would like to know what steps we should do in order to
move the database from J to E drive ? Is it necessary for
us to detach and attach the database ? OR Just change the
file location of the database from J to E in EM?
ThanksYou would need to detatch the database, move the files and then re-attach
the files to bring the DB back online. When re-attaching the files however
you will be able to browse for the .MDF file. If there are any subsequent
files such as .NDF or .LDF you *may* need to search for them separatly.
When detatching a database if you have any full text searches enabled on the
DB, these will need to be re-established once the database is re-attached.
This can be done by right clicking on the table with the full text index and
then proceeding to 'edit' the index.
Hope this helps.
Anubis.
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:018701c5707c$2f643880$a601280a@.phx.gbl...
> We have installed a SQL Server 2000 database on the J
> drive. However, we would like to change the drive letter
> to E.
> We would like to know what steps we should do in order to
> move the database from J to E drive ? Is it necessary for
> us to detach and attach the database ? OR Just change the
> file location of the database from J to E in EM?
> Thanks|||If it's just a single DB you're talking about, detach/attach would be
the best way. I'd strongly advise *against* hacking the system tables
to change the driver letter in sysfiles.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Jason wrote:

>We have installed a SQL Server 2000 database on the J
>drive. However, we would like to change the drive letter
>to E.
>We would like to know what steps we should do in order to
>move the database from J to E drive ? Is it necessary for
>us to detach and attach the database ? OR Just change the
>file location of the database from J to E in EM?
>Thanks
>

Change default location of DB's in 2005 Express

I've installed SQL Server 2005 Express, MSSMSE, and SQL BOL and they seem to work. How can I change the default location of the DB's I create in this environment (and/or move them after I create them)?

Thanks!

Answered myself:

Right click the top line ("servers") in the MSSMSE TOC window > properties > database...there are the options

change date&time default formate to mm/dd/yyyy

dear

i've an old sql server 2000, with default date format mm/dd/yyyy

i've installed a new one SQL server 2005 , my application did't work with its date format

i wan't to change SQL 2005 default date format to mm/dd/yyyy instead of dd/mm/yyyy

regards

Dates are displayed as configured for the user (its a session setting). But formatting of the dates should be made in the front end / presentation layer. Don′t do that on the server, try to pass the date in a more generic format like ISO Date. 20061114

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Change Datasource connectionstring

Hey,

I have a SQL Server 2005, an Reporting Services is also installed.
Now I have a report 'Report1' and a datasource 'DS1', the report is build and deployed.
The report works fine when i see it in a browser.

Now I have made a vb.net application with a dataviewer, the dataviewer shows the report 'Report1'.
But I want to be able to change the datasource 'DS1' from my application code.

How can I do this?

thanks

Hi,

you could use a hidden parameter which will influence the beahaviour of a dynamic evaluated connectring string, though connection strings can be designed dynamically like ="Data Source" + IIF(Parameters!SomeParam.Value = 1, "SomeServer",SomeOtherServer") That is a thing which is most common, enabling you to do this also on the brwoser interface by just manipulating the URL of the Report.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Change Authentication

SQL Server has been installed using Windows Authentication.
I want to change one of my databases to mixed mode.
Can someone tell me if this is possible and how to go about it ?
TIAthe authentication is done at the server level so I don't think you can do
this at DB level.
anyone?
"Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
news:ucmjj36pDHA.2772@.TK2MSFTNGP12.phx.gbl...
> SQL Server has been installed using Windows Authentication.
> I want to change one of my databases to mixed mode.
> Can someone tell me if this is possible and how to go about it ?
> TIA
>|||Authentication modes apply to the server and can't be set
differently for individual databases.
-Sue
On Mon, 10 Nov 2003 17:13:00 -0000, "Poppy"
<paul.diamond@.NOSPAMthemedialounge.com> wrote:
>SQL Server has been installed using Windows Authentication.
>I want to change one of my databases to mixed mode.
>Can someone tell me if this is possible and how to go about it ?
>TIA
>

Change an instance of SQL Server 2005

Hi All,

I have two drive, C and D. When first time I installed SQL Server 2005, I think that I point to C drive which is having only 10 GB, instead of drive D which has bigger space. Now, I have a problem of restoring my database due to lack of space on my C drive. Can anyone guide me to change the instance of database from drive C to drive D.

TIA

I am afraid you want to move data from C: to D: .

Stop sqlserver and move your data file from C: to D: .Default data file locates in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA

Start sql server and delete old database and right Databases ->choose attach ->choose add and select data file on D: ->click ok to finish.

Hope it helps.

|||Or simply sepecify a new location on D drive when restoring the database, just make sure the "Overwrite the existing database" option is checked.|||Thank you guys. It works and I don't have not enough space problem anymore.

change (local) to localhost and what's the difference

Two questions
Once sql server has been installed how to change from (local) to
localhost or the other way arround from (local) to localhost? (currently
set (local) and want to change to localhost.
Secondly, what the hell is the difference between them. On development
machines I have installed sometimes localhost will not work but (local)
will. This is the case even when the hosts (<win>/system32/drivers/etc)
file has an entry like the following
127.0.0.1 localhost
Seems very confusing to have two different ways to refer the 'local
machine'
?
See my reply in the other group.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"who" <whome@.spambucket.com> wrote in message news:4081E570.CF1AA587@.spambucket.com...
> Two questions
> Once sql server has been installed how to change from (local) to
> localhost or the other way arround from (local) to localhost? (currently
> set (local) and want to change to localhost.
> Secondly, what the hell is the difference between them. On development
> machines I have installed sometimes localhost will not work but (local)
> will. This is the case even when the hosts (<win>/system32/drivers/etc)
> file has an entry like the following
> 127.0.0.1 localhost
>
> Seems very confusing to have two different ways to refer the 'local
> machine'
> ?
>

change (local) to localhost and what's the difference

Two questions
Once sql server has been installed how to change from (local) to
localhost or the other way arround from (local) to localhost? (currently
set (local) and want to change to localhost.
Secondly, what the hell is the difference between them. On development
machines I have installed sometimes localhost will not work but (local)
will. This is the case even when the hosts (<win>/system32/drivers/etc)
file has an entry like the following
127.0.0.1 localhost
Seems very confusing to have two different ways to refer the 'local
machine'
?See my reply in the other group.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"who" <whome@.spambucket.com> wrote in message news:4081E570.CF1AA587@.spambucket.com...
> Two questions
> Once sql server has been installed how to change from (local) to
> localhost or the other way arround from (local) to localhost? (currently
> set (local) and want to change to localhost.
> Secondly, what the hell is the difference between them. On development
> machines I have installed sometimes localhost will not work but (local)
> will. This is the case even when the hosts (<win>/system32/drivers/etc)
> file has an entry like the following
> 127.0.0.1 localhost
>
> Seems very confusing to have two different ways to refer the 'local
> machine'
> ?
>