Renaming a database

I've renamed a database using the sp_rename but now I
notice that the mdf file is still named oldDBname.mdf.
Is there a way to rename that file to newDBname.mdf?Renaming the database does not change the physical name of the file. To do that you will have to
use system stored procedure sp_detach_db and sp_attach_db.
An approximate sequence of the steps to be taken would be something like this:
detach the db using sp_detach_db
rename the physical files.
use sp_attach_db stored procedure to attach these rename files.
See more help on this in BOL.
--
- Vishal
"mark" <mhoyt@.affiliatedhealth.org> wrote in message news:02c601c38dc5$c37c8fe0$a301280a@.phx.gbl...
> I've renamed a database using the sp_rename but now I
> notice that the mdf file is still named oldDBname.mdf.
> Is there a way to rename that file to newDBname.mdf?|||Try backup and restore.
/Stefan
"mark" <mhoyt@.affiliatedhealth.org> skrev i meddelandet
news:02c601c38dc5$c37c8fe0$a301280a@.phx.gbl...
> I've renamed a database using the sp_rename but now I
> notice that the mdf file is still named oldDBname.mdf.
> Is there a way to rename that file to newDBname.mdf?|||Vishal:
How about if I want to change the logical name also?
Thanks
"Vishal Parkar" <_vgparkar@.hotmail.com> wrote in message
news:uyhhcdcjDHA.2364@.TK2MSFTNGP11.phx.gbl...
> Renaming the database does not change the physical name of the file. To do
that you will have to
> use system stored procedure sp_detach_db and sp_attach_db.
> An approximate sequence of the steps to be taken would be something like
this:
> detach the db using sp_detach_db
> rename the physical files.
> use sp_attach_db stored procedure to attach these rename files.
> See more help on this in BOL.
> --
> - Vishal
> "mark" <mhoyt@.affiliatedhealth.org> wrote in message
news:02c601c38dc5$c37c8fe0$a301280a@.phx.gbl...
> > I've renamed a database using the sp_rename but now I
> > notice that the mdf file is still named oldDBname.mdf.
> >
> > Is there a way to rename that file to newDBname.mdf?
>|||In SQL 2000, you can use ALTER DATABASE command to change the logical name of the file.
Ex:
alter database northwind modify file
(name = 'northwind', newname = 'northwind_new')
- Vishal|||great.
"Vishal Parkar" <_vgparkar@.hotmail.com> wrote in message
news:%23mbcjrcjDHA.2268@.TK2MSFTNGP12.phx.gbl...
> In SQL 2000, you can use ALTER DATABASE command to change the logical
name of the file.
> Ex:
> alter database northwind modify file
> (name = 'northwind', newname = 'northwind_new')
>
> --
> - Vishal
>|||and how we do this using Enterprise Manager. I openend the properties of
databse but I didn't find any option to rename the logical filename ?
"Vishal Parkar" <_vgparkar@.hotmail.com> wrote in message
news:%23mbcjrcjDHA.2268@.TK2MSFTNGP12.phx.gbl...
> In SQL 2000, you can use ALTER DATABASE command to change the logical
name of the file.
> Ex:
> alter database northwind modify file
> (name = 'northwind', newname = 'northwind_new')
>
> --
> - Vishal
>|||you cant do this through enterprise manager.
--
- Vishal
"Sender" <user@.domain.com> wrote in message news:OcNl6ycjDHA.2268@.TK2MSFTNGP12.phx.gbl...
> and how we do this using Enterprise Manager. I openend the properties of
> databse but I didn't find any option to rename the logical filename ?
>
> "Vishal Parkar" <_vgparkar@.hotmail.com> wrote in message
> news:%23mbcjrcjDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > In SQL 2000, you can use ALTER DATABASE command to change the logical
> name of the file.
> > Ex:
> > alter database northwind modify file
> > (name = 'northwind', newname = 'northwind_new')
> >
> >
> > --
> > - Vishal
> >
> >
>

