Gail, There is no replication for sure but we had enabled CDC which I have disabled now. There is a client process which create database snapshot twice a week, do...

Gail, I appreciate your quick response to help me but I will prefer not to do such kind of big changes in production database for testing. Can you suggest any...

Hello Respected Team, I have a issue:

-Production database log file has grown 120GB

-I have hourly log backups running but even than log file is not getting truncate and shrink

-I saw...

Thank you very much, I got the same issue and fixed it with you guys help here.

Thank you very much every one, it has been resolved.

Just to share the solution:

The issue was the mismatch of directory folder. Under SQL Server properties the folder name for...

Thanks for quick reply, but i dont want to change password for all users, only for select users, i have around 200 user but want to change only of around...

Yes,You are right,I called microsoft and got the same answere.Thanks for your reply.

Irfan

Can you please send me email at tranwayc@gmail.com and course outline you will cover in 70 hour traning.

Thanks

Irfan

But why it was not happened before,I am doing this procedure since last year.Is it due to upgrade or it is due to link server?

Thank you steve and Thank you GilaMonster too for both of yours time and advise.

Irfan

You are right GailMonster,I should,t go for this project if i dont have rigt hands on experience.

as a question is this part comes in DBAs responsibilities or in Developers responsibilities?

Thanks

Irfan

GilaMonster,Thanks for your answers and answere for your question that is this a homework?

No,it is not home work,actually i am going to start another job/project and in that coming project...

I am still smiling with your comments.............Would you like fries with that?

:)))

Thanks and i dont mind because you were right 🙂

I am sorry If i have asked more than i should.I just want a step by step documentation to how to design and develop database.I know i will have to...

Calvo,Thank very much for nice clarification with practical example.

Calvo or Anybody please,

If you have time can you please also explain to me clustered and no-clusterd index and their difference,If you...