Hi there. I have a stored procedure that collects data modified in the past day. This is put into a temp table. Then a while (1=1) loop is...
Good day everyone. I once again need advice on, what is to me a very irritating change request. We have the current scenario: We have a value (let's...
Nope, once everything is set up properly there won't be changes taking place often regarding the tables that are monitored. How would I set that job...
Hi there. They want it to run about every 15 minutes or so as it is a very busy OLTP system.
Hi there, all. I have written a stored procedure that merges table from one table into another table. As input parameters it accepts...
Hi there. all. I've been assigned a change request asking me to add a bit field to a few views but only to the views. My question is if this field...
I'm not sure I understand your question correctly. I have sufficient permissions to run this as I tested it with 100% success on our Development...
Thank you so much for your response, I'll definitely follow this up.
Hi there all I am wondering if someone could help me or perhaps point me in the right direction. My manager gave me a script where it compares...
Thank you kindly! I'm definitely going to give this a try.
Thank you so much for your help!
Hi there all. I have a question again, this time regarding creating a script(s) that could be used throughout all servers. We want a script that...
I have a really stupid question to ask. My manager needs to know the minimum permissions required for a user to be able to backup the database. He...
Hi there all. I have a problem with an update statement. The error we're getting starts with "UPDATE is not allowed because the statement updates...
Thanks to both of you. I'll be saving both and have managed to, with the help of some helpful folks, impress my boss and change the levels on our...
I think this is exactly what I was looking for! Right now you might be a total stranger, but to me you are a hero! I will test this and give...
What I meant to say was that the read-only databases should be excluded from the compatibility update.
They have now added another small complicatoin. There are servers which have read-only databases. I need to cater for those databases as well.
Upon some more investigation I came up with this:/****************************************************** Procedure ChangeCmptLevel.sql Purpose...
Hi there all. I've been tasked with writing a script where I iterate through sys.sysdatabases to find all databases with a compatibility level not...
Separate names with a comma.
