This is SQL query that is getting executing in L1 (linked server).

DELETE a

FROM L2.dbname.dbo.Remote_Table1 a

WHERE a.ID = @ID

AND EXISTS

(SELECT b.invoiceId

FROM Local_Table1 b

INNER JOIN Local_Table2 c...

Thank you All.

This is SQL query that is getting executing in L1 (linked server).

DELETE a

FROM L2.dbname.dbo.Remote_Table1 a

WHERE a.ID = @ID

AND EXISTS ...

Hi,

The user is making asynchronize call to SSRS reports from webbrowser. And the call is just sending the parameters I mentioned to SSRS Reports, mean time the user can work...

Hi All,

Thank you so much for your valueable information.

Sri.

Hi,

No, its just in local system and I used windows account/sql server account to create linked server.

Thanks,

Sri.

Sort of...

Here the user should able to see the column (SSN) but the data should be hidden.

It that possible ?

Sri.

Hi Gail,

select name, is_read_only, is_auto_close_on, is_auto_shrink_on, is_in_standby, is_cleanly_shutdown, recovery_model, state_desc

from sys.databases where name = 'WORKSPACE'

Resultset:

WORKSPACE 0 0 0 0 0 3 ONLINE

The WORKSPACE database is not corrupted, it works fine once recovered 100%. Only thing...

Thanks Paul.

Inside log file I don't see the following messages for the available databases when I restart sql server service.

Example:

2008-08-24 15:10:57.07 spid3s ...

Yes frequently (1-6 times).

Finally I went to SQL Server (SQL Express) ---> properties --->

connections ---> Allow remote connection to this server = set to 0 (default 600).

Now I don't...

Check your database in which your stored procedure was running, set the auto_close option to false.

Good Luck!

Sri.

I don't use these functions in a set based queires, only used for verification purposes/pre-checks.

Thanks guys, thanks miller.

Sri.

Hi

Try this on database you are running queries.

alter database set AUTO_CLOSE OFF

Thank you so much for your valuable suggestions.

Final question:

There are lots of scenarios at my work where I have to use this type of code, so I wrote procedures instead...

Hi All,

This is one of the example code.

create table dbo.employee(ename nvarchar(32))

insert dbo.employee values('Sri')

insert dbo.employee values('Mike')

declare @tablename nvarchar(128), @column_name nvarchar(32), @value nvarchar(32)

declare @emp_status bit

select...

SET TRANSACTION isolation level SERIALIZABLE

begin transaction

if not exists(select [name] from workspace.sys.tables (UPDLOCK ) where [name] = 'sri')

begin

create table workspace.dbo.sri(empno int)

end

if @@error > 0

rollback transaction

else

commit transaction

Is this code looks...