Re: SOS - 2000 instead of 2005

Your script to recreate your database objects is incompatible with SQL 2000.

In SQL 2000, there is no CREATE ROLE, there is no sys.database_principals.

You will either need to redesign your application and database to exist in
and work with SQL 2000, or insist that the ISP remove SQL 2000 and install
SQL 2005.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Guy Cohen" <noemail@xxxxxxxxxx> wrote in message
news:uNNG0Ug7GHA.4552@xxxxxxxxxxxxxxxxxxxxxxx
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




.

Relevant Pages

  • Re: ActiveX script works in DTS but not in job, why?
    ... Peter DeBetta, MVP - SQL Server ... As another test I saved the script as a .vbs file and tried running it, ... Microsoft OLE DB Provider for SQL Server ... 2000 databases including DTS packages. ...
    (microsoft.public.sqlserver.dts)
  • Re: Maintain production DB with changes from development DB
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... Or will I have to write a script to update all 4 servers? ...
    (microsoft.public.sqlserver.dts)
  • Re: Vista hosting XPe tools/db
    ... Are you running this script on the machine that actually has the SQL server ... machine hosting the database. ... i don't know if you can install a second instance of SQL ...
    (microsoft.public.windowsxp.embedded)
  • Re: ActiveX script works in DTS but not in job, why?
    ... Account that SQL Agent runs under and it is a Local Admin on the box. ... As another test I saved the script as a .vbs file and tried running it, ... Microsoft OLE DB Provider for SQL Server ... that would be since I need to be able to load DTS packages from either a SQL ...
    (microsoft.public.sqlserver.dts)
  • Re: Enterprise Manager Newbie Question
    ... a SQL backup is not a simple copy of the database files. ... Is it possible to write a script that one could run from a workstation and ...
    (microsoft.public.sqlserver.tools)
Loading