Viewing 15 posts - 3,121 through 3,135 (of 9,244 total)
If you ran sp_help_religion on a 2008 instance and moved to 2012 the passwords would be lost due to the changes in encryption.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2014 at 1:52 pm
lkennedy76 (7/30/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2014 at 1:32 pm
Grant Fritchey (7/30/2014)
Pretty sure the key word there is VIEW, but we could also add STATE. Same thing with VIEW DATABASE STATE.
😀 clearly those terms are confusing!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2014 at 8:34 am
GrassHopper (7/30/2014)
what is the sql server service acct (default)?
Whatever you set it to!!
Open sql server configuration manager on the server and check the acct in use for the sql and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2014 at 8:27 am
SQLSteve (7/30/2014)
I have 2, 2 node clusters
PROD1(cluster 1) Clustered SQL instance1
PROD2(cluster 1)
DR 1 (cluster 2) Clustered SQL insatace 2
DR 2 (cluster 2)
I have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2014 at 8:10 am
No, it wont. It allows acces to a range of system catalogs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2014 at 7:04 am
JeepHound (7/29/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2014 at 3:55 am
JarJar (7/30/2014)
??? how to setup ???
This link details the following
Technet: How to enable log shipping (TSQL)
2.On the primary server, execute sp_add_log_shipping_primary_database to add a primary database. The...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2014 at 3:11 am
See this link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2014 at 1:33 am
wouldnt hurt to try it with the databases read only, good luck
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2014 at 10:18 am
sqldriver (7/29/2014)
Hello,Has anyone ever done a live physical to virtual conversion?
Yes, more than i care to remember :crazy:
sqldriver (7/29/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2014 at 9:27 am
if you're looking in explorer on the node where the disk is not online you won't see it.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2014 at 6:25 am
Marios Philippopoulos (7/29/2014)
You need to:(1) Evict the standalone node from the WSFC cluster
(2) Install the sql on that node
(3) Add the node back to the cluster.
Be very careful here, when...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2014 at 6:17 am
Chowdary's (7/28/2014)
I executed the Script against the DB , i got the following
SpaceUsedMbs, SizeMBs, GrowthAllowed, MaxGrowthSize,Growth and FreeMBs result.But from this result ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2014 at 7:45 am
all replys here http://www.sqlservercentral.com/Forums/Topic1596764-1550-1.aspx#bm1596804
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2014 at 6:31 am
Viewing 15 posts - 3,121 through 3,135 (of 9,244 total)