Dugi,

I look at it this way. The MVP is a community service award. However, in order to win it you're supposed to be extremely knowledgable in the area for which...

I wouldn't use a linked server connection with a DDL trigger. If there is an issue with the connection, the whole transaction will roll back. Probably better to do this...

liya.b (6/24/2008)

---

Hello,

I have a VB application connecting to SQL Server database using SQL Server Authentication. I'd like to use Windows security instead. If I replace 'Uid=myUsername;Pwd=myPassword;' in connection string...

With SQL Server 2005 on a Windows Server 2003 cluster, you're going to want shared disk resources for:

Quorum

MS DTC

Data

Logs

TempDB

The following will require IP and Network Names:

Quorum (the cluster name)

MS DTC

The...

Cdyer (7/7/2008)

---

Okay - so I can create a single-node cluster using SAN storage and the quorum drive in the SAN as well. Install SQL Server 2005, migrate my databases, yada...

To get access to the performance counters, if you're not a member of the local administrators group, you'll have to be a member of the Performance Monitor Users local group...

And it's flat-out not smart. When I used to be active on the Microsoft certification newsgroups ages ago, we would often see braindump questions posted where the answer that was...

Are you logging on with the account that is locked or with a different account?

mohammed moinudheen (6/18/2008)

---

I tried to add SomeUser using command

net group SomeGlobalGroup SomeUser /domain /add

But I am getting error message as below

The request will be processed at a domain controller for...

Doh! I just realized RMSummary had been moved over to 2005, but the data store is still on a 2000 server. So we are not running the data store on...

kozloski (6/17/2008)

---

We have recently implemented SQL Server 2005 with SP2a (build 3042) in support of our Citrix farm upgrade to Presentation Server 4.5.

We are using transactional replication with immediate updating...

Citrix Support Forums home page

To be honest, I've not found a lot of DBAs on here that are aware of what version of Citrix is being run... they may support a Citrix data store,...

Truth be told, you shouldn't be doing this through xp_cmdshell. What you're doing in that case is having SQL Server start a command shell and run the command at the...

BigJohn (6/17/2008)

---

Hi Subhash,

Thank you for your comments.

I am not sure if we would need to create a new Virtual Name and IP. I was under the impression that we could...