Enterprise Manager problem with views

We have a user who is a db_owner on a database that he can't create a view using Enterprise Manager. When he tries to create a view it returns: "ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '240'." His NT Domain username is 240DBH.

We've tried it on my computer with him logging on and get the same result. He can create views just fine using query analyzer. Does anybody know what's wrong with doing this in Enterprise Manager? By the way, I can create views in the db using Enterprise Manager just fine.

Thanks for your help!Turn Profiler on and see what commands Enterprise is sending to the server to create this view. It may shed some light.|||Thanks for the suggestion! I hadn't used the profiler before. It is trying to execute the following:

CREATE VIEW 240dbh.VIEW1
AS
SELECT ID, [Start Date]
FROM T_DATA

Now, when I run this in query analyzer, I get the same error. It seems like that should work to me.:confused:|||Now I think I have it narrowed down. His username starts with numbers. If you can't have a username that starts with numbers, that is pretty lame.

Does anyone know if there is a better front-end than enterprise manager for creating tables/views/stored procedures?

Thanks!|||User names with numbers are not a problem. Does the user have ddladmin rights?

If you are using SS2K than use the Query Analyzer! Much better for users than the EM!|||I set up a user under sql server 7 with a username that has no numbers with the exact same permissions as that user who can't create a view.

That new user with no numbers can create views just fine.

So, the only difference between the two users is that one is a sql server logon and one uses NT domain authentication, and the fact that one has numbers in the username.

What I'm finding is that if enterprise manager would do something like:
CREATE VIEW [240dbh].VIEW1

instead of:
CREATE VIEW 240dbh.VIEW1

it would work.

Enterprise Manager html error

Normally in Enterprise Manager the right hand pane displays icoms for
Diagrams, Tables, Views, etc. when a particulat database is clicked on in the
left hand pane.
For one particulat database, and only one, Enterprise Manager attempts to
display an html page with various tabs but this errors when loading and
displays wthout any information on it.
Why is this database differnet - I can't find any setting wich controls this
display or indeed any reference in BOL, and can I change it?
The error pops up an alert box as follows:
A Runtime Error has occurred.
Do you wish to Debug?
Line: 306
Error: Unspecified error.
unknown exeption
Break
Res://C:\...\sqlmmc.rll/Tabs.html
szDB =
parent.window.objSQLNSContext.GetDisplayName(strCo ntextCookie)
strContextCookie = GetParameterX("SQLNSCookie");
szDB = undefined
strContextCookie = "00FA25200000000000000001"
The line is called from JScript global code.
So, secondly, what is the error and can I fix it?
Thanks
Grant Ord
Grant,
You need to click on the database and then on the View tab change to
something other than Taskpad. Then change to Taskpad. The details should now
be fine. It is a known bug I think.
Chris Wood
Alberta Department of Energy
CANADA
"Grant Ord" <grant.ord@.nospam.nospam> wrote in message
news:1D78B191-9D4C-4834-957B-E07828400110@.microsoft.com...
> Normally in Enterprise Manager the right hand pane displays icoms for
> Diagrams, Tables, Views, etc. when a particulat database is clicked on in
the
> left hand pane.
> For one particulat database, and only one, Enterprise Manager attempts to
> display an html page with various tabs but this errors when loading and
> displays wthout any information on it.
> Why is this database differnet - I can't find any setting wich controls
this
> display or indeed any reference in BOL, and can I change it?
> The error pops up an alert box as follows:
> A Runtime Error has occurred.
> Do you wish to Debug?
> Line: 306
> Error: Unspecified error.
>
> unknown exeption
> Break
> Res://C:\...\sqlmmc.rll/Tabs.html
> szDB =
> parent.window.objSQLNSContext.GetDisplayName(strCo ntextCookie)
> strContextCookie = GetParameterX("SQLNSCookie");
> szDB = undefined
> strContextCookie = "00FA25200000000000000001"
> The line is called from JScript global code.
> So, secondly, what is the error and can I fix it?
> --
> Thanks
> Grant Ord
|||http://www.aspfaq.com/2293
http://www.aspfaq.com/
(Reverse address to reply.)
"Grant Ord" <grant.ord@.nospam.nospam> wrote in message
news:1D78B191-9D4C-4834-957B-E07828400110@.microsoft.com...
> Normally in Enterprise Manager the right hand pane displays icoms for
> Diagrams, Tables, Views, etc. when a particulat database is clicked on in
the
> left hand pane.
> For one particulat database, and only one, Enterprise Manager attempts to
> display an html page with various tabs but this errors when loading and
> displays wthout any information on it.
> Why is this database differnet - I can't find any setting wich controls
this
> display or indeed any reference in BOL, and can I change it?
> The error pops up an alert box as follows:
> A Runtime Error has occurred.
> Do you wish to Debug?
> Line: 306
> Error: Unspecified error.
>
> unknown exeption
> Break
> Res://C:\...\sqlmmc.rll/Tabs.html
> szDB =
> parent.window.objSQLNSContext.GetDisplayName(strCo ntextCookie)
> strContextCookie = GetParameterX("SQLNSCookie");
> szDB = undefined
> strContextCookie = "00FA25200000000000000001"
> The line is called from JScript global code.
> So, secondly, what is the error and can I fix it?
> --
> Thanks
> Grant Ord

