SOS - Please respond - SQL 2000 instead of 2005

  • Thread starter Thread starter Guy Cohen
  • Start date Start date
G

Guy Cohen

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
There was a failure here:

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'.


TIA
Guy
 
Your app should work just fine. The only challenge will be to make sure
that your app can access the database correctly. The statement that you
posted is one that helps to set up the right for the database to be accessed
from the ASPNet user.

If you need more help with SQL Syntax, you may want to ask your question on
a SQL forum.
--
--- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
 
Thanks
Ok I will
Dont blame me for cross posting *blush*
Guy
Nick Malik said:
Your app should work just fine. The only challenge will be to make sure
that your app can access the database correctly. The statement that you
posted is one that helps to set up the right for the database to be
accessed from the ASPNet user.

If you need more help with SQL Syntax, you may want to ask your question
on a SQL forum.
--
--- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
--
Guy Cohen said:
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
There was a failure here:

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'.


TIA
Guy
Click to expand...
Click to expand...
 
Back
Top