renaming .mdf to .ldf

While moving tempdb, I have accidentally named templog file templog.mdf.
Now my SQL wouldn't start, it's throwing me this:
"The SQL Server (MSSQLSERVER) service terminated with service-specific error
1814 (0x716)."
Please help...
Rename it back to *.ldf.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:DB670DBE-AAE2-4C17-802B-9E119E5962DC@.microsoft.com...
> While moving tempdb, I have accidentally named templog file templog.mdf.
> Now my SQL wouldn't start, it's throwing me this:
> "The SQL Server (MSSQLSERVER) service terminated with service-specific
> error
> 1814 (0x716)."
> Please help...
|||SQL Server should just create the templog.ldf file if it's not there, and
comes up online. I'd double check whether the error was due to a renamed
templog.ldf file.
Linchi
"Leon Shargorodsky" wrote:

> While moving tempdb, I have accidentally named templog file templog.mdf.
> Now my SQL wouldn't start, it's throwing me this:
> "The SQL Server (MSSQLSERVER) service terminated with service-specific error
> 1814 (0x716)."
> Please help...
|||Rename it back to *.ldf.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:DB670DBE-AAE2-4C17-802B-9E119E5962DC@.microsoft.com...
> While moving tempdb, I have accidentally named templog file templog.mdf.
> Now my SQL wouldn't start, it's throwing me this:
> "The SQL Server (MSSQLSERVER) service terminated with service-specific
> error
> 1814 (0x716)."
> Please help...
|||tempdb is recreated every time you start the database so you should be able
to just delete the ldf and mdf files and start it. If this doesn't work
then chances are the SQL service account doesn't have permissions to write
in the new location.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:DB670DBE-AAE2-4C17-802B-9E119E5962DC@.microsoft.com...
> While moving tempdb, I have accidentally named templog file templog.mdf.
> Now my SQL wouldn't start, it's throwing me this:
> "The SQL Server (MSSQLSERVER) service terminated with service-specific
> error
> 1814 (0x716)."
> Please help...
sql

renaming .mdf to .ldf

While moving tempdb, I have accidentally named templog file templog.mdf.
Now my SQL wouldn't start, it's throwing me this:
"The SQL Server (MSSQLSERVER) service terminated with service-specific error
1814 (0x716)."
Please help...Rename it back to *.ldf.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:DB670DBE-AAE2-4C17-802B-9E119E5962DC@.microsoft.com...
> While moving tempdb, I have accidentally named templog file templog.mdf.
> Now my SQL wouldn't start, it's throwing me this:
> "The SQL Server (MSSQLSERVER) service terminated with service-specific
> error
> 1814 (0x716)."
> Please help...|||SQL Server should just create the templog.ldf file if it's not there, and
comes up online. I'd double check whether the error was due to a renamed
templog.ldf file.
Linchi
"Leon Shargorodsky" wrote:
> While moving tempdb, I have accidentally named templog file templog.mdf.
> Now my SQL wouldn't start, it's throwing me this:
> "The SQL Server (MSSQLSERVER) service terminated with service-specific error
> 1814 (0x716)."
> Please help...|||Rename it back to *.ldf.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:DB670DBE-AAE2-4C17-802B-9E119E5962DC@.microsoft.com...
> While moving tempdb, I have accidentally named templog file templog.mdf.
> Now my SQL wouldn't start, it's throwing me this:
> "The SQL Server (MSSQLSERVER) service terminated with service-specific
> error
> 1814 (0x716)."
> Please help...|||tempdb is recreated every time you start the database so you should be able
to just delete the ldf and mdf files and start it. If this doesn't work
then chances are the SQL service account doesn't have permissions to write
in the new location.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:DB670DBE-AAE2-4C17-802B-9E119E5962DC@.microsoft.com...
> While moving tempdb, I have accidentally named templog file templog.mdf.
> Now my SQL wouldn't start, it's throwing me this:
> "The SQL Server (MSSQLSERVER) service terminated with service-specific
> error
> 1814 (0x716)."
> Please help...

