what format are you using to specify the ip and port...

have you informed MicroSoft product support?

as soon as you install SQL Server into a clustered environment it sets the service startup to manual on all nodes (imagine if 2 nodes both had the services set...

No problem, the annoying thing is there are other issues with PDC which aren't fixed until at least SP1 CU7.

Thing is it is a new technology in SQL server and...

Maybe in your test environment only at first 😉

min and max memory settings are indeed dynamic. use the following query to set these

exec sp_configure 'Show advanced options', '1'

reconfigure

exec sp_configure 'min server memory (MB)', 'valueinMB'

exec sp_configure 'max server memory...

yes!!

this is a real problem and many have complained! Don't use scripts to remove the default collection set jobs as you will have issues if you try to re enable...

Sounds dire and beyond the scope of forum posts. What is your location, I am available on a contract...

This post explains it a little more

http://www.pluralsight-training.net/community/blogs/jimjohn/archive/2008/03/23/50536.aspx

MarvinTheAndriod (10/12/2010)

---

Thanks. Ran the T-SQL and it generated the following script:

ALTER LOGIN [SA] WITH PASSWORD = 0x01004086ceb66433e82f3f8946c27e33641a8179e4ad419c5811 HASHED, CHECK_POLICY = ON, CHECK_EXPIRATION = OFF

But it still generated the same error:

Incorrect...

MarvinTheAndriod (10/12/2010)

---

Lowell (10/11/2010)

---

i see what you were refering to...if you run sp_rev_login with no parameters, every login EXCEPT sa is scripted.

if you pass a specific login name, it gets scripted...

Markus (10/12/2010)

---

Microsoft pushes Clustering as the next best thing to sliced bread. In my experience we have had more downtime with clusters than with a regular server. Clusters...

can you post details of the query you are using?

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...