i used postresql for 18 months and loved it. the learning curve is minimal as long as your staff are keen to embrace something that isn't windoze.

totally agree with you...

thank you Jesper, that's exactly what we need.

i must have thries everything except that ! thanks again.

if you liked that wrapping it in sp_msforeachtable should save you some time ...

doesn't public just let you see the db is there ????

didn't think it granted any permisssions at all ?

So would you go for a key of a varchar(20) then and write a custom encoding sheme to enable it to be indexed quickly (as I believe the GUIDs in...

We need it to report other errors though.

Creating an application would be ideal but not in the environment we work in. Might be a way forward in the future though.

However,...

thanks for the link -

the problem relates to some code written by anotehr guy in the team so i've passed on your link -

the 1222 error is caught on...

http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp

I see what you mean.

I do kind of sympathise and do agree totally that keys should be part of the entity they represent but could see the argument become indefensible...

Hi Joe,

I was wondering what you meant by 'IDENTITY is both a proprietary data type and never a key; BIT is a proprietary data type;'

Would you not use an IDENTITY...

It might be able to see the memory but would not be able to use it without the switches.

You need to use the memory counters in perfmon if you want...

Indeed.

To the dark side poor design leads.

any ideas anyone ?

this is another classic example of programmers getting their hands on the data, brainstorming, and then coming up with a solution that probably fits their needs and they can rationalise...

not sure what you mean exactly but you could add the user as 'public' in the database and then grant them permissions against the table you want them to see...