renaming .mdf to .ldf

While moving tempdb, I have accidentally named templog file templog.mdf.
Now my SQL wouldn't start, it's throwing me this:
"The SQL Server (MSSQLSERVER) service terminated with service-specific error
1814 (0x716)."
Please help...Rename it back to *.ldf.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:DB670DBE-AAE2-4C17-802B-9E119E5962DC@.microsoft.com...
> While moving tempdb, I have accidentally named templog file templog.mdf.
> Now my SQL wouldn't start, it's throwing me this:
> "The SQL Server (MSSQLSERVER) service terminated with service-specific
> error
> 1814 (0x716)."
> Please help...|||SQL Server should just create the templog.ldf file if it's not there, and
comes up online. I'd double check whether the error was due to a renamed
templog.ldf file.
Linchi
"Leon Shargorodsky" wrote:

> While moving tempdb, I have accidentally named templog file templog.mdf.
> Now my SQL wouldn't start, it's throwing me this:
> "The SQL Server (MSSQLSERVER) service terminated with service-specific err
or
> 1814 (0x716)."
> Please help...|||Rename it back to *.ldf.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:DB670DBE-AAE2-4C17-802B-9E119E5962DC@.microsoft.com...
> While moving tempdb, I have accidentally named templog file templog.mdf.
> Now my SQL wouldn't start, it's throwing me this:
> "The SQL Server (MSSQLSERVER) service terminated with service-specific
> error
> 1814 (0x716)."
> Please help...|||tempdb is recreated every time you start the database so you should be able
to just delete the ldf and mdf files and start it. If this doesn't work
then chances are the SQL service account doesn't have permissions to write
in the new location.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:DB670DBE-AAE2-4C17-802B-9E119E5962DC@.microsoft.com...
> While moving tempdb, I have accidentally named templog file templog.mdf.
> Now my SQL wouldn't start, it's throwing me this:
> "The SQL Server (MSSQLSERVER) service terminated with service-specific
> error
> 1814 (0x716)."
> Please help...

rename physical files?

