Network

I am installing a new server with windows 2000 and SQL 7 i
will be restoring the databases from the old serveer to
the new but need to keep the network name it seems if the
name is renamed it creates problems has anyone carried out
this opreation successfully
If you are using backup software, no problems. If you copying across the
network and re-attaching, then both machines can not be up on the network at
the same time.
Cheers,
Rod
"Steve Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:166b601c447c6$f50d9020$a101280a@.phx.gbl...
> I am installing a new server with windows 2000 and SQL 7 i
> will be restoring the databases from the old serveer to
> the new but need to keep the network name it seems if the
> name is renamed it creates problems has anyone carried out
> this opreation successfully
|||As Rod states you should be fine but there are some links that may be of
interest:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.databasejournal.com/featu...le.php/2228611
Transferring Logins
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB
Wizard issues
Andrew J. Kelly
SQL Server MVP
"Steve Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:166b601c447c6$f50d9020$a101280a@.phx.gbl...
> I am installing a new server with windows 2000 and SQL 7 i
> will be restoring the databases from the old serveer to
> the new but need to keep the network name it seems if the
> name is renamed it creates problems has anyone carried out
> this opreation successfully

Need to update old area codes

I have files with area codes that are several years old. Everything I've seen about updating area codes deals with area codes that are current and are about to split in the near future. How would I go about bringing old area codes up to date?It's based on the area code and the exchange...go to usps site...|||Er, Brett, are you sure you want to point sync to the Postal Service? Why would they give a rat's ass about area codes?

Could you provide a URL?

I would love to have a consistant source of Area codes, not to mention international codes. right now I have to search around scrubbing various web sites for up to date lists.|||bpdWork, Which web sites are you using to get your lists? At the moment I'm not even sure what kind of data I need to do the job.|||Originally posted by sync
bpdWork, Which web sites are you using to get your lists? At the moment I'm not even sure what kind of data I need to do the job.
http://www.nanpa.com/nanp1/AllCodes.zip|||Thank you jbroyles. It seems that in order to use the NANPA data, the area codes that need updating must have dates associated with them. Is that correct? My data does not have dates.

Peter|||Originally posted by sync
Thank you jbroyles. It seems that in order to use the NANPA data, the area codes that need updating must have dates associated with them. Is that correct? My data does not have dates.

Peter

It seems you would be correct.|||bump|||[doooh]
postal service
[/dooh]

I used to have a linke...it might have been ATT...

try this

http://www.vzmultimedia.com/customersupport/areacodes/recent_changes.html

or this

http://www.consumer.att.com/global/english/usa_codes.html

There used to be a conversion list using exchanges....