Even if you execute it like this?

exec RetrievePermissions 'myUser', '',0

Thanks a lot! This makes perfect sense.

OOPS 🙂

Sorry wrong syntax

SET IDENTITY_INSERT manu ON

Yes,

Use SET INSERT_IDENTITY manu ON

You have to specify the column names on your insert statement.

Use SET INSERT_IDENTITY manu ON

Insert into manu (col1, col2)

Values (1, 999)

Hi Phil

Why do you need to find the full domain name in order to grant permissions?

If the DBA compiles your script, will he not be on a session...

Of course it will not work. You are not updating the table, you care updating a variable

UPDATE CSTerms

SET @stringval=inserted.AmdRead

...

Or you can create a table in tempdb. The table will be dropped when the instance is restarted.

CREATE TABLE Amendment (idcol int identity, descript varchar(30), value varchar(30))

go

CREATE TABLE CSTerms (idcol int identity, col1 varchar(30), col2 varchar(30), col3 varchar(30))

go

INSERT INTO CSTerms values ('', '','')

go

CREATE TRIGGER t_Amendment

ON...

Hi Oleg

Thanks for the response. I did not take offline dbs into account. I have added that now and you can test it on your databases as soon...

Hi David

I dont think your suggestion will work though, since the 'use database' will not actually switch the database, you need to put 'go' after the use part and...

You can always just select out from sysobjects. It will display all the objects in the db you are currently in. The xtype indicates whether it is a...

Not much detail, but this might help.

sp_msforeachdb 'select ''?'',name from ?.dbo.sysobjects where name like ''storeprocname'' and xtype = ''P'''

Thanks everyone for your replies. I managed to solve my problem.

BTW. What would your preference be - xp_cmdshell BCP or BULK INSERT? With BULK INSERT...

thanks. Yeah - although it is not guaranteed, at least it gives me a rough list of some tables I might be looking at. Do you think I...

Thanks Sergiy

Do you know when exactly when the object will be inserted into sysdepends? The following select gives me more or less what i want for the usertables, but...