Is it possible to rename physical MDF and LDF files? I have been searching
the net for a few hours and I thought I got close with an ALTER DB command.
But I got errors. I think that is only for logical names. Anyhow, here is
what I tried:
alter database pre_8live_hc modify file (name = 'restoredb', newname =
'pre_8live_hc')
alter database pre_8live_hc modify file (name = 'restoredb_log', newname =
'pre_8live_hc_log')
This is what I got back:
Server: Msg 5041, Level 16, State 1, Line 1
MODIFY FILE failed. File 'restoredb' does not exist.
Server: Msg 5041, Level 16, State 1, Line 2
MODIFY FILE failed. File 'restoredb_log' does not exist.
The DB name is pre_8live_hc
Filenames are: (logical / physical)
MDF = NTI_hc_data / d:\program files\microsoft sql
server\msssql\data\restoredb.mdf
LDF = NTI_hc_data_log / d:\program files\microsoft sql
server\msssql\data\restoredb_log.mdf
I have seen some stuff about restore with replace and also attachdb, but
could not get definitive answer. And the commands I tried did not work.
Thanks,
Bryan
You can detach the database, move the physical files (and/or rename them)
and then attach the database. If you can't get that to work, show us the
syntax you are using for sp_attach_db and we'll try to see what's wrong.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"IT Department" <it@.ntihc.com> wrote in message
news:r6amd.10958$Ae.9201@.newsread1.dllstx09.us.to. verio.net...
> Is it possible to rename physical MDF and LDF files? I have been
> searching the net for a few hours and I thought I got close with an ALTER
> DB command. But I got errors. I think that is only for logical names.
> Anyhow, here is what I tried:
> alter database pre_8live_hc modify file (name = 'restoredb', newname =
> 'pre_8live_hc')
> alter database pre_8live_hc modify file (name = 'restoredb_log', newname =
> 'pre_8live_hc_log')
> This is what I got back:
> Server: Msg 5041, Level 16, State 1, Line 1
> MODIFY FILE failed. File 'restoredb' does not exist.
> Server: Msg 5041, Level 16, State 1, Line 2
> MODIFY FILE failed. File 'restoredb_log' does not exist.
> The DB name is pre_8live_hc
> Filenames are: (logical / physical)
> MDF = NTI_hc_data / d:\program files\microsoft sql
> server\msssql\data\restoredb.mdf
> LDF = NTI_hc_data_log / d:\program files\microsoft sql
> server\msssql\data\restoredb_log.mdf
>
> I have seen some stuff about restore with replace and also attachdb, but
> could not get definitive answer. And the commands I tried did not work.
> Thanks,
> Bryan
>
|||Hi,
Follow kelens method. What you did is to rename the Logicalfile name. TO
rename the logical database name you have to be in that database.
Thanks
Hari
SQL Server MVP
"IT Department" <it@.ntihc.com> wrote in message
news:r6amd.10958$Ae.9201@.newsread1.dllstx09.us.to. verio.net...
> Is it possible to rename physical MDF and LDF files? I have been
> searching the net for a few hours and I thought I got close with an ALTER
> DB command. But I got errors. I think that is only for logical names.
> Anyhow, here is what I tried:
> alter database pre_8live_hc modify file (name = 'restoredb', newname =
> 'pre_8live_hc')
> alter database pre_8live_hc modify file (name = 'restoredb_log', newname =
> 'pre_8live_hc_log')
> This is what I got back:
> Server: Msg 5041, Level 16, State 1, Line 1
> MODIFY FILE failed. File 'restoredb' does not exist.
> Server: Msg 5041, Level 16, State 1, Line 2
> MODIFY FILE failed. File 'restoredb_log' does not exist.
> The DB name is pre_8live_hc
> Filenames are: (logical / physical)
> MDF = NTI_hc_data / d:\program files\microsoft sql
> server\msssql\data\restoredb.mdf
> LDF = NTI_hc_data_log / d:\program files\microsoft sql
> server\msssql\data\restoredb_log.mdf
>
> I have seen some stuff about restore with replace and also attachdb, but
> could not get definitive answer. And the commands I tried did not work.
> Thanks,
> Bryan
>
|||Thanks guys. The sp_attach_db worked. I will have to admit I didn't try
just renaming the physical files. For some reason I thought I had tried
that in the past and I kep getting errors saying the file didn't exist, but
now that I think back, I was trying to delete one of two transaction logs
and it wouldn't attach back without both logs.
Thanks a bunch!
Bryan
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OeLusr5yEHA.3408@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Follow kelens method. What you did is to rename the Logicalfile name. TO
> rename the logical database name you have to be in that database.
> --
> Thanks
> Hari
> SQL Server MVP
>
> "IT Department" <it@.ntihc.com> wrote in message
> news:r6amd.10958$Ae.9201@.newsread1.dllstx09.us.to. verio.net...
>

Rename MDF file

Is there a way to rename the mdf and ldf files associated with a databse.
Also can I rename the fil nemae that is created for these when the databse
gets created.you can detach the database
rename the files
attach the database by specifying the new file names
"George Schneider" <georgedschneider@.news.postalias> wrote in message
news:25A21625-0C18-465F-ADCF-D0AB6B66F002@.microsoft.com...
> Is there a way to rename the mdf and ldf files associated with a databse.
> Also can I rename the fil nemae that is created for these when the databse
> gets created.|||To add to Jj's response, you can rename logical file names with ALTER
DATABASE. For example:
ALTER DATABASE MyDatabase
MODIFY FILE(
NAME='MyOldLogicalName',
NEWNAME='MyNewLogicalName')
See the Books online for more information.
Hope this helps.
Dan Guzman
SQL Server MVP
"George Schneider" <georgedschneider@.news.postalias> wrote in message
news:25A21625-0C18-465F-ADCF-D0AB6B66F002@.microsoft.com...
> Is there a way to rename the mdf and ldf files associated with a databse.
> Also can I rename the fil nemae that is created for these when the databse
> gets created.

