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.

 

Are you migrating to SQL Server from postgreSQL, or the other way around?

 

What exactly is wrong with having a NULL date if the date is actually unknown or does not apply?

It is a good design practice to not allow a required column...

Brian,

You are posting criticisms of Red-Gate on a site that they own, and I don’t see any effort to remove your posts, so the censorship doesn’t seem too oppressive to...