just tried it on my local instance with the full sample data that we have been provided so far for the project

Values lists total execution time 51ms

Unpivot total execution time...

Thanks guys, much appreciated. Was racking the brain yesterday on that and for the life of me couldnt get unpivot working.

I like the idea of the values list, never...

Performing a log backup will make the log as re-usable, allowing the already allocated space to be re-used.

Log backups do not affect the differential backup.

It will contain all changes since the Full backup

So, If you backup FULL at 1am, then DIFF at 5am, 9am, 1pm, 5pm, 9pm.

To restore at 7pm, you need Full at...

Thanks Ian, now this just gets stranger, all drives are a 512 sector, which according to the connect articles shouldnt cause an issue with reading the default trace.

You will need...

Have you checked the query and the syntax for sp_executesql?

You could also just add a new column with the BIGINT datatype, then issue a drop column for the text and sp_rename for the bigint column, saves dropping & recreating...

The SSRS Log is stored where ever SSRS is installed.

Do you have remote errors enabled? If not I would enable it, re-run the report and get the full error...

But the table has an identity column so you dont need to do the row_number() + 5.

If it didnt have an identity and you dont have an identity on the...

forgive my ignorance but do you know how to use the drill through to actually see what causes the alerts? if so should of got the tsql in question...

Without something which logs the two sessions statements you cant.

How did it alert you that the sessions where blocking? Do you have some monitoring software installed?

whats the definition of the source table?

First find out what SPID63 is doing, is it inside a transaction which hasnt been committed

select * from sys.dm_exec_requests

cross apply sys.dm_exec_sql_text(sql_handle)

cross apply sys.dm_exec_query_plan(plan_handle)

where session_id = 63

http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ chapter 6

Sounds like you need to do port forwarding, so when I packet comes into your router for port 1433 it knows to pass it to the LAN IP of 192.168.0.10...