You're welcome to disagree, but Profiler's deprecated and Extended Events are far better, lighter weight, more configurable and new events aren't...

I never said that.

What I said was that there is no...

No, the error means exactly what it says. At the time the login was attempted, the database WorkflowPersistence was not available.

A common cause of this is having auto_close set on...

Tried the documentation?

https://msdn.microsoft.com/en-us/library/ms151198.aspx

You shouldn't be using Profiler in SQL 2014 anyway. Use Extended Events, Lighter-weight, far more powerful and you can convert any profiler-based analysis to extended events trivially.

Replace the CREATE TABLE with DECLARE, then change the name in every place it's referenced.

Be aware that table variables may result in the query performance degrading due to the lack...

As the error says, the index had had page level locking disabled on it, via an ALTER INDEX statement.

You can either enable page level locking or switch to rebuilding the...

Sounds like normal behaviour,

When you want to restore a full and differential, the full has to be restored WITH NORECOVERY, which leaves it in the RESTORING state. Then you restore...

Ok, now that I have some time to sit and look at this all.

Despite the huge number of rows in the output, there's only two errors there. Whatever that table...

Ok, let's try this

INSERT INTO Cars (CarID, Make, Model)

VALUES (1, 'Opel', 'Corsa'), (2, 'VW','Polo'), (3, 'BMW', 'Z4')

INSERT INTO CarOwners (OwnerID, CarID, Owner, EndDate)

VALUES (1,1,'Pam','2014-02-15'), (2,1,'Bob', '2015-10-25'), (3,2,'Sam', '2016-01-01'), (4,1,'John','2016-02-29'), (5,3,'Mark',...

Yes, we get that you don't want to see Verbruggen and you do want to see Hollewegens, but what we're asking is what values of columns determine that Hollewegens is...

Deprecated doesn't mean 'not supported'. It means that it will be removed in a future version.

tony28 (3/3/2016)

---

GilaMonster (3/3/2016)

---

What defines Hollewegens as the user you want to see?

To write a query we need a method to determine which user should be shown, based on columns in...

What defines Hollewegens as the user you want to see?

To write a query we need a method to determine which user should be shown, based on columns in the User...

Cool, and what determines the user that you want to see? for each car?

The one with 1900-01-01?

The one with the highest Enddate?

The one with the lowest Enddate?

Something else?