nevermind I have found it. It is specifying the use of bitwise filter.

for anyone else who is interested

http://support.microsoft.com/kb/269181

thanks for the help.

This works great and is better then my solution because it does not need UDF.

Would you happen to have a reference for the numbers after userAccountControl? I am the...

I have figured out how to get disabled users out of the useraccesscontrol value. When converted to binary the second bit signifies whether account is enabled or disabled. So with...

I have just realized that I am trying to find the wrong value. What i wanted it disabled users, not locked users. I have found which attribute has this info...

I cannot just use lockouttime attribute as is because when doing so as in the query below, I receive the following error.

Cannot get the data of the row from the...

I didn't think that one all the way through...

I have one suggestion that wouldn't involve polling. What about adding the check if process is blocked and timing inside the stored procs you are trying to time. You would...

Unfortunately the blocked process report event does not exist in 2000. You are posting in the 2005 form so even though, looking back, I see you stated you were on...

You could setup a trace on the blocked process report event and have that trace logged to a table. This event doesn't trigger immediately but only after the process...

check out this link

http://support.microsoft.com/default.aspx?scid=kb;en-us;271509#kb2

It explains how to write blocks to a file but im sure the process can be modified to write to a table. It creates a store proc,...

Analysis services is business intelligence, integration services is for ETL(Extract,Transform,Load) which can be used for BI but is not exclusive to...

If you are on version 9.0.1399 (which is RTM) you need to have integration services installed an running to create maintenance plans. If you upgrade your server to Service pack...

sysfiles has mostly the same info in 2000

http://doc.ddart.net/mssql/sql70/sys-f.htm

check out sys.database_files system view.

http://msdn.microsoft.com/en-us/library/ms174397(SQL.90).aspx

I have not yet changed the -g switch setting because I wanted to be sure that it would help before doing so. The setting was in place when I started...