If you want it to be part of the same records, you can replace the commas with char(10) + char(13). If you want it to be different records, you...

Yes you can, but you don't have to take my word for it. You can test it on your own by running your maintenance procedure on a test database...

I’m not so sure that synonyms affect performance. Can you share a bit more about it? I’ve used synonyms few times when I had more then one environment...

Check with the IT department if they modified the firewall settings.

Adi

Take a look at triggers. It seems to be what you are looking for.

Adi

Any session ID less then 51 is not a user session. Since you are trying to kill session number 19, you are trying to kill a system session that...

You need to delete the BoatingWarning that you wrote in the last line just before the FOR XML. By the way, there are many ways to get it as...

I think that what you misunderstand is that the 2 dots and slash (../) symbol is actually for going up one level and not going down one level (like the...

You have to show us the XML that you work with. In your question you reference an XML file that has some elements that don't exist in the XML...

Do you have a transaction in your code? From what you wrote you didn’t start a transaction at both versions, so in the first version after the select...

I couldn’t find some of the elements that you wrote about in the XML that was in your message, but my guess is that the problem that you had was...

Here is one way of doing so, but I have to admit that I don’t like to use an output parameter and pass values to it into the procedure. ...

Is that server is dedicated to a single instance of SQL Server or is it used to by other instances of SQL Server or other servers/services/applications that need memory? ...

Your question is not very clear. Next time instead of writing the rows please write a small script that creates the table and inserts the data and also explain...

Only if you have a backup.

Adi