Faceplant emoji...

I was updating the SQL native client driver on the database server not the web server (client)...a few wasted hours there!

I've solved this by using two sub queries and a join on PEOPLE and THINGS and then only pulling out the ones where the right have subquery/table (the existing rows)...

Thanks for the reply, I dont think this will help me in this instance as the except operator will be affected by the two sets on in clauses just the...

Thank you that works on the test data, I'll give it some real world examples.
I really need to learn more about the over by clause!

Rolf

Hi there,
Something like this,

SESSIONNAME, SLOTNUMBER, FULL, PERSON
First session, 1, 1, First Person
First session, 2, 1, Second Person
First session, 3, 1, Third Person
First session,...

Hi there,

thanks for taking the time to reply.

Creating lots of views for each possible table structure for each application is probably more work than what I...

Of course what an idiot..groupby..I started off with trying to get a boolean value (which wouldnt work with groupby) then switched to just getting a total but forgot I could...

Thanks...it was really to stop people who can and should be restoring databases from making a silly mistake..ie introducing some fences and hoops to make sure they really do want...

Spoke to soon.

Now I get two backups showing in the MSSQL history..one with a proper filename but no transaction logs available and one with a blank filename with a transaction...

Thank you all for the help, you were spot on.

I went and checked the backup task on the HyperV host and changed the VSS option to full VSS backup...this is...

Checekd the logs and I have frozen IO errors assocaited with backups..

2016-09-14 04:01:22.14 spid51 I/O is frozen on database model. No user action is required. However, if I/O is not...

I think there is some confusion here.

There are NO third party backups being taken within the SQL server virtual machine.

I create a new backup task

Add it to SQL server agent

It...

Hi all,

Thanks for the reply.

There is a windows backup copy running on the Hyper V host that takes a VSS backup of the Hyper V virtual machines..including the database server.

Can...