Rename MDF file

Is there a way to rename the mdf and ldf files associated with a databse.
Also can I rename the fil nemae that is created for these when the databse
gets created.
you can detach the database
rename the files
attach the database by specifying the new file names
"George Schneider" <georgedschneider@.news.postalias> wrote in message
news:25A21625-0C18-465F-ADCF-D0AB6B66F002@.microsoft.com...
> Is there a way to rename the mdf and ldf files associated with a databse.
> Also can I rename the fil nemae that is created for these when the databse
> gets created.
|||To add to Jj's response, you can rename logical file names with ALTER
DATABASE. For example:
ALTER DATABASE MyDatabase
MODIFY FILE(
NAME='MyOldLogicalName',
NEWNAME='MyNewLogicalName')
See the Books online for more information.
Hope this helps.
Dan Guzman
SQL Server MVP
"George Schneider" <georgedschneider@.news.postalias> wrote in message
news:25A21625-0C18-465F-ADCF-D0AB6B66F002@.microsoft.com...
> Is there a way to rename the mdf and ldf files associated with a databse.
> Also can I rename the fil nemae that is created for these when the databse
> gets created.

Rename MDF file

Is there a way to rename the mdf and ldf files associated with a databse.
Also can I rename the fil nemae that is created for these when the databse
gets created.you can detach the database
rename the files
attach the database by specifying the new file names
"George Schneider" <georgedschneider@.news.postalias> wrote in message
news:25A21625-0C18-465F-ADCF-D0AB6B66F002@.microsoft.com...
> Is there a way to rename the mdf and ldf files associated with a databse.
> Also can I rename the fil nemae that is created for these when the databse
> gets created.|||To add to Jéjé's response, you can rename logical file names with ALTER
DATABASE. For example:
ALTER DATABASE MyDatabase
MODIFY FILE(
NAME='MyOldLogicalName',
NEWNAME='MyNewLogicalName')
See the Books online for more information.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"George Schneider" <georgedschneider@.news.postalias> wrote in message
news:25A21625-0C18-465F-ADCF-D0AB6B66F002@.microsoft.com...
> Is there a way to rename the mdf and ldf files associated with a databse.
> Also can I rename the fil nemae that is created for these when the databse
> gets created.

Rename Files

Is it possible to rename the mdf and log file names?Not while a DB on the server is using those files. (Not that I can
think of off the top of my head anyway.) You'd have to detach the
database (that uses those files), rename the files on the file system
and then reattach those renamed files.
*mike hodgson*
http://sqlnerd.blogspot.com
scott wrote:

>Is it possible to rename the mdf and log file names?
>
>|||Scott,
you could use the following scrip as a template:
USE master;
GO
ALTER DATABASE The_DB MODIFY FILE
(NAME = The_DB_Data,
FILENAME='C:\SQLSVRDB\The_DB_new.mdf');
GO
ALTER DATABASE The_DB SET OFFLINE;
EXEC master..xp_cmdshell 'rename C:\SQLSVRDB\The_DB_old.mdf The_DB_new.mdf';
ALTER DATABASE DB SET ONLINE;
GO
Andrey Odegov
avodeGOV@.yandex.ru
(remove GOV to respond)

rename aspnetdb ?

Hello,

I have a shared hosting plan which already has aspnetdb.mdf on the server so of course I cannot use that db name for my site...

I have renamed the db and now I get an errorCould not find stored procedure 'dbo.aspnet_CheckSchemaVersion

My question is, how can I make this thing work? All help is greatly appreciated!

Hello my friend,

