Additionally I would also look at the scheduled jobs on the server itself; there's a good chance that Extract-Transform-Load(ETL) jobs that populate your databases exists on the same server...

SSRS would not need any changes; it's not printer aware

Duplex printing is an end user/client setting,the specific target printer, and whether it supports double sided printing. whether to print...

sp_send_dbmail returns an int output parameter, which you can capture, but you have to do so explicitly.

[highlight="#ffff11"]declare @TheMailID int[/highlight]

...

In my experience, the network low on my list of things to review for slow running queries.

returning trivial information, like SELECT @@VERSION should come back instantly. that would quickly show...

Perry Whittle has posted a nice script multiple times, for example in this link:

http://www.sqlservercentral.com/Forums/Topic1560182-1550-1.aspx

i've grabbed his version and made it my own with minor tweaks, it's very comprehensive.

Bryan.avergonzado (11/23/2015)

---

This is from the log. I've tried to give full control to every account I can think of. The file path is correct.

Error: 5123, Severity: 16, State: 1.

2015-11-23...

it depends on the details, but regardless, you have to generate the list of commands from some place; the msdb backup history from production, or the folder full of files,...

because this looks a bit like homework, let me throw out suggestions and not the solution.

the key here is that you need to test consecutive values. to do that, you...

GilaMonster (11/23/2015)

---

Then you'll need to disable the cores in the server's BIOS, If the cores are visible to Windows, they have to be licensed. Ask the sysadmins to do the...

ok, if it's dynamic, it a pain, but doable. so much of it depends on the page that is presented with the listof files, because you have to extract them...

If you know the file name(s),there's quite a few articles on how to do this either via the SSIS component or a script task; i saw a lot in the...

Could you be raising an error but left off the rollback tran command?

the core error is that xml is case sensitive, but you capitalized some of the values.

SELECT

@edate=GETDATE(),

...

reformatted for readability, still looking at the code....

offhand, because of the OR statements turnign this into a catch all query, i think this should be multiple queries that insert into...

caojunhe24 (11/20/2015)

---

And I saw some people had same issue with job agent and they solved problem by making folder as shared folder. But the point is my folder is in...