Viewing 15 posts - 5,161 through 5,175 (of 9,241 total)
Correct you can't drop the user, you change the mapping.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2012 at 5:44 pm
chuck.hamilton (8/16/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2012 at 8:44 am
for the images you may be better off with Windows Distributed File System. This is much improved under Windows 2008
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2012 at 7:54 am
alex.thompson (8/16/2012)
Could you elaborate on your bullet point about TDE not encrypting databases used in replication topologies? I'm thinking specifically of log-shipping.
Replication does not replicate the database encryption calls, they...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2012 at 7:29 am
Geoff A (8/16/2012)
we use TDE. we have about half the databases encrypted. the others are not.
i noticed less than 5% increase in CPU usage...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2012 at 7:25 am
I started using C along with Pascal at college in my youth. I think it's a great language very powerful (you can use assembly directly within C). I think it's...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2012 at 12:41 pm
No, the network names have nothing to do with it, it's the instance name that is the restriction. Each machine can only have 1 default instance clustered or not.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2012 at 12:11 pm
No, you may have only 1 default instance. The rest would be named
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2012 at 9:16 am
you will need to throroughly test this, set the timeout via T-SQL
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2012 at 4:33 am
Manie Verster (8/15/2012)
Yes! I know but how and to what? I don't have a cooking clue. Can you help maybe, Perry?
as Anthony said above really.
You could also use the stored...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2012 at 3:58 am
liteswitch (8/15/2012)
Now, I want the cluster to operate in a synchronous mode, with a witness
Let's clear the confusion first, you mean mirror session not cluster
liteswitch (8/15/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2012 at 2:38 am
Manie Verster (8/15/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2012 at 2:10 am
Initially I would have said the login owns the database, double check and confirm this is not the case.
Has this database come from sql2000 at some point?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2012 at 11:58 pm
can you post a screenshot of what you see?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2012 at 10:27 am
you need to instantiate the Urn[] collection before attempting to use it.
Revise the following
StringCollection sc = scripter.Script(new Urn[] {db.Urn });
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2012 at 10:24 am
Viewing 15 posts - 5,161 through 5,175 (of 9,241 total)