can i go doing both and

should i go for certification

thanks for the replies

i want to earn a lot of money and i enjoy new tasks and just want grow my learning

i like writing sql queries and all the...

thanks for the same i too thought that

it not possible to find without any tracing or auditing feature turned own.

You can try creating temporary table in your procedure

where all the information for sp_who will be stored so that we can

get the information from the table as you...

thanks for the link i was searching for the same ..

you can use DMV

sys.dm_os_performance_counters

to find the locks

beside this other things like

sp_lock

master..sysprocesses can also help in the context

this link might be useful for you

https://www.simple-talk.com/sql/database-administration/the-dba-as-detective-troubleshooting-locking-and-blocking/

it think the way you have written the query is not right

case statement should be the part of the expression

in your case you can use case like this

select...

beside this you can also create a procedure

to backup and restore a database where you can

take various parameters like path in your case

SELECT TOP(100) [text], cp.size_in_bytes

FROM sys.dm_exec_cached_plans AS cp

CROSS APPLY sys.dm_exec_sql_text(plan_handle)

WHERE cp.cacheobjtype = N'Compiled Plan'

AND cp.objtype = N'Adhoc'

AND cp.usecounts = 1

ORDER BY cp.size_in_bytes DESC;

this query might help you

you should first check the dependencies for the particular object

by sp_depends

or by sys.dm_sql_referencing_entities ('OBJECT', 'OBJECT');

then you can modify your object in a more appropriate way

the statement in the true clause will only

executed

Hey this happens sometime .

You can use

sysfiles to come up with a procedure

where you can get notification for your database growth.

I think that your the problem is with your table structure

as error is for table and you can see the status of sysmail_mailtiems

it shouldn't be 1 as 1 is for...

You need to close cursor and

de allocate it to make it functional

and not come up with an error.