This is very urgent so appreciate if anyone can help on this.

Do you have old .mdf and .ldf files(not of the day when DB got corrupted)? you might have taken file backup on some storage.... so get it and save it...

Thanks GilaMonster. This is what I was looking for

Yes, I'm only looking for the process to upgrade and migrate system databases.

I want info like

1 - what all are the pre-requisites

2 - step-by-step process to accomplish.

3 -...

Thanks Vikas,

Hello,

Try to put Square Bracket around Question Mark.

like [?]

this might give you a break.....

Never mind, I got the reply.

The only reason is that on the first page i chose to run a common schedule for all the tasks. if i keep that option...

Hello Wesley,

I'm using SQL 2005 and didn't find ' master.dbo.sysxlogins'. please suggest how to go about it.

in SQL 2000 we do see this table. Thanks in advance.

Also, please share a...

Hello Steeve,

I didn't make statements ...those all were questions..sorry for not putting questions marks.... 🙂

I just wanna know if i can see, who actually took the database offline in SQL...

Hello Judy,

It seems that you have already checked all the possibilities. however, just wanna remind you about PAE as well. Try to change that as well you might see a...

Hello Waseem,

you can use Opendatasource command (T-SQL)if you don't wanna use linked server.

using Opendatasource you can create an adhoc connectivity whenever you execute that code.

for more information you can check...

Thank you very much Ramesh,

That answers all my questions.... 😛

Thanks for the reply Ramesh, However, i know it is for SQL to understand that it's gonna be a Unicode value....

that's my question actually that.... why do we need to...

Hello Ching,

not sure which of the files is taking space... is it .mdf, .ldf or both?

Also, if you can tell me the growth rate.....

Please reply so that i can...

Hi,

Please check if 'On success action' it says -'Quit the job reporting Failure'

By mistake if you have choosen it then also you might see this job saying -- Failed where...