Complete stab in the dark, that what you are looking at is some kind of table with 5 rows and based on what can be seen, and assuming it is...

Good question thanks Steve, very similar to one not long ago me thinks...?

GilaMonster (7/21/2016)

---

Shahin (7/21/2016)

---

De datbase has a table that calls LoginRecords and there I can see when users login and logout.

So I think I should be able to run a query...

Humble

Direction

The sp was created with the WITH ENCRYPTION option, if you are lucky someone will tell you where the original script is stored; there may be good reason the WITH...

Check that for all columns in the catalog, track changes is set to Automatic rather than Manual or Do Not Track,

Secondly, for the index set up a schedule, if one...

Good question, thanks Steve, did have to look it up so learnt something.

Have not actually done this but I believe you need to backup the database to Azure, which is a URL backup and which requires a storage account. HTH.

Before anyone shouts...

Gone mad!!

Thanks Steve, easy one to end the week on.

Capture

Why do you need a trigger to do this? Simply put a default constraint on the column.

Police

I would suggest Microsoft Virtual Academy, the site has changed and now leans towards certification. This is a personal choice and no doubt others will have excellent suggestions for resources,...