failed to post

Hello,
I have a technical problem: I'm trying to load my xml file and xsd schema to a new post but fail to do so.
Plz if someone can help meI have put my question in the attached .txt file

Failed To Get Schema Name

I am getting a "Failed To Get Schema Name" error when I attempt to add a
view to a database on a remote server. I can add a View to a db on my
localhost server without any problems.

I am working with a report using SQL Reporting Services 2005 in VS.Net 2005

If I open the DB in SQL Management Studio, I can add a view without any
problems. What would be causing this error and how can I fix?

TIA
Dean

How are you creating this view? What are the steps? You said you can create the view using Management Studio - what tool are you using when you can create the view?

You said you are working with a report...so is the error being generated from the report? What does the report do? Do other reports work correctly?

-Sue

|||

i think the problem is with your .net connectivity. What do u mean by Add a view.... is it that u can create view. please post the exact error with error desc and no.

Madhu

|||

In Visual Studio 2005, using Server Explorer, connect to sql server, select db, right click on View node in tree, select Add.

It does not appear to be a Report problem. I'm trying to create a view that can be reused in multiple reports

Dean

|||

Adding a View, means using the Server Explorer window to connect to a database, select the View node and click Add.

"Failed to get schema name" is what shows up in the message box. There is no error number listed

Fail to drop schema - Error 15150

I want to drop a schema but it shows Fail to drop schema - Error 15150.
I found that there is no object under the schema. Any idea? Thanks in
advnaceHi
"stephanie" wrote:

> I want to drop a schema but it shows Fail to drop schema - Error 15150.
> I found that there is no object under the schema. Any idea? Thanks in
> advnace
Is this the default schema for anyone?
SELECT * FROM sys.database_principals
WHERE default_schema_name = 'dbo'
John|||Yes. But I changed the user with default schema to another schema, e.g. 'db
o'
I can't drop that schema with the same error 15150. Thanks
"John Bell" wrote:

> Hi
> "stephanie" wrote:
>
> Is this the default schema for anyone?
> SELECT * FROM sys.database_principals
> WHERE default_schema_name = 'dbo'
> John
>|||Hi
"stephanie" wrote:

> Yes. But I changed the user with default schema to another schema, e.g. '
dbo'
> I can't drop that schema with the same error 15150. Thanks
>
Schemas such as dbo and INFORMATION_SCHEMA can't be dropped. What schema are
you dropping?
John|||a user schema called : guest
"John Bell" wrote:

> Hi
> "stephanie" wrote:
>
> Schemas such as dbo and INFORMATION_SCHEMA can't be dropped. What schema a
re
> you dropping?
> John|||Hi
"stephanie" wrote:
[vbcol=seagreen]
> a user schema called : guest
> "John Bell" wrote:
>
Guest seems to be another schema that can't be dropped even if the schema
for the guest user is changed.
John

Fail to drop schema - Error 15150

I want to drop a schema but it shows Fail to drop schema - Error 15150.
I found that there is no object under the schema. Any idea? Thanks in advnace

Hi Stephanie,

Could you please post the exact message that you get?

What is the schema name that you are trying to delete?

Check to see if it owns any objects:

Code Snippet

select count(*) from sys.objects where [schema_id]=schema_id('<schema_name>')

Jag

|||

The following query should show what objects exist under the schema foo

select name from sys.objects where schema_id = schema_id('foo')

union

select name from sys.types where schema_id = schema_id('foo')

union

select name from sys.xml_schema_collections where schema_id = schema_id('foo')

Some schemas are undroppable: sys, dbo, information_schema

hth,

-Steven Gott

S/DET

SQL Server

|||

my schema is called guest and I amended the script

there is no row returned.

Fail to drop schema - Error 15150

I want to drop a schema but it shows Fail to drop schema - Error 15150.
I found that there is no object under the schema. Any idea? Thanks in
advnace
Hi
"stephanie" wrote:

