try this

select next_run_date,case when next_run_time < 100000 then '0' + cast(next_run_time as varchar) else cast(next_run_time as varchar) end as next_run_time

from msdb..sysjobschedules

thanks Bob for mirroring advice.

Let me explain you what i am doing here. For logshipping process, there is a requirement that both machines should have same administrator passwords in...

getting more drive space is not possible i have already raised this issue several times and they are...

Hi Gail

I tried with query you gave me but it didn't work. the error message i get is

Msg 4214, Level 16, State 1, Line 1

BACKUP LOG cannot be performed because...

reason is i am trying to use log shipping process which is custom designed. not using SQL server log shipping. there were couple of business decisions which forced to custom...

thanks krayknot. while i was waiting for the response i have created the test and it worked for me and your response gave me confidence that it would be right...

you can run query below for all numbers which are not having decimal.

create table #tmp

(id varchar(10))

insert into #tmp

select '10.10'

union select '1010'

union select '20.20'

union select '2020'

select *, cast(id as float)...

i usually run sql server on virtual servers for my development purposes.

will disk fragmentation on physical server help in increasing speed IO for virtual server?

Thanks Adrian. That link gave me a little insight of what is database forensics.

Even i was of the same opinion as you said, something related to breaches. But was...

Hi All

Thanks for your reply and solutions. Actually i was a big fool before posting this question onto forum, I should have double checked my problem. May be it was...

sorry forgot to gave more info. I am using SQL Server 2005 SP2.

Cheers

Thats true. But i...

check this

http://sql-server-performance.com/Community/forums/p/19021/107749.aspx

using a script

http://www.nigelrivett.net/DTS/s_LoadPackageToServer.html

also check whether SQL Agent service is running or not.

good question followed by interesting discussion. 🙂