• I'm a total n00b to SQL, we received SQL2000 as database server backend with accounting software and frankly speaking, looking at the complexity of this stuff, it will not be my hobby :))

    However, the need for a backup is there so i found this script. Is anyone running this on SQL 2000 SP4? I tried the script by starting Enterprise Manager, follow the path

    Microsoft SQL Servers -> SQL Server Group -> (local) (Windows NT) -> Databases -> master -> Stored Procedures and then choosing new stored procedures. I copied the entire contents of the backup scripts version 3 a few posts up. I think i need to replace the NULL parameters with some of the things i needed to decide on. So i did that, when i click on OK i get a huge error message (so long it doesn't fit my screen) with all sorts of "Need to define" and then a variable name.

    What am i doing wrong?