The script for creating a credential is simple:

CREATE CREDENTIAL [MyCredential] WITH IDENTITY = 'DOMAIN\FakeUserName', SECRET = 'awfulpassword';

You can generate a script using Management Studio by creating a new credential, entering...

You could also use the xp_loginconfig extended stored procedure, although it comes with the dire warning in Books Online that it "will be removed in a future version of Microsoft...

It appears that the SMO components may be redistributable. The Management Objects package is freely available from Microsoft's site (as part of the Feature Pack for Microsoft SQL Server 2005...

K. Brian Kelley (6/17/2008)

---

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

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

What you are seeing is syntax conforming to the ODBC specification. The braces are an ODBC escape sequence.

You'll most often see this type of syntax with generated SQL statements from...

Another idea may be to use WMI event alerts and the DATABASE_MIRRORING_STATE_CHANGE event.

You could set up a WMI event alert to look for DATABASE_MIRRORING_STATE_CHANGE events ( SELECT * FROM DATABASE_MIRRORING_STATE_CHANGE...

Ashish,

I don't have a test system in front of me right now, but hopefully can provide some pointers in the right direction. It appears that the "FOR XML" clause in...

Alright. While both answers may be somewhat technically accurate, they aren't answers to your question, Mark.

You won't actually move the data file, but you can move specific objects that reside...

You will be covered. Hotfixes are generally cumulative.

Per Microsoft: "Unless otherwise specified, all the hotfixes in earlier builds are included in later builds."

This information is from the MS knowledge base...

Also, in the future, if you find that you have inadvertantly left the NORECOVERY option in your restore statement, you can simply run the following statement:

RESTORE DATABASE...

Another route would be to use the SQL Server User Settable Object to create a custom Performance Monitor counter. It's fairly well-documented in Books Online.

Create a job that executes your...

You could use the Windows Indexing Service. It has APIs that you can use to manage and query the index data programmatically.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/indexsrv/html/indexingservicestartpage_6td1.asp

Also published as a White Paper on SonaSoft's site:

http://www.sonasoft.com/pdf/DRandBCforSQLServersThruStandby.pdf

Clearly a marketing tool designed to sell their software, rather than an objective discussion of the topic.

I found Robert Vieira's Professional SQL Server 2000 Programming (Wrox) extremely helpful. While it isn't specifically geared toward the exam, if you know the material in this book, along with...