Viewing 15 posts - 3,496 through 3,510 (of 9,244 total)
@murali (3/6/2014)
I would like to enforce password policy for non-AD accounts.
when I select enfocre password policy on SQL server it will enforce default policy (minimum 8 char with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 7, 2014 at 5:21 am
Thomas Mucha (3/7/2014)
I think the problem is down to the lack of fqdn. So will try to create a fake one via the hosts file.Tom
No it's not. Mirroring will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 7, 2014 at 12:45 am
Grant Fritchey (3/6/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 6, 2014 at 4:40 am
k.manojkumar22 (3/6/2014)
Hi,Is there any way sa user can access folder located in local system.
Appreciate any advice.
Server Info:
SQL Server 2008 r2
OS: Windows Server 2008
Regards,
Manoj
The only way SA can access the local...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 6, 2014 at 4:23 am
Thomas Mucha (3/5/2014)
But I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2014 at 3:55 pm
Pass through authentication will work but it's by no means secure hence why MS specify certificates.
This link has a complete example on setting up mirroring using certs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2014 at 9:58 am
You can query to find the date stats were last updated, then initiate a rebuild
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2014 at 1:10 am
ramadesai108 (1/18/2014)
I searched on the internet for hours but cannot resolve my issue, so this is my last resort.
I have 2 instances of SQL Server 2012 on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2014 at 5:15 am
Typically, if you do not have permission on the remote server to stop and start services, you will not see the green arrow indicators.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2014 at 5:04 am
Which agent is it that will not start, the SQL 2008 R2 instances agent or the SQL 2012 instances agent?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2014 at 5:02 am
Rem70Rem (2/28/2014)
What is the best way to move a Production database to a test one ever days after processing is done ?
I am thinking about backup/restore as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2014 at 4:59 am
eligiable (3/2/2014)
I'm trying to update the following table (SQL Server 2008 R2):
MerchantNoTerminalNoCounterNo
7000001370000014NULL
7000001370000015NULL
7000001370000016NULL
7000001370000013NULL
7000003270000032NULL
7000003270000031NULL
I need the CounterNo to be updated as following, against TerminalNo:
MerchantNoTerminalNoCounterNo
7000001370000014Counter 4
7000001370000015Counter 3
7000001370000016Counter 2
7000001370000013Counter 1
7000003270000032Counter 2
7000003270000031Counter 1
I'm trying...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2014 at 7:45 am
you don't seem to be making any account for mounted volumes in your script, you must try to move away from legacy system catalogs and look at the new catalogs...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 28, 2014 at 2:50 am
Marios Philippopoulos (2/27/2014)
Perry Whittle (2/27/2014)
Marios Philippopoulos (2/26/2014)
When first installing the FCI, we first installed...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 27, 2014 at 9:04 am
Marios Philippopoulos (2/26/2014)
When first installing the FCI, we first installed it on A and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 27, 2014 at 3:50 am
Viewing 15 posts - 3,496 through 3,510 (of 9,244 total)