> I want to drop a schema but it shows Fail to drop schema - Error 15150.
> I found that there is no object under the schema. Any idea? Thanks in
> advnace
Is this the default schema for anyone?
SELECT * FROM sys.database_principals
WHERE default_schema_name = 'dbo'
John
|||Yes. But I changed the user with default schema to another schema, e.g. 'dbo'
I can't drop that schema with the same error 15150. Thanks
"John Bell" wrote:

> Hi
> "stephanie" wrote:
>
> Is this the default schema for anyone?
> SELECT * FROM sys.database_principals
> WHERE default_schema_name = 'dbo'
> John
>
|||Hi
"stephanie" wrote:

> Yes. But I changed the user with default schema to another schema, e.g. 'dbo'
> I can't drop that schema with the same error 15150. Thanks
>
Schemas such as dbo and INFORMATION_SCHEMA can't be dropped. What schema are
you dropping?
John
|||a user schema called : guest
"John Bell" wrote:

> Hi
> "stephanie" wrote:
> Schemas such as dbo and INFORMATION_SCHEMA can't be dropped. What schema are
> you dropping?
> John
|||Hi
"stephanie" wrote:
[vbcol=seagreen]
> a user schema called : guest
> "John Bell" wrote:
Guest seems to be another schema that can't be dropped even if the schema
for the guest user is changed.
John

Fail to drop schema - Error 15150

I want to drop a schema but it shows Fail to drop schema - Error 15150.
I found that there is no object under the schema. Any idea? Thanks in
advnaceHi
"stephanie" wrote:
> I want to drop a schema but it shows Fail to drop schema - Error 15150.
> I found that there is no object under the schema. Any idea? Thanks in
> advnace
Is this the default schema for anyone?
SELECT * FROM sys.database_principals
WHERE default_schema_name = 'dbo'
John|||Yes. But I changed the user with default schema to another schema, e.g. 'dbo'
I can't drop that schema with the same error 15150. Thanks
"John Bell" wrote:
> Hi
> "stephanie" wrote:
> > I want to drop a schema but it shows Fail to drop schema - Error 15150.
> > I found that there is no object under the schema. Any idea? Thanks in
> > advnace
> Is this the default schema for anyone?
> SELECT * FROM sys.database_principals
> WHERE default_schema_name = 'dbo'
> John
>|||Hi
"stephanie" wrote:
> Yes. But I changed the user with default schema to another schema, e.g. 'dbo'
> I can't drop that schema with the same error 15150. Thanks
>
Schemas such as dbo and INFORMATION_SCHEMA can't be dropped. What schema are
you dropping?
John|||a user schema called : guest
"John Bell" wrote:
> Hi
> "stephanie" wrote:
> > Yes. But I changed the user with default schema to another schema, e.g. 'dbo'
> > I can't drop that schema with the same error 15150. Thanks
> >
> Schemas such as dbo and INFORMATION_SCHEMA can't be dropped. What schema are
> you dropping?
> John|||Hi
"stephanie" wrote:
> a user schema called : guest
> "John Bell" wrote:
> > Hi
> >
> > "stephanie" wrote:
> >
> > > Yes. But I changed the user with default schema to another schema, e.g. 'dbo'
> > > I can't drop that schema with the same error 15150. Thanks
> > >
> > Schemas such as dbo and INFORMATION_SCHEMA can't be dropped. What schema are
> > you dropping?
> >
> > John
Guest seems to be another schema that can't be dropped even if the schema
for the guest user is changed.
John

Extracting XSD Collection

I've got a really quick - and I'm sure easy - question...

I'm wondering is there any way to extract an XSD Schema collection so that it appears as a well formed XML document?

The only thing I've seen is if you right click on a sche,a collection, you can either script it as a CREATE or a DROP. The CREATE script has no formatting whatsoever - it's all one one line.

If anyone has done this or knows of an effective way to accomplish this, your help would be greatly appreciated!

Thanks!

SELECT xml_schema_namespace('db_SchemaName','XmlSchemaCollectionName')

e.g.: SELECT xml_schema_namespace('dbo','MyXmlSchema')

|||Thanks Phe....!!