szejiekoh (3/20/2016)

---

SQLSlammer (3/17/2016)

---

Hi,

The answer to the second question is because the sys.databases is marked as a system object meaning it can be called from any database, so no matter which...

<SMTPServer>192.168.0.8</SMTPServer> is incorrect. YOUR local machine is not the SMTP server, you are not running an SMTP service.

you want smtp.googlemail.com in that value, which is the address for gmail.

setting up...

your job is probably running under the context of a specific user (operator) in SQL Agent.

If you edit the job step calling the package, what is the name of the...

you can infer the last accessed time of every database since the server was last rebooted base din the index stats; if you've got something regularly rebooting your server, you'll...

if you connect locally via a Dedicated Admin Connection, you will be able to see the unencrypted definitions. you might have to enable the DAC just to conenct that way,...

i think there is a server wide trigger that is sending an email if a database is created....and the end user creating the database does not have access to the...

SET @QRY = requires passing a single column value or string value to the variable.

SELECT @DaTE = MAX(CreatedDate) is a decent example

your query says SET = (SELECT PL.Permit_number,

...

i think your issue is you are storing integer representations of dates; not sure if you have control, but i would change the datatypes to be [date] or [datetime] data...

yes you can; google for "powershell extract SSRS"

or just "extract SSRS" and you'll find quite a few solutions that query the ReportServer database and extract all the objects out.

q1) I would say the reason is atomicity of the data plus permissions, and yes, portability. the permissions related to the database are contained in the database itself.

backups and...

Pieter-423357 (3/17/2016)

---

Need trick and scanning the AD-group is certainly useful, but wouldn't you want to know the real permissions in SQL Server itself to the Database level? Or at least...

I've seem this before;

What I've seen is that while 99% of the calls to the [production] database are perfectly normal, sometimes the database context gets lost, and the the default...

i'd like to see the actual query and an execution plan;

you might have a non-Sargable query, functions in the Where clause, a catch all query containing a lot of OR...

typically, you grant on a per-table or per-procedure basis when you want to restrict access to SOME of the tables.

what happens if new tables are added, or a table/proc is...

exporting to csv is no problem, even if there is 2.5 million rows.

opening it IN EXCEL is an issue, since it will not support that many rows.

open it in...