Please provide the full DDL and sample data along with your expceted results so we can assit you better.

Please see the first link in my signature for more info.

damn that was fast

create table #temp (x char(1), y char(1))

insert into #temp values ('a','b')

insert into #temp values ('a','b')

insert into #temp values ('a','c')

insert into #temp values ('a','c')

insert into #temp values ('a','c')

select row_number() over(partition by...

Nope, thankfully since I have moved on from the old position...

here is another link as well, this one is a bit more printer friendly

http://www.simple-talk.com/sql/sql-training/ssms-the-query-window-keyboard-shortcuts/

how do you determin that the session is closed?

are you sure its just not SQL reassigning the SPID to a different connection?

is the user MODERN\saaz a member of the local administrators group on the server?

Yeah it is a pain to get your head around, I had to do a full VMware ESX and SQL compliance project at the old place as they where very...

to add on from Gail's post, you haven't been doing regular TX log backups.

you now have a number of choices

backup the log to a new 2TB drive, shrink the log...

if you shrink by query or by job the syntax is the same, you just put a t-sql job step in and give it the t-sql.

DBCC SHRINKFILE(1,100) in a query...

is there a particular reason you cant use while loops or cursors?

How big is your TX log? 2TB? Or is the drive it is located on full?

run the following and return the results

select name, log_reuse_wait_desc, recovery_model_desc from sys.databases where name =...

first of all your DDL script is not complete, you reference a column in #temp called tax_ref_id which you have not defined and a variable called @tax_ref_id which again you...

Are you going down the route of each developer will have their own machine which have Hyper-V with a load of VM's SQL Visual Studio etc, or will it be...

Use the MAXAGE switch in robocopy and give it a values, eg 7 for 7 days,

This is the URL I use for robocopy switches

http://ss64.com/nt/robocopy.html