Viewing 15 posts - 7,576 through 7,590 (of 9,244 total)
This post explains it a little more
http://www.pluralsight-training.net/community/blogs/jimjohn/archive/2008/03/23/50536.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2010 at 11:40 am
MarvinTheAndriod (10/12/2010)
ALTER LOGIN [SA] WITH PASSWORD = 0x01004086ceb66433e82f3f8946c27e33641a8179e4ad419c5811 HASHED, CHECK_POLICY = ON, CHECK_EXPIRATION = OFF
But it still generated the same error:
Incorrect...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2010 at 10:50 am
MarvinTheAndriod (10/12/2010)
Lowell (10/11/2010)
if you pass a specific login name, it gets scripted...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2010 at 10:04 am
Markus (10/12/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2010 at 9:42 am
swethak13 (10/12/2010)
I tried,but it gives me the same error ..Please suggest.
Swetha K
can you post details of the query you are using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2010 at 9:29 am
The Redgate compiled help manual in your Redgate client install directory also has full details how to do this. Search the manual for either the "CONVERT" command to use command...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2010 at 9:28 am
This has all changed between versions SQL Server 2008 and SQL Server 2008 R2
which edition are you using?
Licensing all physical CPU's in the Host machine at Enterprise level in 2008...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2010 at 9:19 am
Halcyon (10/11/2010)
Evening Perry,can I confirm the steps:
1) Windows Cluster
2) SQL Server Cluster
3) Then add MSDTC to the SQL Server application
That's the steps you need to follow
Halcyon (10/11/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2010 at 4:48 am
Create a clustered DTC resource and put it into the same resource group as your clustered SQL Server instance.
Then create a mapping to the DTC resource for the SQL Server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2010 at 12:01 pm
Duran (10/11/2010)
Just to be clear, if I have 5 SQL instances on a cluster, I'd need 5 separate drives, each with their own drive letter? 5 SQL instances cannot put...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2010 at 11:06 am
Minto Minto(quendans) (9/30/2010)
login failed for user .the user is not associated with a trusted sql server connection :error 18452
what are the severity and state values for this message?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2010 at 9:50 am
Shared disk arrays can take many different formats. You could have a linux based server with disks shared over iSCSI, you may have a storage area network using fibre channel...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2010 at 7:21 am
you will need new disk resources to install the SQL 2008 instance, you wont be able to share the SQL 2005 disk resources!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2010 at 7:18 am
Halcyon (10/7/2010)
I would take the sql server application offline and then power down passive node, active node.Perry, your opinion?
Yes for a clean shutdown, the domain controller (which I guess is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2010 at 7:59 am
Go into failover cluster manager and expand the cluster. Right click Storage and select Add Disk!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2010 at 3:45 am
Viewing 15 posts - 7,576 through 7,590 (of 9,244 total)