Code: Select all
select 'grant exec on ' + 'sp_name' + ' to ' + su.name as granttext
from sysobjects so,
sysprotects sp,
sysusers su
where so.name = 'sp_name '
and sp.id = so.id
and su.uid = sp.uid
order by su.name Search found 2 matches
- 19.03.2014, 11:47
- Forum: 6.6 - stable
- Topic: Whats problem with this Query?
- Replies: 1
- Views: 1603
Re: Whats problem with this Query?
use this
- 19.03.2014, 11:31
- Forum: 6.6 - stable
- Topic: Multi Sybase-Database Connection
- Replies: 1
- Views: 1636
Multi Sybase-Database Connection
HI, I need to execute a query using two or more different database on the same saver or not. when execute the query this error message appear: "Table qualifier must be name of current database" this it's the query: SELECT t1.fld1, t1.fld2, t1.fld3, t2.fld6, t2.fld7 FROM DB1.dbo.table1 t1, ...