I think another poster suggested this a while back here or sql-esrver-performance, try searching the forums.

My advice is the same now - don't do it. There aren't any reasons for,...

How did you connect to create the user?

Can you do the same remotely?

Did you create a User or a Login? CREATE USER? CREATE LOGIN? Did you GRANT any...

There's more to the job than getting it working, quick and dirty. How many systems have you come across with hundreds of packages that mean nothing to...

Okay, take the word trigger out and explain again. Triggers are fired upon an action, not a date.

Is it that you want inserts for the week held back until sunday?

The article is from a book. I would assume that purchasing the book would give you access to the sample databases they used - contact the publisher.

Use the copy database wizard, it'll migrate the users as well.

The service running as a local administrator won't help.

Grant access on the share and the folder to the *domain* account the SQL Server is running under.

And please, lock it all...

And/Or set a default.

ALTER TABLE tablename

ADD CONSTRAINT columnname_default

DEFAULT 0 FOR columnname

SP1 CTP is available now

Ugh. Account mirroring - you'll get this problem frequently if you use it.

Thanks for posting the resolution.

I, for one, am glad at the greater apparent complexity - the main problem with Microsoft products in a large corporate nevironment was that any Tom, Dick or Harry with...

Where is this article published?

Your maintenance and backup jobs should be inline with business requirements.

Ask the business how much data loss is acceptable - what down time is acceptable for recovery?

Ask the current application...

You think I've said something incorrect?

Those key icons indicate a key constraint - not just primary keys.

A foreign key constraint is created on the table the contraint is applied to,...

Oops- wasn't paying attention.

Replication through a firewall should be implemented by using IIS as an intermediary - have a look at "Web Synchronization for Merge Replication " in BOL.

In this...