SOS - 2000 instead of 2005

From: "Guy Cohen" <noemail@xxxxxxxxxx>
Date: Thu, 12 Oct 2006 15:50:27 +0200

Hi all.

My webhost prepared a server for me with 2000 instead of 2005.
Will my .net 2005 application work there?
I generated a script to export my sql server 2005 object
Lots of failures appeard.

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name =
N'aspnet_WebEvent_FullAccess' AND type = 'R')
CREATE ROLE [aspnet_WebEvent_FullAccess]
GO

This is the error:
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'ROLE'.

The object is part of the asp.net login components - I did not create these
objects myself!

Please tell me what to do next..........

TIA
Guy

.

Follow-Ups:
- Re: SOS - 2000 instead of 2005
  - From: Keith Kratochvil
- Re: SOS - 2000 instead of 2005
  - From: Arnie Rowland

Prev by Date: how do I connect to sql server express databases using excel?
Next by Date: Re: Errors after MSDE2000 install
Previous by thread: how do I connect to sql server express databases using excel?
Next by thread: Re: SOS - 2000 instead of 2005
Index(es):
- Date
- Thread

Relevant Pages

Re: Same Internal Server Error from last two days
... I am trying to run a Hello World Perl Script in Apache 2.2. ... But its constantly giving me Internal Server Error.The script ... # have to place corresponding `LoadModule' lines at this location so the ...
(perl.beginners)
Re: Same Internal Server Error from last two days
... I am trying to run a Hello World Perl Script in Apache 2.2. ... But its constantly giving me Internal Server Error.The script Runs perfectly fine from the command prompt. ... # This is the main Apache HTTP server configuration file. ... LoadModule actions_module modules/mod_actions.so ...
(perl.beginners)
Same Internal Server Error from last two days
... I am trying to run a Hello World Perl Script in Apache 2.2. ... But its constantly giving me Internal Server Error.The script ... # have to place corresponding `LoadModule' lines at this location so the ...
(perl.beginners)
Re: Regarding a selection for mobile code/scripting language
... Client Side scripting, so the server can send script commands to the client. ... I decided they should be scripted and mobile code. ...
(Vuln-Dev)
Re: Updating SQL Server database tables with vbscript
... I think you'll need to post the script before anyone will have a clue. ... | We have a vbscript to update SQL Server database tables from text files. ...
(microsoft.public.windows.server.scripting)