Just want to point out that requesting a teams meeting with complete strangers on a forum because you are having trouble with a report is a very uncommon thing to...

SQL jobs run as the SQL agent service account. It does NOT run as "sa". That is why you are getting the error. You will notice the error does NOT...

Sorry for the double post, but I just wanted to add it was a good article. I enjoyed reading it and my reply wasn't saying "don't use ORM's", it was...

What about joining on sys.objects? You could join on the OBJECT_ID(msarticles.name) = objects.object_id from objects and you should be good to go, right?

That would allow to filter out the object...

If you want to exclude something that is a row, you would need to update the WHERE clause to exclude the data you don't need. If you are trying to...

Login failed means that the account that it is running as doesn't have access to that database. In the error it lists who it is running as (LCDOM100\LCISQL##) and what...

My opinion is a bit biased as I am a DBA as well as a DB Developer (and other roles), but I have not found an ORM that works well...

The service has no access to the network share. The ONLY solutions are to switch it to an account that has access OR store the backup files locally and manually...

My opinion - data cleansing is important to most, if not all, databases. Ideally you have the DB structures set up to prevent garbage from going in, but if garbage...

I am thinking Jeff is probably right - some app is opening a connection and not terminating it when it is done. So you are getting TONS of connections and...

Heh, I don't mind being called "Brain", but I do agree with Phil here. I may sometimes have some good answers, but I have also been way out to lunch...

Have you tried the stored procedure "sp_depends"? Not always giving the correct results, but it is one option.

Pinal Dave has a good post on this:

https://blog.sqlauthority.com/2010/02/04/sql-server-get-the-list-of-object-dependencies-sp_depends-and-information_schema-routines-and-sys-dm_sql_referencing_entities/

The method he recommends is to...

Just a heads up vs.satheesh - if you EDIT your post, nobody gets notified. So to Phil's, you haven't answered his question yet even though you updated the original post....

I can think of a few ways to do this and I think the easiest is to grab the MAX(RefNum) into a variable and then use ROW_NUMBER in your INSERT...

I would start by reviewing the logs. Check the SQL logs and windows logs during that period as one of the logs will have something that will tell you where...