OK Thanks. Ive got the user and hostname, Im no a DBA and the question is how to make them stop using profiler ?(Maybe denyng EXEC permissios to the...

thanks, well the system is sqlserver 2000

first, when monitoring active sessions when sp_who active was running ok, but suddenly i type that command once again and didnt respond and...

its a company procedure weve got to run daily at night for freeing up system resources

Good afternoon

According to the sentences you suggested me in the previous post aer working fine, but combined with the nes set of ommands ive got the same error:

select count(1), FECHA...

Verifyng the data supplied yesterday, ive got the say something.

Both fiels a.COD_DIM_CALENDARIO_FEC_TASACION and b.COD_DIM_CALENDARIO are int (integer) and the field FECHA is datetime and the format for this field is...

bots fileds are defined as datetime(8)

The server has 32 cores (Processors) and 100 GB. The configuration is good for the database server and its client.

Even though i restart the instance, but it doesn change.

What i...

yes, you`re right but I'd like to know if I could create a login using T-SQL or a store procedure , then granting permission on select statements and finally reverse...

ok, I tried and its working.

The only thing additional ive got to do is to create the Recordst Object, open it, then call the EOF method, thank you very much...

Good afternnon, thanks for your idea, but its a little bit confusing for me this expression:

i know the characret + is used to concatenate but the expression 'exec sp_spaceused '''

itself...

Adding to the description on this error message, this package sometimes works fine but sometimes failed with this message.

Does it happen with the settings options define in the stored procedure?

yes, I'm sure, because initially with sp_who displays all the inforamation with users, connection and processes, and i click right on this specific user (copy and paste this user as...

i tried it without success, and this is the user; otherwise the output would be

"The login 'TRAFICO\production' doesn exist', but it really exists

The problem is that in the resulset...