>>I guess you could create a trigger on syscomments and  ... <<

Triggers on system tables are not ... Ermm ... supported

And beware that you may get many "unwanted" things with this.

• Useless Indexes.
• Poor Performance
• Difficult to maintain
• Very limited ability in querying

etc ...

Cheers!

For remote Administration I'd rather grant RDP rights to a very limited account and use a non standard port for it

Cheers!

And just for the fun of it MS ACCESS can handle dBase III file import in to SQL Server 2000 very nicely

Yeah, he picked the slower one <pun intended>

Here you go:

happy to help

select *

from tblpart left outer join tblorg on tblpart.orgid = tblorg.orgid

where (tblorg.catid = @varCat or  @varCat is null )

Just keep in mind that you may get Table Scans with...

The solution is the Key-Table method

You can create a table with the following structure:

Create Table Allkeys (

TableName varchar(128) PRIMARY KEY,

Key int default(0)

)

and you will have a procedure like

create proc LastKey (@Tname varchar(128),...

Coming from a place where unions never worked (is there such a place where they actually did ? ) I am openly AGAINST them in any form or fashion. It...

Hex numbers are made up of digits '0123456789ABCDEF' and as you can see D is in that set

0D830 (hex) = 55344 (decimal)

Cheers!

the error message is pretty clear:

User does not have permission to alter database ...

Your login needs to have enough permitions to perform this task! (which it doesn't now

can you post the definition of : ft_work.dbo.rp_work

YES!

Sure!

That's how we all learn