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...

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...

My opinion - this is not a SQL related question, but a WFC related question, so you will get better results from looking on a WFC related forum. Now that...

My opinion - I wouldn't do this. The reason, lets say this scenario comes up:

User A is doing a massive update on a table and it will take 35 minutes...

If I remember right, the BEST way to do the inserts is by inserting at the END of the index. So if your data is ordered by the clustered index,...

You say he won't be updating, but is it because he lacks permissions OR because he promised he wouldn't?

I would make sure your backups are good too. You do NOT...

Best guess - BigQuery is not expecting a column list in your CTE. BUT BigQuery is NOT the same thing as SQL Server 2022... You will likely get better results...

My opinion - if an end user is connecting to a DB using SSMS that isn't a DB Developer or DBA, they should only connect to the TEST system, not...

for question 1, I personally don't see the point. The windows event log has all that data, so why bother moving it to a new location PLUS you would need...

Another question - how many schedules do you have on the job right now? If you have more than 1, it could be that one of the other schedules is...

Are you expecting it to run today? if not, then set the start date to the date you want things to run.