Enterprise Manager html error

Normally in Enterprise Manager the right hand pane displays icoms for
Diagrams, Tables, Views, etc. when a particulat database is clicked on in the
left hand pane.
For one particulat database, and only one, Enterprise Manager attempts to
display an html page with various tabs but this errors when loading and
displays wthout any information on it.
Why is this database differnet - I can't find any setting wich controls this
display or indeed any reference in BOL, and can I change it?
The error pops up an alert box as follows:
A Runtime Error has occurred.
Do you wish to Debug?
Line: 306
Error: Unspecified error.
unknown exeption
Break
Res://C:\...\sqlmmc.rll/Tabs.html
szDB = parent.window.objSQLNSContext.GetDisplayName(strContextCookie)
strContextCookie = GetParameterX("SQLNSCookie");
szDB = undefined
strContextCookie = "00FA25200000000000000001"
The line is called from JScript global code.
So, secondly, what is the error and can I fix it?
--
Thanks
Grant OrdGrant,
You need to click on the database and then on the View tab change to
something other than Taskpad. Then change to Taskpad. The details should now
be fine. It is a known bug I think.
Chris Wood
Alberta Department of Energy
CANADA
"Grant Ord" <grant.ord@.nospam.nospam> wrote in message
news:1D78B191-9D4C-4834-957B-E07828400110@.microsoft.com...
> Normally in Enterprise Manager the right hand pane displays icoms for
> Diagrams, Tables, Views, etc. when a particulat database is clicked on in
the
> left hand pane.
> For one particulat database, and only one, Enterprise Manager attempts to
> display an html page with various tabs but this errors when loading and
> displays wthout any information on it.
> Why is this database differnet - I can't find any setting wich controls
this
> display or indeed any reference in BOL, and can I change it?
> The error pops up an alert box as follows:
> A Runtime Error has occurred.
> Do you wish to Debug?
> Line: 306
> Error: Unspecified error.
>
> unknown exeption
> Break
> Res://C:\...\sqlmmc.rll/Tabs.html
> szDB => parent.window.objSQLNSContext.GetDisplayName(strContextCookie)
> strContextCookie = GetParameterX("SQLNSCookie");
> szDB = undefined
> strContextCookie = "00FA25200000000000000001"
> The line is called from JScript global code.
> So, secondly, what is the error and can I fix it?
> --
> Thanks
> Grant Ord|||http://www.aspfaq.com/2293
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Grant Ord" <grant.ord@.nospam.nospam> wrote in message
news:1D78B191-9D4C-4834-957B-E07828400110@.microsoft.com...
> Normally in Enterprise Manager the right hand pane displays icoms for
> Diagrams, Tables, Views, etc. when a particulat database is clicked on in
the
> left hand pane.
> For one particulat database, and only one, Enterprise Manager attempts to
> display an html page with various tabs but this errors when loading and
> displays wthout any information on it.
> Why is this database differnet - I can't find any setting wich controls
this
> display or indeed any reference in BOL, and can I change it?
> The error pops up an alert box as follows:
> A Runtime Error has occurred.
> Do you wish to Debug?
> Line: 306
> Error: Unspecified error.
>
> unknown exeption
> Break
> Res://C:\...\sqlmmc.rll/Tabs.html
> szDB => parent.window.objSQLNSContext.GetDisplayName(strContextCookie)
> strContextCookie = GetParameterX("SQLNSCookie");
> szDB = undefined
> strContextCookie = "00FA25200000000000000001"
> The line is called from JScript global code.
> So, secondly, what is the error and can I fix it?
> --
> Thanks
> Grant Ord

