Re: Strongly Type Datasets

Which version of SQL Server? If 2005, go to the properties page of the login
you are using (via Management Studio), and check the value for Default
Schema for that login. My guess is that it's not dbo. But this is just a
guess.

"Chris" <nospam@xxxxxxxxxx> wrote in message
news:OxkTYdHoHHA.4124@xxxxxxxxxxxxxxxxxxxxxxx
No I can't find it. Any clues where abouts I might find it. I have looked
on the properties on of the dataset etc.

"KJ" <n_o_s_p_a__M@xxxxxxxx> wrote in message
news:OFjUR$GoHHA.716@xxxxxxxxxxxxxxxxxxxxxxx
Is there a setting for the database "Schema Name" somewhere on the
properties of the data set? That's what's being prepended to the table
name.

"Chris" <nospam@xxxxxxxxxx> wrote in message
news:OdiLaBGoHHA.4412@xxxxxxxxxxxxxxxxxxxxxxx
I am trying to create a strongly typed dataset is VS 2005 with the VS
creating the stored procedures. It won't create the stored procedures.
The SQL script it generates is based on a SQL login so the script looks
something like:

DROP PROCEDURE WebManagerV2.WEB_PAGE_UPDATE

these scripts won't work until I change the script to:

DROP PROCEDURE dbo.WEB_PAGE_UPDATE

What am I doing wrong? I suspect I doing my connectionstring wrong in
some way or my permissions are wrong in SQL Server.

Regards, Chris.







.

Relevant Pages

  • Re: Scripting T-SQL CREATE Statements
    ... a backup of user-defined SQL Server objects. ... I am having a hard time finding the T-SQL functions and system stored procedures used to return the scripted ... like when you right-click an object and select Script Object to New Window as>> Create. ... I am trying to get it much like the instnwnd.sql file that comes with the .NET Framework SDK v1.1. ...
    (microsoft.public.sqlserver.programming)
  • Re: sql connection security
    ... the application has to supply the application login and password ... ... > credentials for SQL Server, ... > Karthik. ... > that you have coded your application using stored procedures, ...
    (microsoft.public.sqlserver.security)
  • Connecting a user from a backup database to a new login
    ... In SQL Server 2000, I loaded a backup file into a new local database. ... The database has an existing user which owns several stored procedures, ... I want to create a login of the same ...
    (microsoft.public.sqlserver.security)
  • Re: Question for Script of users permission.
    ... BUT AS I AM USING THE SCRIPT ON THE MSDE FOR THE LOGIN ... AND PERMISSION OF USERS. ... >> As i have only one SQL server I have check the same on ...
    (microsoft.public.sqlserver.security)
  • Re: sql connection security
    ... The user name that the user uses to login to my system will become the login ... credentials for SQL Server, would it not? ... EXEC permissions on the stored procedures, ... use the APP_NAME function to verify that the connection has ...
    (microsoft.public.sqlserver.security)