Hi,

User who is only "only" db_owner of the master database cannot kill any process.

Kill statement requires membership in the sysadmin or processadmin fixed server roles.

Yes, this is possible.

Go to

LOGIN properties --> securables ---> click add ---> add objects SERVER ---> find view ANY DATABASE and mark DENY.

This is my only idea....

Maybe you need to use TOP clause?

Something like this...

select TOP 1 your_collumns...

from ....

where ....

It's my pleasure 😉

Hi,

Try with

sp_helplogins

sp_helpuser

In the mean time I resolved this issue...

Problem was with "no join predicate" which was the reason that compiling of procedure took about 30 minutes.

After I added hint (force...

[/quote]

How you can not be sure? Microsoft may be a large, hegemonic company, but they're not going to intentionally lie about something like this. If they say it's there, you...

Thank you for your effort I also find this on Microsoft site, but I am still not sure 🙂

Ok, I will be more carefull next time.

Sorry 🙂

This applies to both SQL 2000 and SQL 2005 I test it.

I agree with Jonathan, you are resolving problem on the wrong place 🙁

Hi Grant,

What about statistics which are not related with indexes?

🙂

If you wan't to execute query in some particular time you should look in BOL for WAIT FOR functions

Best regards,

What do you think with „schedule report“ ?

Hi,

Maybe this will help

http://blog.sqlauthority.com/2007/04/22/sql-server-fix-error-1418-microsoft-sql-server-the-server-network-address-can-not-be-reached-or-does-not-exist-check-the-network-address-name-and-reissue-the-command/