it's very easy to zip through the install clicking next next next, but forgetting to add AD login as an administrator on the SQL instance.

you probably need to add yourself...

open the dropdown so it shows all your history of connections.mouse hover over an item so it is highlighted, but DO NOT mouseclick/SELECT it.

while the dropdown is still open, and...

I've also got some CLR's that i deploy to 2008R2 or 2012/2014 .

like you, i've got multiple codebases, for R2,2012 or 2014.

for the 2012/2014 stuff, I've also not been able...

when the script prompted you for the instance name, you did not type "MSSQLSERVER"

it defaults to SQLExpress if you don't type anything.

you don't have an extra isntance...

because you got "login failed" you definitely have...

I would redesign this slightly, but a few things that jumps out at me are:

your query is hitting a view, which i try to avoid when possible. i prefer to...

All sys objects are either views, or procs or functions. The views are based on the uneditable resource database.

It is not possible to create your own obects in the sys...

szejiekoh (3/20/2016)

SQLSlammer (3/17/2016)

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...