This still seems to be the case in 2008. The CHECK CONSTRAINT on the underlying tables must be set to "Check Existing Data on Creation or Re-Enabling = Yes." I...

This worked like a CHAMP! I added the insert to our existing trigger, and it caught my insert details in the failure condition. Now if this thing recreates itself, we...

Very nice! Thanks!

so this proc needs to be installed in each database where you want to run it?

This worked for me. Ran this on the publisher database, and the logreader ran fine. I'm going to read up...

I was getting this on one single custom replication proc. It turns out that the linked server referenced in the proc on the subscriber was referencing the publisher, and this...

Thanks very much, Adam! Looks like I was looking at the wrong table.

Much appreciated.

Check and make sure you have enough disk space for the files to grow. If the DB files are set to autogrow, they will grow until they run out of...

As a relatively new DBA myself, I can recommend SQL Books Online as your primary source. Pretty much everything you will need to know is in there. Microsoft pulished administrators...

Is it the query analyser box? If so, it wants you to tell it what server to connect to, and what login to use.

Do you have any indexes on the table? Do you really need to select all of those columns? IF you can create a unique index on the columns that you...

Making the login db_datareader on the desired database would work as well, wouldn't it?

From books online:

DBCC SHRINKFILE applies to the files in the current database. Switch context to the database to issue a DBCC SHRINKFILE statement referencing a file in that particular database....

I was able to get around this issue by setting up an alias for the server giving me trouble in the Client Network Utility.

With the help of a much smarter DBA, this has been solved. At some point, someone moved a system database on the system. Apparently, after you do this, you...