Your sample data does NOT contain any records that are valid for the selection between today and the upcoming two months. The EOMONTH function will return March 31st as date,...

The error mentions the missing permission: VIEW SERVER STATE

This required permission is on the instance level. Your trigger is executing as the 'dbo' and this has only permissions within the...

Andrew G (1/7/2016)

---

In msdb.dbo.sysjobactivity there is a run_requested_source column. That will tell you if a schedule or a user executed a job.

Values are documented here: https://msdn.microsoft.com/en-us/library/ms190484.aspx

If a user, check...

Hi,

I don't know from your post if you refer to jobs of the SQL agent. If so, you can query the code inside the jobsteps with the code below:

select job.name,...

Hi,

When performance is (slowly) dropping, you'll hardly find any information in any of the Windows or SQL logs. Entries in these logs are more related to (succesful or failed) events...

Thanks for the update. This could be helpfull if others end up reading this thread. 😉

andrei.vizitiu (9/4/2015)

---

The RDP works fine. On the server itself there are no issues. All SQL instances can be accessed ok.

As for the resource allocation the main machine has dynamic allocation...

Because it is all implicit conversion here. First you devide the integer 15 by 24. As being all integers this results in a integer being 0. And converting 0 to...

In my opinion this is all depending on maintenance, complexity and dependencies.

Having small tasks each in seperate packages it's easy to execute a single one (if required) and it's easy...

BTW: it is bad practice to actively use the SA account. This account...

This is hard to pinpoint due to the infrequent behaviour, but I suspect it is a general performance issue.

Because it is all on a virtual machine the performance issue could...

dlanorfeb24 (9/4/2015)

---

I have a table with these fields:

student number,gender,subject,date

now, upon enrolling it will store 5 or more records into the db with the same values for student number,gender and...

It's a long time ago when I was working with barcode. But as far as I remember it's just a letter font (for instance: the first hit in google search[/url])...

Thanks for the update. We are currently investigating all interesting facts about FILESTREAM. Your update will be added to our documentation 😉

I used to use the free VM Ware version, but recently I switched over to Virtual Box. The advantage of Virtual Box is the availablility to create snapshots. For the...