Matt,

I think you should tell the network guys you're sorry for screwing up their machine and promise not to do it again.

 

What did you find when you tested it to see what happens?

 

 

If you have Internet Explorer Enhanced Security installed on the server, it will cause a message box to pop-up when you attempt to run an executable.  Since there is no...

Notice that is does not actually say that it does not break the connection of of qualified users, it only says that the breaks the connections of unqualified users.

I agree...

That is not what it says in Books Online.  It doesn't say that it does not break their connection.

From SQL Server 2000 books Online:

Controls which users may access the database....

It is OK to drop a temp table created in a stored procedure, and I posted code that shows you how to do this. 

There is no good reason to drop...

You will not be able to do what you want, because they are not your tables to drop.

There is no good reason to do what you are trying.

 

This code only works correctly if the temporary object is a table:

IF OBJECT_ID('TempDB..#MyTemp') IS NOT NULL
DROP TABLE #MyTemp

This check makes sure it is a table:

if exists (
 select  *
 from
  tempdb.dbo.sysobjects o
 where
 o.xtype in...

Here is a free utility that will handle the DST time zone updates for windows machines running XP, NT, 2000, 2003, Vista. It updates Daylight Saving Time in these time...

What is a "grid cell"?

What does your application do?

Yu need to put the square root of the number of rows needed, ( convert(int,ceiling(sqrt(abs(@START_NUMBER-@END_NUMBER)+1))) ), into a temp table using the F_TABLE_NUMBER_RANGE function, and then cross join the temp table...

Either of these should do it.

select
 stuff(rtrim(acct_id),7,len(acct_id)-10,replicate('0',len(acct_id)-10))
from
 ( select acct_id =convert(char(19),'387643098846789         ') ) A

select
 left(acct_id,6)+replicate('0',len(acct_id)-10)+right(rtrim(acct_id),4)
from
 ( select acct_id =convert(char(19),'387643098846789         ') ) A

Use the F_TABLE_NUMBER_RANGE function on this link:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47685

It's seems really common from the posts I read. Check out this ongoing thread with links to posts of people that need to restore but don't have backups.  A lot of people seem to...

So you are not working with SQL Server then.