SQLPRODDBA

Thanks @ypercubeᵀᴹ. I'll check the article.

and because it had single quotes at execute(@sql) it was not forming the proper string.

my actual replication data had issues because of the details I gave above.

@Mailtext is a combination of my HTML header + actual replication data and HTML footer.

I am doing this.

I was stupid, I couldn't figure out how to replace it. But thank you guys!

I replaced it and now it is working fine.

so I my query I wanted to replace single quotes with two single quotes so that it can execute it.

I am getting this status using replication system procs and sending it as an HTML report via exec(@sql)

The distribution agent failed to create temporary files in 'C:\Program Files\Microsoft SQL Server\100\COM' directory. System returned errorcode 5. (Source: MSSQL_REPL, Error number: MSSQL_REPL21100)

I have a script to monitor replication and today I encountered below error in my replication.

@dezso: Thank you! That fixed it for me.

for example replace 'C:\Test' with ''C:\Test''. Please note that I need to replace it with two single quotes and not double quotes. I know its weird. I wasn't able to make it work using replace and need your help.

Can someone please help me with how do I replace single quote with two single quotes in SQL Server?

Hello experts

If you have the copy of mdf file put it on correct location and try to bring DB online. Otherwise restoring the DB is the only option you have to bring the DB online.

Thats the issue. When you OFFLINE the DB it releases file locks from DB files. So there are chances that someone may have deleted it.

Does the database files(mdf and ldf) exist on your local disk? You can check the file locations from sysaltfiles for that DB.

It was nice I could catch you up on chat and get it clarified. Updating details in the form of question is sometimes not that useful.

Thanks once again! You rock!

will upvote and accept your answer in few mins.

I appreciate your assistance.

great! I think I am clear now.

ok and for example I have login test which is non sa, and if the job is owned by that test login it will be executed in context of test. Right?

sa

So for my update which is T-SQL it will use SQL agent account and again this internally uses 'NT SERVICE\SQLSERVERAGENT' account. Am I right?

Regarding my 2nd question, what user/login it uses in case of my update job with sa as job owner and non sa job owner?

Thank you!

ok. If that's the case then it answers my first question.

I saw your edit. Do you mean even if you configure SQL Server agent service to use domain account but it internally it still uses NT SERVICE\SQLSERVERAGENT to login to SQL Server and do all its activities?

I want to discuss with you on my question SQL Server agent job question

Hello SqlWorldWide

Have a good day! Bye!

add any comments if you want.

Upvote/accept if you think it was helpful.

I posted an answer.

Since it was default* service account ..

Since it was service account I asked you to give FULL permissions to everyone. However in real PROD cases it is generally configured using Domain account. So in that case you only need to grant rights to that domain account.

that is because you used default system accounts to install SQL Server.

then search SQL Server services there. There you need to check LogOn As account. That is what you need.

go to run and type services.msc

There are two ways one using config manger and other using services.msc.

I didn't know that opening and closing master key was required. Lot of articles on web suggests without doing that.

great!

Restore?

cool!

Certificate created?

ok. So did it finally work?