The aspnet.mdf database is intended for development and testing only, not for production due to performance reasons. When moving into production, you should change your site to use a real full heavyweight SQL Server database. Besides the aspnet tables existing in a different database, there is virtually no difference in terms of the application so you do not need to worry about changing your pages/code. I assume your different sites that you will be hosting will use different databases so this problem you are having will not occur when this has been sorted.

Kind regards

Scotty

|||

Scotty,

Ok, so let's say that what you say is true... how do you get all of the membership and users from aspnetdb into another db so that it can be used with my SQL Enterprise edition or any other for that matter

thanks!

|||

Hello again my friend,

I usually give the full answer to questions instead of referring to urls but I feel the following url demonstrates it better than I have time to explain: -

http://www.beansoftware.com/ASP.NET-Tutorials/Security-Features.aspx

You might find it useful to take advantage of the ApplicationName property if you wish the different sites that you are hosting to use the same database. Personally, I would always use a a separate database for each application.

Kind regards

Scotty

|||

Scotty,

So far so good... I haven't uploaded the new db yet but I have a feeling that this will work...

Question: where does the machine.config come into play on the hosting/production server?

Is that something that needs to be ftp'd over also?

KS

|||

Hello again my friend,

If you have installed .NET on the production server, the machine.config file should be there already. You should not need to change any settings in here. Besides, if you did, you override them using your web.config file in your website.

Machine.config is the top of the tree, its contents apply to all applications. When you create an application, you can overrule these settings by specifying settings in your web.config file. Further down, a web.config file in a subfolder of your application can overrule some settings in your web.config file in your application's root folder. This can go several subfolders deep. Finally, a web page in a folder can overrule some settings in the web.config file of that folder. One such setting is whether to use debugging or not.

Kind regards

Scotty

|||

Scotty,

Alright... sounds good... well, I have uploaded the site and db and now I am getting the error:

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'

I am not sure what that means other than a connection was not made somewhere...

Maybe my connection string is wrong:

<connectionStrings>
<remove name="LocalSqlServer" />
<add name="ConnectionString" connectionString="Server=(local);Database=mff;User ID=xxxx;Password=xxxx;" />
<add name="LocalSqlServer" connectionString="Server=(local);Database=mff;User ID=xxxx;Password=xxxx;" />

</connectionStrings>

I am just not sure... let me know what you think

|||

Hello again,

Have you tried logging on to the SQL Server Management Studio/Enterprise Manager directly with the same credentials that you are using in the web.config? Do this to test the connection, it could be a SQL Server issue; wrong username or password. When you get it working directly, then try it with the website. If you are ever unsure about connection strings, a good resource on this iswww.connectionstrings.com.

Kind regards

Scotty

|||

I can't figure out how to give the database a user and password... maybe that is some of the problem...

When I log into SQL Server I do not need any password or user it is set to windows authentication

thanks for all your help bro'

|||

Scotty,

Alright... I got into the db using the credentials and it appears that I can get in fine, BUT when I do... there are no tables... what is going on there? Any ideas?

Kevin

|||

Hi - I have the exact same problem, i.e. have been learning and designing a site using membershio, so default database (ASPNETDB.MDF) created.

All working fine on loical PC but just signed up with hosting company and tried to create database but told that ASPNETDB.MDF already in use, so I have to rename my membership database.

After reading the correspondence on this topic, I still don't understand what I need to do.

Are you saying that with the SQL Express 2005 edition I can't get it to use a different name for the default database?

Are you saying that with a different SQL version (which one - the Developer edition for $49?) that I can?

With whatever version I need, is it a complicated job (remember - I'm a beginner).

I'd really appreciate feedback on this.

Regards,

Garrett

|||

Garrett,

Are you uploading your db directly onto a server as an mdf file OR are you scripting this db to a hosting account? If you are scripting this db to a host, which I assume you are, this will be as simple as changing the name of the db via the script before scripting to the host...

let me know

|||

I understand all that now.

I posted the same question in a different part of the forum and got the response I needced.

http://forums.asp.net/p/1200251/2087698.aspx#2087698

Thanks to everyone for the help.

Garrett