akshay.pawar123 (2/27/2013)

---

I am trying to write up a script to detect whether the installed SQL Server 2008 instance is 32 or 64 bit.

Here's the catch - SQL Server would...

You just need to change the name in...

The quorum is a single mediator, there is only 1. It can use a file share or disk but also can use neither depending on the cluster configuration.

Yes that's what the article discusses 😉

No, a computer can be a member of only one cluster

Rade_ (2/21/2013)

---

This will extract only users from selected database. Got it here at sqlservercentral, can't remember who though.

USE DATABASE

GO

select'CREATE LOGIN ' + sl.name +

' WITH PASSWORD = ' +...

it doesnt matter, 2nd approach is probably easier and would be the way i would do it.

have you tried the Redgate forums or just raise a support call and ask the Redgate support desk, they're very helpful

Its easy, first setup a table in your DBA util database listing the nodes and the preferred location of any instances.

Just use

select serverproperty('computernamephysicalnetbios')

in your audit job and it will...

Ensure the name is 15 chars or less

The users have to be disconnected for the log restores to take place. The database engine is just deferring this action until users are clear, this from Books Online

SQL Server...

Ed Wagner (2/21/2013)

---

Thank you, Perry. I was just getting ready to post that I couldn't do it myself with my permissions.

I just love the wide variety of stuff available...

It's not a group, its a virtual alias used by the service account in SID based security when using SQL Server 2008 under Windows...

Whatever happens you will need to release the sql server handles on the disk file(s), what capacity do you have to copy 200gb of database files across the drives? You...

Note that the correct catalogs now are

sys.server_principals for server level...