I checked the default database, which is 'master' for this account. Hmmm... I'll look around on the server some more to see what kind of services might be running on...

It's all coming together for me. Thanks for the assistance.

And in case it helps someone else out, I was asking about viewing the session data in a format...

I'm probably wrong, being so new to SQL Server and Extended Events, but the "event stream" target seems to only supply information if you're watching the live viewer. Otherwise,...

Looks like it defaults to something called an "event stream". At least that's what's listed when I run your amended SQL stmt as such, and thanks, btw 🙂

SELECT ...

Ah, patience apparently isn't one of my virtues today. I'm seeing the events stack up now.

Thanks,

--=Chuck

I guess my main concern with the cluster is that if it does have an issue, it might take longer for me to resolve the problem, and in cases where...

Why would we need to rebuild it from scratch? The main reason I expected to do it, would be when it's time to upgrade from MSSQL 2014. If it's impractical...

Bummer! Oh well, thanks for the quick end-of-the-workweek response 🙂

SSCrazy,

So do the fixed server roles actually have these actual permissions listed as part of their make-up, or are those 'permissions' just defined in the documentation? For example,...

In re-reading that post, I realize what a vaguely worded question I asked.

In actuality, I'm looking to gather some experiences on the differences between, for example, granting

...

I should probably clarify, I was thinking about having a 'utilities' database on each SQL Server instance, as opposed to one single 'utilities' database and using linked servers to access...

I suppose that's possible, but I'm not sure why this one database would go offline, when the remainder of the database within the same instance wouldn't also be having a...

I think what I am ultimately going to do is place these utility functions in a separate database per SQL Server instance. Then in all other database (including model) I'll...

Registered server trick?

Ooo, that's pretty creative, actually. But it fails with the following error:

Synonyms are invalid in a schemabound object or a constraint expression.

You suggestion made me realize that I can probably...