thats assuming he wants to strip data out 😉

personally i would always truncate and de personalise data before giving it to development

makes this post rather redundant then really as your target server will need the...

i would disable DHCP and assign each machine a static IP. check the hosts file on each pc to see if there are any entries in there. Its located in

C:\windows\system32\drivers\etc

or

C:\winnt\system32\drivers\etc

set...

there's more than one way to skin a cat my friend 😉

the public DNS servers will have no knowledge of your internal network naming

from a command prompt type the following and post the complete results

IPCONFIG/ALL

also what make\model is your router?

you wont be able to truncate tables if there are referential integrity constraints on them (foreign keys for example)

disabling the indexes will help from a performance point and maybe you...

go into add\remove programs and run a repair on the .NET 2.0 framework

my thoughts exactly

depends on the referential integrity of the tables, etc. Do you want to import data such as key id fields?

disable any constraints and import the data then re enable them

first thing i would do Michael is ascertain just how much disk space the live database requires.

Once this is done shrink...

choose the correct recovery model for your database and backup accordingly

dont forget to run dbcc updateusage against each database and rebuild the indexes too

i would say this is best done through the web pages code

memory support in the main, 64 bit has better support for larger memory configs

fivetenmm (10/24/2008)

---

So, at the Server level you add a new login let's call it "test1" using Windows Auth mode. Does this just allow "test1" to connect to the Server...