There is role named db_backUpOperator. You can assign the user you create to that role.

I dont know if this will help but

You could always give the user DDL rights. After that you can add the user to the DB_denyDataWriter role along with db_Datareader role.

That...

Why dont you use a hint (ReadUncommitted) in the Catch part to prevent blocking?

Open New Query window.

Use Midas;

Go

Select * from sys.all_objects

go

You can see all objects in sys.all_objects. It is view.

I might be completly off the base but I read somewhere that it has to do soemthing with the TCP Chimney is enabled on a Wondows 2003 SP 2 with...

Maybe you should try to look up sp_getapplock. I think that should help you with this issue.

There is no spool command like that you have in Oracle. You can save the result to a file.

Yes, when you are trying to update with the key it is useful.

USE MIDAS;

Go

select 'grant select on ' + name + ' to serviceuser' from dbo.sysobjects where OBJECTPROPERTY(id, N'IsUserTable') = 1

GO

I think that should work

Michael Valentine Jones (1/8/2008)

---

If he has access to create the tables in tempdb, setup a job that runs ever hour or so to delete them.

When his stuff starts failing, tell...

Why dont you try top and use derived query.

Select top 1 x from

(

SELECT X

FROM table

WHERE accepted = 0

GROUP BY X

ORDER BY COUNT(x) DESC) as a

I hope the application is not using the present owner as its user when accessing the DB. Then it might break depending on the code I guess..

As far as I know and the tests done with the profiler, it shouldnt e an issue. Except that it could drive you nuts...;)

Actually the fastest way would be to use UPSERT.

Update

set col2 = @par2

where Col1 = @par1

if @@rowcount = 0

insert into (Col1,Col2)

values

(@par1,@par2)

When you do a If...