My list includes some print statements, which do not work in the current release, but the feature comes soon. BTW this list includes many things you possibly want to know about your database. If you know similar interessting queries let me know.
---- generell queries not depending on special demo databases
-- about the current Server --
Select @@SERVERNAME;
Select @@VERSION;
SELECT SERVERPROPERTY('productversion') Version;
SELECT SERVERPROPERTY ('productlevel') ServicePack;
SELECT SERVERPROPERTY ('edition') Edition;
Select name from master.sys.databases order by database_id;
Select name from master.sys.databases order by 1;
select * from master..sysdatabases;
-- set dbcmptlevel to SQL 2000
declare @dbname sysname; select @dbname = db_name(0);exec sp_dbcmptlevel @dbname, 80;
-- set dbcmptlevel to SQL 2005
declare @dbname sysname; select @dbname = db_name(0);exec sp_dbcmptlevel @dbname, 90;
-- set dbcmptlevel to SQL 2008
declare @dbname sysname; select @dbname = db_name(0);exec sp_dbcmptlevel @dbname, 100;
---
declare @curdb sysname; select @curdb = db_name(0);
select 1 lfd, left(@curdb, 20) db, DATABASEPROPERTYEX(@curdb, 'Collation') Collation
union
select 2, left('master', 20) db, DATABASEPROPERTYEX('master', 'Collation')
union
select 3, left('tempdb', 20) db, DATABASEPROPERTYEX('tempdb', 'Collation')
order by 1;
---
-- about the current database --
Select db_name(0);
select @@LANGUAGE;
select @@DATEFIRST;
set language german;
set language us_english;
-- others
Select getdate();
-- not yet supported
Print 'Text No 1 Note all print output is before any resultsets';
Select getdate();
Print 'Text No 2 In Query Analyzer the date would show up before this 2nd print output';
RAISERROR('dispays immediately', 0, 1) WITH NOWAIT
declare @dbname sysname; select @dbname = db_name(0);exec sp_dbcmptlevel @dbname;
