Hi Cneuhold, thanks for the info, I ran into this problem several times and checked MS TEchnet but couldn't find anything. Since I work for customers in Holland and Belgium...

First about the error message. I've seen this one once before at a customer site and it turned out that they had been messing around with their master database.I don't...

Not sure if it is what you're looking for, but have a look at SQLWebReports.

http://www.lockwoodtech.com/frame_products.htm

Are you sure there's a separate login for Administrator ? In most cases the administrator account get's acccess through the BUILT-IN\Admins group. So you might have to change the default...

I'm afraid the only option you have is to break up the table into two. SQL Server only supports a max of 255 columns in trans. replication. (for merge it's...

quote:

---

why does it set this as default - is there a good reason?

---

No idea,...

You find samples on http://www.sqldts.com

or read this article http://www.databasejournal.com/features/mssql/article.php/2225481

If you're looking for free e-books checkout http://www.realtimepublishers.com/

Not so much about SQL but still very good stuff.

The reason for this is probably that you stop your server at night. SQL2K sets the recovery model for the msdb to simple at startup.

The way I solved it,...

While doing some more research and testing I discovered some interesting fact. If I change the order of the tables in my view definition the trigger works.

So instead of ...

Yes, SQL_Latin1_General_CP1_CI_AS is the best option for most Western European Countries and the US. Ok some prefer a case sensitive collation, but I would keep it standard.

How are you doing your backups.

My guess would be that your backups are executed under the security context of a login which doesn't have access to your database.

M

The main difference is basically that the local system account cannot access any resources on another machine. So ports from a shared network drive, backups to a network drive, using...

quote:

---

Are you sure it's not a problem with the Update statement

---

What's for sure in...

Try this

select MIN (intID),vchrCode,vchrDescription,lngValue from TableName

group by vchrCode,vchrdescription,lngvalue

HAVING COUNT(vchrCode)=1