Instalation MSDE

When I execute the following instruction
OSQL /USA /P
presents the following error message:
[Microsoft]{ODBC SQL Server Driver][SHARED MEMORY]
SQL Server does not exist or access denied.
[Microsoft]{ODBC SQL Server Driver] Connectionopen
(connect())
Operating system WINDOWS 98 2 Edition
When I verify in the configurations / Panel of Control appeared a new icon
(MSDTC don't remind the acronym). When I execute and requested that selects
the service in what doesn't appear noneEither sa has a non-null password or MSDE is not installed as the default
instance. Use osql /l to list the available servers.
--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:#YYYXxFTDHA.1324@.TK2MSFTNGP11.phx.gbl...
> When I execute the following instruction
> OSQL /USA /P
> presents the following error message:
> [Microsoft]{ODBC SQL Server Driver][SHARED MEMORY]
> SQL Server does not exist or access denied.
> [Microsoft]{ODBC SQL Server Driver] Connectionopen
> (connect())
> Operating system WINDOWS 98 2 Edition
> When I verify in the configurations / Panel of Control appeared a new icon
> (MSDTC don't remind the acronym). When I execute and requested that
selects
> the service in what doesn't appear none
>

Inserting value to Identity Column

I want all users in database to be able to call Set IDENTITY_INSERT
[table] = ON
However when a user who is not the dbo logs in to execute the stored
procedure I get the following error message.
prcIdentityFudgeSave, Line 8
The current user is not the database or object owner of table
'IdentityFudge'. Cannot perform SET operation.
Please Help
(See Stored Prc below that the users are trying to execute)
CREATE PROCEDURE prcIdentityFudgeSave
(
@.IdentityBeforeTrigger int
) AS
--Fudge the Identity Column
delete From IdentityFudge
SET IDENTITY_INSERT IdentityFudge ON
Insert Into IdentityFudge (IndentityFudgeID) values
(@.IdentityBeforeTrigger)
GO> I want all users in database to be able to call Set IDENTITY_INSERT
> [table] = ON
Then why are you using IDENTITY at all?|||give permission to the SQL Server login [SQL Server authentication] / Window
login [Windows Authentication] to acess the table and sp.
"dermot" <dfrench@.tommyfrench.co.uk> wrote in message
news:1110465514.012467.136020@.f14g2000cwb.googlegroups.com...
>I want all users in database to be able to call Set IDENTITY_INSERT
> [table] = ON
> However when a user who is not the dbo logs in to execute the stored
> procedure I get the following error message.
> prcIdentityFudgeSave, Line 8
> The current user is not the database or object owner of table
> 'IdentityFudge'. Cannot perform SET operation.
> Please Help
> (See Stored Prc below that the users are trying to execute)
>
> CREATE PROCEDURE prcIdentityFudgeSave
> (
> @.IdentityBeforeTrigger int
> ) AS
> --Fudge the Identity Column
> delete From IdentityFudge
> SET IDENTITY_INSERT IdentityFudge ON
> Insert Into IdentityFudge (IndentityFudgeID) values
> (@.IdentityBeforeTrigger)
> GO
>|||Joel,
I think that is not enough. See "SET IDENTITY_INSERT (Permissions)" in BOL.
AMB
"Joel Leong" wrote:

> give permission to the SQL Server login [SQL Server authentication] / Wind
ow
> login [Windows Authentication] to acess the table and sp.
> "dermot" <dfrench@.tommyfrench.co.uk> wrote in message
> news:1110465514.012467.136020@.f14g2000cwb.googlegroups.com...
>
>|||If the value in this column has meaning to your users then don't use
IDENTITY. Why would you want to do this?
David Portas
SQL Server MVP
--