Nope - the number of pages printed is based on pronter page sizes. Since you could print the report to a deskjet with 8.5x11 paper, or a copier with...

I have never been a big fan of cascading deletes with triggers or through the use of the default cascading delete behavior. Preventing referential integrity violation by automatically deleting...

One of the most important things about schemas is that they have taken users out of the object ownership role in the database. This means that a user can...

The last post is getting at the root of what can be a problem with triggers. If you are truly doing an auditing process, a regular DML trigger that...

A bit field is really True/False much more than it is 1/0. If you want to change it's data type, you can either use a data conversion or a...

The easiest way is to set up two data source folders.

This also sounds suspiciously like you are asking us to do your homework for you.

I have never used the default reporting that they are talking about. I also do not have the folder specified. My guess is that it is installed with...

Run this query:

select @@version

it will give you some OS information, the SQL edition, and the version / service pack number.

The subscriber either needs to be able to use an NT login that is valid in the publishing database, or you will need to use SQL authentication. Using SQL...

Yes, in fact you can configure merge replication over http or https with both named and anonymous subscriptions.

The books online instructions are not bad.

At my current company we use SSIS extensively and BizTalk a little. I have previously worked with BizTalk for a couple of years at another company. Here is...

That is a very valid point.

Can you split data files over disk arrays and see performance increases? - Yes

Can you see performance decreases? - Yes

Having someone with experience or training...

The down side to this strategy is index fragmentation takes it's toll very quickly and can cause queries to have to do a lot of switching from one disk to...

I would also agree with Grant's suggestion - a simple backup / restore solution would probably work best for you.

Depending on your bandwidth, you may also want to include zipping...