I know of no method that will attach as marked read. I am not sure on the MSDE 1 and 2000 thing and would probably do on another machine istead...

The most likely cause is locks issued by Access to the table, then when the inserts occurr of course the index changes will further delay the lock release. Yes, you...

Well, I don't want you to feel I am steping on your toes, just wanted to throw that out there for safety.

"Don't roll your eyes at me....

I saw several threads, here and on other sites in which apparently this was a statement sqlmap70.dll from SP1 was an MS sugestion. Several post have suggested it fixed things...

That i what I was thinking. First I would make a backup of the database, as always for safety, and try one of these at a time things.

Try installing SP2...

I am not sure why you had this occur. I tested on several machines to insure that I was messing with the proper fields and had no issues with it...

You do have to make writeable as the DB must be upgraded to SQL 2000 to attach, which means changes will take place. Now if you do not have access...

Well, I spend a lot of time on the internet and use various tools for research but if you need to look around a bit for possible related items take...

Not sure of anything able to do this in a single report. I am pretty sure that Crystal supports various languages but you will have to build a customized report...

I don't see where it is related based on the code here but the only other time I have seen this is when some failure occurrs within the query usually...

Also, if the other server is on a seperate domain you will not be able to use Windows Authentication unless you have a proper trust relationship established between the two...

IIS is the name of the entire Web Server application. SQL can be accessed or thru code can access data from one.

IIS is comprised of 4 services.

IISAdmin which is...

Two questions.

1) What version of SQL and SP level are you running?

2) How many columns does the biggest table involved in replication have.

"Don't roll your eyes at me. I will...

Personally I use the SQL backup to local files on some systems and SQL to tape on others. Like Steve stated there are issues reported by people everyday here looking...

As for triggers on system tables. This is a bad practice and should be avoided.

Note from BOL

quote:

---

Because SQL Server does not support...