right click my computer and select properties. Change the domain and reboot. its only the servername that SQL server uses. Domain membership will just affect the accounts who can connect

me and my big mouth, forgive me it looks as though XP_FileExist doesnt accept wildcards 🙁

you shouldnt need to and personally i wouldnt use xp_cmdshell. Use one of the file access extended stored procedures to find the files in the directory and list them to...

is it a default or named instance?

create and alter index are minimally logged under simple and bulk-logged. i would set the recovery to bulk logged for index rebuilds and back to full afterwards followed by a...

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...