Viewing 15 posts - 5,926 through 5,940 (of 9,241 total)
Sapen (3/2/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2012 at 11:40 am
sankar276 (3/3/2012)
Hi,Can anyone tell me why we cannot put transaction log file in a FileGroup?
A short trip to SQL Server Books Online would have enlightened you as follows;
SQL Server Books...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2012 at 11:06 am
Any changes to tempdb should be followed by a service restart. When you add files they will take affect immediately but you need to restart to force the proportionate fill...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2012 at 11:46 pm
which hypervisor are you using?
ESX, HyperV,etc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2012 at 4:26 pm
sqlfriends (3/2/2012)
I am the server box admininstrator, why I cannot delete it?
being an administrator on the server does not necessarily give you full access, if the folder\file ACLs have been...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2012 at 4:18 pm
sqlfriends (3/2/2012)
Thanks.Is there also a way to change in SSMS, like I said in earlier post it won't save it.
Thanks
you've been told twice already so, third time lucky
you will need...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2012 at 4:12 pm
durai nagarajan (3/2/2012)
can you elobrate what is the effects of AWE and is there any negative impact?.
will server restart or service restart is needed?.
i have rough idea as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2012 at 10:03 am
The backup of the certificate will be encrypted so this should afford some protection, but as Steve said careful here who you provide access to!
anand_vanam (3/1/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2012 at 12:00 am
Can you post the script
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2012 at 10:56 am
yes, you're starting the service thats why. I prefer to run the exe directly by changing to the Bin path for the instance i wish to start and then executing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2012 at 3:40 am
durai nagarajan (2/29/2012)
same no of processors and RAM
how many cpus how much RAM?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 29, 2012 at 4:43 pm
yes you can upgrade individual instances, if you run the GUI version of the service pack you will see the appropriate checkboxes for each instance. If patching from the command...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 29, 2012 at 4:29 pm
you are trying to start the instance from the system32 directory, you need to change directory to the correct bin location path before issuing the start command!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 29, 2012 at 4:23 pm
na1774 (2/28/2012)
I am trying to move my DB data files into different drive. I used Alter DB and Modify File Commands. But After I changed the Location of File....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 29, 2012 at 4:21 pm
YaHozna (2/29/2012)
Quick bit of background would probably help. My company has recently implemented a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 29, 2012 at 4:08 pm
Viewing 15 posts - 5,926 through 5,940 (of 9,241 total)