Re: SOS - 2000 instead of 2005

Tech-Archive recommends: Fix windows errors by optimizing your registry

You two are great :)
Thanks!

"Keith Kratochvil" <sqlguy.back2u@xxxxxxxxxxx> wrote in message
news:uk9A8Li7GHA.940@xxxxxxxxxxxxxxxxxxxxxxx
Adding to Arnie's post, there is a "script to" option that lets you
specify that you want to generate scripts that will be compatible on
SQL2k5 or SQL2k.

--
Keith Kratochvil


"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

  • remote SYSTEM compromise in WASD OpenVMS http server
    ... WASD VMS Hypertext Services is a popular http server for OpenVMS ... - getting the sources of all cgi scripts ...
    (Bugtraq)
  • Re: problem with validated site
    ... server side scripts have drawbacks that must be weighted against their benefits when compared to alternative reliable authoring strategies. ... This has a simple effect with most user agents: Everytime you navigate to a page of the site, it's entirely reloaded. ... For example, it should expand entity references and marked sections (because they're not supported by existing HTML user agents), but shouldn't close omitted tags. ...
    (comp.infosystems.www.authoring.html)
  • SUMMARY: repository for scripts for multiple machines, and multiple users
    ... subversion, cfengine, rdist, rsync, NFS ... I have been messing about with shell scripts to maintain a common base ... regular updates from a central server. ... Highly granular access control is possible with Subversion. ...
    (SunManagers)
  • Re: Is someone trying to hack my Web Host?
    ... >>I was looking through the raw log files to see who's visiting my ... "scripts" directory. ... > web server at home connected to the net. ... int main { ...
    (alt.computer.security)
  • Re: Update on Timer Frequencies
    ... I'm running a video server that is taking in and sending out ... > it's not a perfect test to evaluate timer frequencies (because it doesn't ... There may be clashes between the scripts and the services. ...
    (Linux-Kernel)