ah, where to start... skipping the conversation and questions about "testing" on "production", and assuming you know what you are doing....

one way to test is to pull the network...

Hmm, not sure of your terminology. What exactly do you mean by "contents of a role"?

If you are looking to track changes to the permissions assigned to...

Joe Wagner (9/19/2011)

---

Good day.

We have the need to add the -g parameter to SQL Server Express instances that are deployed as part of our released product. The SSE instances...

Robert klimes (9/19/2011)

---

I was able to add the login after I had failed-over the server to the other node.

My investigation into this led me to another question. When trying...

GilaMonster (9/19/2011)

---

dave_shipway (9/19/2011)

---

I queried the sys.indexes system table and it appears that these indexes are rebuild every night by a some kind of scheduled job (which I haven't quite tracked...

dave_shipway (9/19/2011)

---

Hi,

Well first of all thanks for the swift responses and the very useful information !

Having found further information in both the job history and the text report file that...

I dont think you want to use SQL Profiler to monitor page splits per second. I think you will have more success using Performance Manager.

Administrative tools> Reliability and Performance....

dave_shipway (9/19/2011)

---

Hi there,

We have inherited the responsibility of administering a SQL Server 2008 Enterprise edition system, and

this is set up with a Maintenance plan which includes a weekly run...

Earlier in this thread, you indicated that you are "hopeful" about backups and that you think your backup strategy is "snapshots of the virtual machines" the databases are hosted on....

Kwisatz78 (9/14/2011)

---

Hi all

This is a bit of a general question but I am wanting to start collecting data for monitoring SQL server such that I can create baselines, and from...

The answer is 42.

Congrats!

Perry Whittle (9/14/2011)

---

Possible owners are defined at the resource level and dictate which nodes in the Windows cluster are able to service this resource

---

For instance, you have a 3 node...

stevenplee (9/13/2011)

---

This should be easy but I am running into all cans of trouble trying to figure this one out. I need to be able to select records from...

to answer the second part, if properly configured, the agent is dependent upon the server service and will therefore go to the same node as the server server... so assuming...