SYS.PROCESSES or SYSPROCESSES?

He can use roll up to get the bottom total too like below but I am not able to sort it right as he want based on Grandtotal.

SELECT [SlNo#] =...

You can not get your space back on that way.

The only way I know is that you have to restart SQL server services. But You really have to read...

Try to figure it out why you even can't ping that IP from command prompt.

If you can not ping it, SQL cannot validate it.

What does "want to keep 30 iterations of it" means?

You want to run it daily 30 times? Loop through it. Or save results of 30 iterations of job?

Have you tried restarting SQL with two trace flags as below.

SQLServr.exe –T3608 –T3609

Also here is an artcle from Gail Shaw which explains this in a really good way.

https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

If queries are running fine in Query analyzer but not in application, I suspect two things.

1) Parameter sniffing

2) Network latency

Try to work on these 2 things and see what you...

I think you should use Table Valued Parameter. The below link has examples in it too.

http://blog.sqlauthority.com/2008/08/31/sql-server-table-valued-parameters-in-sql-server-2008/

Have you even tried it? If yes, what values you have passed? Waittime is value passes in millisecond so you have to convert hours in ms.

The only way I know you can set up a replication by creating a snapshot or initialize with backup. In both cases you have to have the same schema...

Does the account/ SQL Server agent Service account has delete file permission on the server where job is set up?

Try logging in the folder with the account which is running...

Let me ask you one question. What I can see from your result that, once you get 'Trl' from Substring([Column 0], 4, 3), every thing else below that will be...

You can try deny CONTROL permission on the database or VIEW DEFINITION permission to role.

not sure, whether will work with db_owner or not.

Lowell, he has mentioned in first post that The primary key combination for the destination table is "ROBumber + ROTime" .

I was able to replicate exact same issue in my environment if the CTE name & name of table is same, so I do not see any reason that it...