Enterprise Manager error when using WITH (NOLOCKS)

I have added WITH (NOLOCK) to a couple of views that were causing unecessary
blocking for MS Access end user reporting.
I can update edit and save the views fine with Query Analyzer, however when
I try and run the query from Enterprise Manager Design View I get this
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect Syntax
The views work fine in everywhere else. When in EM if I remove the WITH
(NOLOCK) I do not get the error.
It looks as if the alias is causing the issue.
select * from MyTable WITH (NOLOCK) works
however Select * from MyTable mt WITH (NOLOCK) causes the error. But only in
EM not in query analyzer.
Is anyone else experiencing this?
"lurdan" wrote:

> I have added WITH (NOLOCK) to a couple of views that were causing unecessary
> blocking for MS Access end user reporting.
> I can update edit and save the views fine with Query Analyzer, however when
> I try and run the query from Enterprise Manager Design View I get this
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect Syntax
> The views work fine in everywhere else. When in EM if I remove the WITH
> (NOLOCK) I do not get the error.
>
|||I got the same result. When I tried to run the query in EM, the query tool
inverted the alias to after the table hint, which is bad syntax.
Russel Loski, MCSD.Net
"lurdan" wrote:
[vbcol=seagreen]
> It looks as if the alias is causing the issue.
> select * from MyTable WITH (NOLOCK) works
> however Select * from MyTable mt WITH (NOLOCK) causes the error. But only in
> EM not in query analyzer.
> Is anyone else experiencing this?
> "lurdan" wrote:

Enterprise Manager error when using WITH (NOLOCKS)

I have added WITH (NOLOCK) to a couple of views that were causing unecessary
blocking for MS Access end user reporting.
I can update edit and save the views fine with Query Analyzer, however when
I try and run the query from Enterprise Manager Design View I get this
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect
Syntax
The views work fine in everywhere else. When in EM if I remove the WITH
(NOLOCK) I do not get the error.It looks as if the alias is causing the issue.
select * from MyTable WITH (NOLOCK) works
however Select * from MyTable mt WITH (NOLOCK) causes the error. But only in
EM not in query analyzer.
Is anyone else experiencing this?
"lurdan" wrote:

> I have added WITH (NOLOCK) to a couple of views that were causing unecessa
ry
> blocking for MS Access end user reporting.
> I can update edit and save the views fine with Query Analyzer, however whe
n
> I try and run the query from Enterprise Manager Design View I get this
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorre
ct Syntax
> The views work fine in everywhere else. When in EM if I remove the WITH
> (NOLOCK) I do not get the error.
>|||I got the same result. When I tried to run the query in EM, the query tool
inverted the alias to after the table hint, which is bad syntax.
--
Russel Loski, MCSD.Net
"lurdan" wrote:
[vbcol=seagreen]
> It looks as if the alias is causing the issue.
> select * from MyTable WITH (NOLOCK) works
> however Select * from MyTable mt WITH (NOLOCK) causes the error. But only
in
> EM not in query analyzer.
> Is anyone else experiencing this?
> "lurdan" wrote:
>

Enterprise manager crashing SQL Server

Hi

We're having trouble with Enterprise manager when trying to view views or table data/properties, we get an access violation error and the database crashes sometimes corrupting tables.
Ive seen some posts stating a post SP3 for SQL Server is required and some posts saying client access should be modfied.
However our enterprise manager clients are registered with SA so I dont think that is an issue.
Can anyone give me some help with this and/or direct me to the hotfix please.

Cheers

LouiseThis is the problem due to mismatched DLLs and corrupted client tools installed. Ensure to install SQL client tools from scratch.

And its better to review the task using query analyzer rather than opening from Enterprise Manager due to flaky behaviour of such GUI tools.|||thanks will give that a go and reinstall my client tools

Cheers