Aspet Golestanian Namagerdi (11/4/2008)

I have query that ,when I try to run it, takes a very long time. But during the runtime if I cancel the running of that...

I don't think the OP want's the SQL Server user. He want's the application user, which is passed through to the stored procedure as a parameter.

I might be wrong...

The problem is in the view, where you're selecting from the table where the StaffNo is null. This will return values prior to the position being filled, which you...

If you're already using stored procedures why don't you skip the use of triggers and just add your auditing code into the body of the stored procedure? In that...

The insert statement takes ten seconds and this is being run inside the cursor 1000 times. I think it's pretty clear that it is the cursor that is your...

Are you sure you're looking at the right counter in perfmon and that you're alerting on the right counter?

There's the SQLServer:CacheManager\Cache Hit Ratio and the SQLServer:BufferManager\Buffer Cache hit ratio?

Unfortunately this isn't possible. If the person logged onto the SQL Server has the correct permissions they can attach a database and you cannot prevent it.

Ok, so what are you trying to do? Are you trying to prevent someone from attaching a database, or are you trying to provide security for a newly attached...

Well, if you attached a database from another server then obviously the database wasn't secure. If it had been secure then you wouldn't have been able to get it...

Don't give anyone CREATE DATABASE permissions - and then no one will be able to attach a database.

But for anyone that has got sufficient permissions you cannot prevent a database...

sys.sql_dependencies is only available in SQL 2005 so you're stuck with sp_depends in SQL 2000.

I think the problem here might be that you're converting to varchar, and then SQL Server tries to implicitly convert that varchar values to datetimes.

Try and convert them to datetime...

sp_lock will give you information about the locked row (if indeed a row is locked).

If there's a row lock the Type column will display RID and the Resource column will...

To be honest you're already on the right track. You're ultimately going to have to talk to the person/people that know the most about the system in order to...

Check out the stored procedure sp_depends and the dmv sys.sql_dependencies in BOL.

And make sure to read up on its limitations.