I am looking for someting similar and I must not be searching correctly.

I was looking for either a T-SQL or WMI or even Powershell script that can scan a registry...

SQL 2008 +

I found this, I am looking for a better way however.

USE MASTER

GO

EXEC sys.sp_configure N'show advanced options', N'1' RECONFIGURE WITH OVERRIDE

GO

EXEC sys.sp_configure N'user connections'...

I am looking for the same thing, however that link is no longer valid. does anyone have another reference or actual answer?

Replies like yours are one reason I feel it is needed, because my company seems to think this is going to be the mother of all save all\catch alls for...

Well in this shop, data is stored and these are the topics I have to report off of. All SQL, no front in application to sit on top.

Simple Depreciation...

Thanks!

I really enjoyed the article but had some questions, you had mentioned the potential use of an Inline Table -valued UDF and a Recursive CTE, I was wondering if you...

He asked for a good site, recomendation. Anyone can google.

hence, my not understanding the syntax pieces. Make all of the difference when you can understand all of the components.

I dont think I am doing too bad for 2...

Yes it is a 64 bit server. So based on my first question, I guess I need to force it to go thru 32 bit. Which I tried...

Resolution: I place the activity in a container. If file exists do this, else exit the container which makes the container always true unless of failure. So...

Okay, I used a script task to deterime if a file was present. if the file was present I run a data flow taks, if not present I skip...