Thanks Gail..!!

Thanks everyone for your valuable suggestions and comments....I will book a copy of the book from Amazon today and dig in to check where and how to start with...Thanks again!!

Thanks..

I will check with this condition and get back to let you know how it works now 🙂

Hi Gaz,

I am sorry I did not understand your question 🙁

My question is regarding maintenance plans wherein after changing password of a login, we have to manually reset the...

Hi Grant,

Thanks a Ton for pointing that out!!! My bad... 🙁

Cheers!!!

http://www.sqlservercentral.com/Forums/Topic644825-146-1.aspx

can you please refer the above Link for some hints for your issue..?

I know this is weird but I have faced situations where the Advanced tab of the jOb step had the option selected as :

On Success -> Quit the Job reporting...

If it is only one table, can you try using Transactional Replication to replicate this table data to some other table residing on another instance or wherever you want to...

Thanks Gail.. You are right.. This point in invalid since there is no backward compatibility for restore operations in sql server..

Thanks George for pointing that out..

Hi Grant,

I am trying to...

Hi Jeff,

Sorry to Jump in here but I was facing the same issue and thought of continuing on the thread.

I have a Stored procedure created in MAster DB which uses...

Yes. And I am also able to telnet my smtp port successfully from both these servers.

I am using anonymous authentication and have also tried using BAsic Authentication but it...

HI

To locate your Sql Server domain account, can you go to run -> type service.msc ?

You will have to check the name column to locate Sqlserver(MSSQLSERVER) service. There you can...

Hi All,

Although I couldn't understand the exact reason for this behaviour, I changed the datatype to nvarchar(MAX), but still it didn't work out.

Later, I used a variable to store...

Thanks for pointing that out Jack. I was sure that I was missing something!!

I have attached the trace textdata that I had captured which doesn't give me much of information...

Thanks for the reply Mike.

I will check this and get back to you today.