Use an output parameter rather than a result set.

> Do you have a source for this information or a helpful source on this type of information.

Books OnLine.

No, that is processes, not user connections.  Try this:

SELECT cntr_value 'User Connections'

FROM master.dbo.sysperfinfo

WHERE counter_name = 'User Connections'

Try something like this:

SET @sql = @db + '..sp_dropuser ' + @name

EXEC sp_executesql @sql

You can delete from a view by using an INSTEAD OF trigger on the view.  Using Ray's example:

CREATE TRIGGER d_myView ON myView

INSTEAD OF DELETE AS

DELETE One

FROM One JOIN deleted ON Nbr = Nbr1

DELETE Two

FROM Two JPIN deleted ON...

Run sp_helpdb and check the Compatibility_Level values.

They're in msdb as that's where the jobs are, not master. 

I would put the UnitIDs in question into a temporary table rather than a concatenated string.  No need for a cursor, loop, or dynamic SQL.  Using PKId as the primary key...

First of all, binary(16) is 16 bytes, not bits.  Another thing is that the minimum number of bytes to store 16 bytes is 16...

Frank's friend Erland has written a fine essay on this problem:

http://www.sommarskog.se/dyn-search.html

I'd use binary(16).  That would be compact yet eminently readable.  Do the display formatting at the client.

Do not just shut down Windows to "reboot."  That is forcing a SHUTDOWN WITH NOWAIT after a short time (20 seconds?), which means there will be no recent checkpoint.

Instead use...

A .CKP file is created when a backup or restore fails in such a way that the WITH RESTART option can be used.  You can delete the file now... 

Is the delay upon stopping or starting the SQL Server service?  What is the recovery interval option set to on this server?

CREATE PROC dbo.InMonth @Date datetime AS

SET NOCOUNT ON

SELECT Member_ID, Effective_Dt, Termination_Dt

FROM Members

WHERE Effective_Dt >= DATEADD(d,1-DAY(@Date),CONVERT(char(8),@Date,112))

 AND Termination_Dt < DATEADD(m,1,DATEADD(d,1-DAY(@Date),CONVERT(char(8),@Date,112)))