In Registered Servers, "Local Server Groups", save Credentials with either SQL or Windows;the data is stored in your %appdata% folder, so it is user specific and not shared.

Central Management...

I've seen this happen recently on a Web/WPF app where the SQL Instance was using SQL Express;

as a resource conservation attempt, the express version defaults databases to auto close,and...

this is what i've used for quite a long time:

I wanted both server uptime and the SQLService uptime.

i made a simple stored proc, sp_help_uptime and put it in master,...

well, sp_who/sp_who2 should at l least show what is connecting to that database, I would just force the database off line then.

in 2005 and above, i know we could do...

The SSRS Service is always active in the database, even when it's not really doing anything.

SQL Server Reporting Services has two parts:

The Service and the Databases it points to and...

at the time i was answering, i had tunnel vision.

i swear, it looked like...

since this is more of an in your face dashboard, you'll need to build the pieces, failed jobs vs next scheduled jobs.

this site has a nice query for the next...

also in my experience, every trigger,package,procedure and function in oracle will have to be rewritten, even when they is doing the most trivial CRUD operations, and especially because the...

Eric thanks for prompting me to investigate Server Roles deeper.

this is the role i came up with, that grants select on any user objects as well as the view server...

interestingproblem;

here's how i think i would tackle it;

substitute [ClarkKent] for your [domain\ADGroup]

Create LOGIN [ClarkKent] WITH PASSWORD='NotTheRealPassword'

--see anything in the DMV's

GRANT VIEW SERVER STATE TO [ClarkKent];

--allow to see object definitions, tables...

wouldn't creating a dacpac be an option? i

m not sure if they are SQL Server version agnostic or not, but the dacpac has the object schemas, ; i though...

aliases are your friend, especially with a delete construct like this;

here's an example:

; with cte

AS

(

select * FROM employee

)

delete myTarget

from #temp myTarget

inner join cte MySource ON myTarget.id = MySource.id

this is the kind of annoying projects that make you reach for your nearest programming language;

SSIS is handicapped when it comes to data lengths being dynamic.

I've got an Generic CSV...

sp_help_revlogins will do that for you;

it produces results like this, because it uses a bin to hex function:

-- Login: ClarkKent

IF NOT EXISTS ( SELECT * FROM sys.server_principals WHERE name =...

i've seen things like this, where backups are scheduled at 4am, and then so is an reindexing job AND a statistics job.

all at 4am. once all the sorting in tempdb...