A DENY permission on an object outranks every other permission they may have been granted else where. Look in all the roles\groups these people are in and see if permissions...

ah, thats a shame, I don't think there is any other way. Unfortunately I guess your log chain is broken so you have no choice but to re-initialise...............

this option should work -

for the smaller db re-initialise log shipping by restoring full backup from the primary, when you restore with standby or norecovery also specify with move option...

Mr. Oracle, thanks for the input, it was as you said.

Sharon, CAL licensing is based on the number of concurrent connections to the SQL server, what id theese users use to connect is not relevant, all that matters is the...

For SQL agent you can define a 'master' server which will run jobs on 'slave' servers. sounds like you have that situation here, as you cannot delete the job on...

the rebuild index task will update stats, reorganise index will not

possibly a log backup is occurring on the primary outside of your logshipping process, this log backup would not be copied over to the secondary to be loaded in...

I log ship about 20 databases on a sql 2000 4gB 4 processor server with no probs.

It does make i/o spikey on the backup drive and log drive so important...

guys, thanks for your help. turns out there was another unique index defined on the table I missed because I was so concentrated on the primary key (to be...

congrats on being my 300th post.:D

if you are just restoring a .bak file the syntax is identical in 2000 and 2005 and so the process is identical. (TSQL wise, the...

don't think so matt, how can I be 100% sure there are no insert triggers on this table?

good point steve and I wish it were so, but select on 'where user_attr_id =303' returns only 1 row.

I am thinking I need some sort of outer join on...

you can do log shipping for this number of databases in theory, theres nothing to prevent you. there will be an i/o hit on the backup disk(so keep seperate from...

two ways - use a windows authenticated id or use sp_helprevlogin script to transfer the logins to the standby, then the sids will still match.

note - the load tran log...