Congratulation on passing the exam.

Thanks for your feedback

I think, only source code is provided with the CD. No DLLs.

You...

beppe_30 (6/22/2010)

---

We have more than 100 databases and we would like to alter the db option "page verify" from "none" to "checksum".

Do you know of any method to accomplish this...

Shark Energy (3/17/2009)

---

Excellent. Works like a charm. I had tried this already but made the mistake of switching the existing Flat File connection from Fixed Width to Ragged Right. For...

peleg (6/18/2010)

---

i am talking about the FG which is on another hard-disk.

an i wantto know what can i do if that Hard-disk crash's

how can i still work with the Primary...

Try to delete the records in smaller chunks. For example: 2,000 records at a time using TOP/WHERE clause.

Also take log backup in between these deletes.

First question:

Do we need to modify this option which is set to "none" or "Torn_Page_Detection" to "checksum"?

Answer: Yes

Second question:

If we modify our databases with the "checksum" option, do we also...

Check the Windows Scheduled tasks.

Also run Profiler to see from which host BACKUP command is issued.

Launch the setup...

Because in the subscriber, update/delete is done using the primary key....

The actual update/delete query that was executed on the publisher is not executed on the subscriber.

Rows in the subscriber are...

Shared Memory protocol is faster than other protocols. But that should not the only reason for running IIS and SQL Server on the same server.

If the web application is...

You need to specify it in the command line for example:

setup.exe /INSTANCESHAREDDIR="D:\Micosoft SQL Server" .....

It looks like you are trying to install 32 bit version of SQL Server on 64bit...

This is the common error message you get when you try to drop any database that is in use.

Are you trying this on test server? If yes, first remove the...

Snapshot agent replicates entire schema (as in initial snapshot).

select <published_colums> From dbo.AgentQueueActivationHist where [ActivationDateTime] >= getdate() - 60