>>WHERE crt_expiration_date < Convert( varchar, DateAdd( dd, 31, GetDate()), 101 )<<

This could also fail if the setting of DATEFORMAT is not MDY, which means on systems that are non-US...

The services are setup correctly.  SQL Server Agent is not a dependency of MSSQLSERVER, meaning that the SQL Server Agent does not have to be running for SQL Server to...

You can do everything in SQL Server 2005 that you can do in SQL Server 7, and much more.  It's basically the same database server engine as SQL 7.0 with 7...

Why don't you install SQL Server 2005, instead of SQL Server 7?

You can buy the SQL Server 2005 Developer Edition for under $50 US, and it has all the functionality...

 A dark background with white or light letters is best for the visually impaired, because you see light, not dark.

For SQL Server 7.0, run this script.  If you see "trunc. log on chkpt" in the result set, it is not Full Recovery.

declare @db sysname
select @db = db_name()
exec sp_dboption @dbname =...

I’ve seen stupid flame wars on this site, but this is the most ridiculous thread ever.

Give it a rest. Really.

For really large tables, you might want to use DBCC INDEXDEFRAG, instead of reindexing.  It's an online operation that can be run while the database is active, and does the...

This should do what you want.

Script to analyze table space usage

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

This query will show you how much unused space you have in each database file.

Use MyDatabase
-- Show Size, Space Used, Unused Space, and Name of all database files
select
 [FileSizeMB] =
  convert(numeric(10,2),round(a.size/128.,2)),
 [UsedSpaceMB] =
  convert(numeric(10,2),round(fileproperty( a.name,'SpaceUsed')/128.,2)) ,
 [UnusedSpaceMB] =
  convert(numeric(10,2),round((a.size-fileproperty(...

This is the best way to kick everyone, including administrators, out of the database and prevent them from reconnecting.

use master
alter database MyDatabase set offline with rollback immediate

You should post your question on a site wherer they answer SYBASE questions.

You might try the SYBASE forum on dbforumns.com

Clearly, this illustrates the problem with trying to help inexperienced people on a forum that have no desire to listen when you try to suggest a better way.

It would be a good idea to backup the logs much more often to prevent file growth.  Why don't you do it every 5 minutes if that is what your...

The best way to check for a temp table (SQL 2005 only) is to also include the object type parameter in the OBJECT_ID function call.  This makes sure that it...