Hi,

There is a messing one parenthesis

SELECT

'Registration' AS RType,

Type AS [NAME],

JanAmt = Sum(CASE WHEN Month(dateentered) = 1 THEN cast(cost AS money) ELSE 0 END),

FebAmt = Sum(CASE WHEN Month(dateentered) = 2 THEN...

Hi,

Check this link may be it help you

http://forums.databasejournal.com/archive/index.php/t-14790.html

Regards,

Ahmed

Hi,

I think thet Jeff proposition is the only way to recover your lost data (because you have a simple recovery model). to check the data you lost just download a...

Hi,

Check this link http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=817906&SiteID=1

Regards,

Ahmed

Hi,

Check this link you will have almost all info. about backup and restore.

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx

Regards,

Ahmed

Hi,

Check this TSQL

Declare @dbName sysname

declare @strSQL sysname

-- Get Databases names for Online ones.

Declare @nextExtension Float

Declare cDB Cursor For Select name From master..sysdatabases Where status&512=0

Create Table #spHelpFile([DbName] sysname null,[DLFileName]...

Hi,

Just excute DBCC SQLPERF(LOGSPACE)

Regards,

Ahmed

Hi,

even in SQL Server 2000 enterprise + SP4 you will have the following error:

Server: Msg 5105, Level 16, State 2, Line 1

Device activation error. The physical file name 'C:\mnt\lun1\perf05_data01.mdf may...

So no idea

Ahmed

use master

go

CREATE DATABASE [perf05] ON PRIMARY

(NAME = N'perf05_data01', FILENAME = N'C:\perf05_data01.mdf' , SIZE = 800, MAXSIZE = 25000, FILEGROWTH = 100%),

(NAME = N'perf05_data04', FILENAME = N'C:\perf05_data04.Ndf' , SIZE =...

Hi,

The master database contains system information and high-level information about all databases on an SQL Server (also logins !).

You will lost all logins and databases that are not created under...

Hi,

Check http://msdn2.microsoft.com/en-us/library/ms190679.aspx

For SQL 2000

1- Add the backup device

2- Stop SQL Server

3- Bring SQL Server to single-user mode via the command line For example : c:\program files\microsoft sql...

Hi,

It seems that the flag 3226 has been introduced in SQL Server 2000 before SP4.

Check this http://www.thescripts.com/forum/thread162385.html

Regards,

Ahmed

hi,

When running sp_spaceused you get that about 75 G are used by data.

So, in my opinion upgrade to SP2 and check which tables are growing so fast, may be some...

Hi,

Check also the following http://blogs.techrepublic.com.com/howdoi/?p=140

Regards,

Ahmed