sorry for confusion. here is what the column looks like.

22 Hrs : 34 Mins

16 Hrs : 34 Mins

8 Hrs : 35 Mins

0 Hrs : 36 Mins

Now i need to put...

I did something similar.. thanks a lotwhere cast((datediff (ss,BatchStartTime,BatchEndTime)) as decimal(8,0))/60.0 > 120

Yes its all resolved now. I connecttion string in the datasource was not correct.

Ok I have just figured out a work around for that as well. I have not chosen a data source in the report manager. Instead I have used the datasource...

I mean I build the report in the same server where the SSRS Configuration manager is set up. And in the Visual studio, I'm able to view the report preview...

OK I resolved this issue. I'm able to open the Report manager URl now.

But when I try to open the reports in it says Invalid Object name 'My Table...

Great!!! this thing works. Now all I want is below 2 things. If its possible..

1) Get the Login time as of the column (If possible. Not necessary though)

2) have...

I have 2 quick questions on Data file size usage behavior

1) I see that Indexes have heavy fragmentation levels: This effects the DML Performance for sure, but will...

Hi Gail,

I have quick question here. What if the Log_resuse_wait_desc is in replication state for 1 whole day and the log file size is 500 GB and not...

Hi all.

Appreciate your support here.

This is resoled now. I created a new linked server for the same server now with alias.

now I kicked off the job remotely and it...

I used TK5BITOOLSVM01 for both the queries.

The first query returned with the account name as expected.

2nd query did not give any results. Looks like I',m not able to access...

thanks . Below is the result when i ran it remotely using linked server.

EXEC('SELECT ORIGINAL_LOGIN() as logged_in_login;') AT [LocalServerName];

Result: REDMOND\Mycredential

EXEC('SELECT * FROM msdb.dbo.sysjobs WHERE name = ''22274680-BFBF-4191-913E-40491393C490'';') AT [TK5BITOOLSVM01]:

This query...

thanks . Below is the update.

EXEC('SELECT ORIGINAL_LOGIN() as logged_in_login;') AT [LocalServerName];

Result: REDMOND\Mycredential

EXEC('SELECT * FROM msdb.dbo.sysjobs WHERE name = ''22274680-BFBF-4191-913E-40491393C490'';') AT [TK5BITOOLSVM01]:

This query return 0 records. Job is not visible.

But...

Thanks Rob..Is there a way to that user selects a date in the top filter and in the respective WQ.WorkQueueRunGroupRunID assigned to that date gets selected in the where clause.????

I...

I just fired your query locally ad removed Linked server from the equation. The script ran in fraction of second and the subscription job got kicked off successfully.

So its not...