Viewing 15 posts - 8,776 through 8,790 (of 9,241 total)
kendal.vandyke (11/6/2008)
We have multiple datacenters and each datacenter has 2 controllers for redundancy.
all these DC's are on the same domain then are they?
kendal.vandyke (11/6/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2008 at 9:32 am
the following stored procedure
sp_attach_single_file_db
attachs a single file database, however it relies on the MDF not the LDF. M$ went to all the trouble of cov ering this, I'm sure if...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2008 at 9:25 am
kendal.vandyke (11/5/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 6, 2008 at 6:18 am
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 5, 2008 at 7:02 am
me and my big mouth, forgive me it looks as though XP_FileExist doesnt accept wildcards 🙁
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2008 at 5:37 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 1, 2008 at 4:50 pm
is it a default or named instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2008 at 8:03 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 29, 2008 at 3:27 pm
thats assuming he wants to strip data out 😉
personally i would always truncate and de personalise data before giving it to development
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2008 at 11:53 am
michael.anyone (10/27/2008)
shrinking is not a real choice because the DB will be at 100GB within a year
makes this post rather redundant then really as your target server will need the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2008 at 5:07 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2008 at 4:51 am
there's more than one way to skin a cat my friend 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 27, 2008 at 4:38 pm
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?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 27, 2008 at 4:27 pm
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 27, 2008 at 4:19 pm
go into add\remove programs and run a repair on the .NET 2.0 framework
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 27, 2008 at 4:12 pm
Viewing 15 posts - 8,776 through 8,790 (of 9,241 total)