With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
SELECT c.session_id as "session id", c.name, c.properties as "The cursor properties", c.creation_time as "Cursor creation time", c.is_open as "is the Cursor opened" , t.text as "The SQL Query" FROM sys.dm_exec_cursors (54) c CROSS APPLY sys.dm_exec_sql_text (c.sql_handle) t
SELECT @Cursor_SessionID = c.session_id, @Cursor_Name= c.name, @Cursor_Pro = c.properties, @Cursor_CreationTime = c.creation_time, c.is_open as "is the Cursor opened" , @Cursor_query= t.text FROM sys.dm_exec_cursors (@spid) c CROSS APPLY sys.dm_exec_sql_text (c.sql_handle) t
DECLARE db_cursor CURSOR FOR SELECT spid, loginame, program_name, hostname as "From host", login_time, last_batch, DB_NAME(dbid) AS "Against database" , (SELECT text FROM sys.dm_exec_sql_text(sql_handle))as "Query executed" FROM master..sysprocesses WHERE loginame= 'ixapi' and open_tran > 0 and DATEDIFF (minute, login_time, GETDATE()) > @Total_time_Executed ;
|why does some in the xx field return as null? Case statement||2||21|
|Early & clean exit from a maintenance plan (T-SQL Execution task)||5||17|
|I am using SQL Server 2008. Is there a way to pass in 2 parameters strings in the format MM/DD/YYYY and convert these strings into a DATE data type using SQL Server 2008 and then make a date compare?||3||13|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!