Try using the "between" Operator.

For example in Pubs Database

select * from pubs..sales where ord_date between '1994-09-13 00:00:00.000' and '1994-09-14 00:00:00.000'

I am not sure if this always works, but could you try removing the print and select statements in the following code (for second SP)

WHILE ( @fetch_status2= 0)

BEGIN

select @cmplt_code

WHILE (@Month...

One workaround.

From your sp give a call to another sp in the target database and use sp_rename there.

/*sp in first database where column name...

Hi Simflex,

I have the multiple select statements which I have posted, you can easily club them via union if you want. So you get one select statement to put...

/*

Basically I have made a table (accident_info) of foll columns

id - Some Primary Key

Person_Name

Date_Time_of_Reporting - The TimeStamp when the accident was reported

Action_required - 1 Pending for Supervisor 2 Pending for...

See

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_07_5lpz.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_mon_perf_80kz.asp

Well going by the microsoft documentation, it seems that the profiler Tracks API based cursors and not TSQL based cursors.

If that is not the case, try using sp_cursor_list in a...