My fault but

that was just for an example.

See Dyanmic Sql is used where we dont want to hard code the values in

our query.

For example if we wan to run this command against a database

than

Create procedure dynamic_query(

@dbname...

Problem may be there in your cursor any one of them

may be going into a infinite loop

thats why the cpu usage may be high all the time

due to...

Stuff will do the trick

refer to this link for more information

http://msdn.microsoft.com/en-us/library/ms188043.aspx

Sorry my fault

for sysadmin permission it does not search for Drive that are available on my

organisations network but for SQLAgentOperatorrole it searches for drives on my network.

Thanks

i have run profiler for sqlagentoperatorrole it is searching through all the drives available on the networkbut for ssisadmin it leaves the network drive

any method to restrict this.

hey John its still taking the time but this does not happen when

i give the user sysadmin permission but i dnt want user to have this permission.

hey john

plz help for the issue

the permissions that user have are

db_ssisadmin

db_owner

Sqlagentoperatorrole

sqlagentreaderrole

sqlagentuserrole

Hi John

but this does not happen when user have sysadmin permission

but without this it takes time

SELECT

COUNT(dbid) as TotalConnections

FROM

sys.sysprocesses

WHERE

dbid > 0

If more information is required

use

sp_who2 'ACTIVE'

While most queries which employ CROSS APPLY can be rewritten using an INNER JOIN, CROSS APPLY can yield better execution plan and better performance, since it can limit the set...

—- To enable the feature.

EXEC sp_configure ‘xp_cmdshell’, 1

GO

—- To update the currently configured value for this feature.

RECONFIGURE

GO

Check if this works for you.

See you can use the substring function to break the int value into time

or into the format you want have I think this will do the trick .

you can use the procedure to first have the list of students

absent in a particular department and then use the procedure

sp_send_dbmail to send the list of absentees in the...