Seems like a lot of work.  Why not just use WITH EXECUTE AS OWNER at the beginning of the proc?

Finding the last access date and time doesn't tell you if it's currently being accessed.  Why not just check sp_lock results for objects that have locks on them?

Dude!  I'm right here! 😀

From the sounds of it, you're a bit new to partitioning and all of the benefits and seriously negative caveats it can throw you.

Let's start at the beginning... Why do...

To Steve's good point...

From the posted input and the posted required output, it looks like there should only be a return if a given AlertID only has AlertTypeID's of both...

I don't use Azure and I've not used VB in a million years.  However, the following link seems to have a fair bit of info that you might find applicable...

Oh... no question about trying something new being a good thing.  That's actually how I got so involved with electronics, computers, and ultimately SQL Server (and many other programs including...

I don't know... if you consider that 100 hours is probably outside of your normal work hours and you spend 2 hours of the 100 every day on weekdays, that...

Her being home isn't helping because she's also one of those folks that has to say everything she's doing out-loud as she's doing it. It's as bad...

Jeff, these may be for you (if you dare venture anywhere to buy them, that is!). I have a pair and they work a treat. Not that I...

Heh... I'm often told that SQL Server isn't the center of the Universe.  My standard reply is "Cool!  Let's turn it off and see if you're right!". 😀

Oddly enough, they...

We closed our office last week, everyone at home. Not a big change for some of us, but it is a change. Many things are less active and it...

I'll bet she is too! 😀

I appreciate your humility, Phil, but I think Kruger-Dunning is in effect and you're drastically underrating your skills both in SSIS and as a writer.

Yeah, I checked that first query. some servers all available drive retrieved and some servers not retrieved. could you suggest me what kind of permission required for fetching all...