Personal SQL Server 2000

Dear Anyone,
I am a member of Microsoft's ISV program. I have a server running Server
2000 and a laptop as my workstation. The server is running SQL Server 2000.
I want to install a desktop version of SQL Server on my laptop to do demos
of my projects.
Do I install from SQL Server Developer Edition or SQL Server 2000
Desktop Engine? Or from something I'm not aware of. Please advise.
Thank you.
James LattanzioYou can install SQL Server Personal Edition. It comes on a separate disk
with SQL Server Standard Edition and SQL Server Enterprise Edition, and is
explicitly licensed for doing demos of a product that requires SQL Server.
--
Jacco Schalkwijk
SQL Server MVP
"James Lattanzio" <europacg@.erols.com> wrote in message
news:403bb7f1$0$3079$61fed72c@.news.rcn.com...
> Dear Anyone,
> I am a member of Microsoft's ISV program. I have a server running
Server
> 2000 and a laptop as my workstation. The server is running SQL Server
2000.
> I want to install a desktop version of SQL Server on my laptop to do demos
> of my projects.
> Do I install from SQL Server Developer Edition or SQL Server 2000
> Desktop Engine? Or from something I'm not aware of. Please advise.
> Thank you.
> James Lattanzio
>|||The developer edition would work if you have it. If you just want to =demo your app, then MSDE (the desktop engine) is probably all you need. =Keep in mind that MSDE does not ship with any GUI management tools. You =will have to use osql.exe.
-- Keith
"James Lattanzio" <europacg@.erols.com> wrote in message =news:403bb7f1$0$3079$61fed72c@.news.rcn.com...
> Dear Anyone,
> > I am a member of Microsoft's ISV program. I have a server running =Server
> 2000 and a laptop as my workstation. The server is running SQL Server =2000.
> I want to install a desktop version of SQL Server on my laptop to do =demos
> of my projects.
> > Do I install from SQL Server Developer Edition or SQL Server 2000
> Desktop Engine? Or from something I'm not aware of. Please advise.
> > Thank you.
> > James Lattanzio
> >sql

Personal SQL Server 2000

Dear Anyone,
I am a member of Microsoft's ISV program. I have a server running Server
2000 and a laptop as my workstation. The server is running SQL Server 2000.
I want to install a desktop version of SQL Server on my laptop to do demos
of my projects.
Do I install from SQL Server Developer Edition or SQL Server 2000
Desktop Engine? Or from something I'm not aware of. Please advise.
Thank you.
James LattanzioYou can install SQL Server Personal Edition. It comes on a separate disk
with SQL Server Standard Edition and SQL Server Enterprise Edition, and is
explicitly licensed for doing demos of a product that requires SQL Server.
Jacco Schalkwijk
SQL Server MVP
"James Lattanzio" <europacg@.erols.com> wrote in message
news:403bb7f1$0$3079$61fed72c@.news.rcn.com...
> Dear Anyone,
> I am a member of Microsoft's ISV program. I have a server running
Server
> 2000 and a laptop as my workstation. The server is running SQL Server
2000.
> I want to install a desktop version of SQL Server on my laptop to do demos
> of my projects.
> Do I install from SQL Server Developer Edition or SQL Server 2000
> Desktop Engine? Or from something I'm not aware of. Please advise.
> Thank you.
> James Lattanzio
>|||The developer edition would work if you have it. If you just want to =
demo your app, then MSDE (the desktop engine) is probably all you need. =
Keep in mind that MSDE does not ship with any GUI management tools. You =
will have to use osql.exe.
--=20
Keith
"James Lattanzio" <europacg@.erols.com> wrote in message =
news:403bb7f1$0$3079$61fed72c@.news.rcn.com...
> Dear Anyone,
>=20
> I am a member of Microsoft's ISV program. I have a server running =
Server
> 2000 and a laptop as my workstation. The server is running SQL Server =
2000.
> I want to install a desktop version of SQL Server on my laptop to do =
demos
> of my projects.
>=20
> Do I install from SQL Server Developer Edition or SQL Server 2000
> Desktop Engine? Or from something I'm not aware of. Please advise.
>=20
> Thank you.
>=20
> James Lattanzio
>=20
>

Permission to execute fn_get_sql

Dear All,

I want to assign privelege to execute the following in SQL Server 2000 SP4 + 2187

select * from ::fn_get_sql(0x01000700AC38820138A1786C0400000000000000)

I have tried the following:-

use master

go

grant select on fn_get_sql to <user>

I am getting error:

Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'fn_get_sql'.

I believe that ::fn_get_sql is an administrative use only function, and that permission is limited to either sysadmin or db_databaseowner. (I think the former...)

|||

You require VIEW SERVER STATE permission to use it. Please refer to BOL (http://msdn2.microsoft.com/en-us/library/ms189451.aspx) for detailed information.

-Raul Garcia

SDE/T

SQL Server Engine

Permission Issues

Dear all,

I created a login name xxx and assigned few permisson on database <xyz>.

Now i want to grant execute permission to user xxx on extended stored procedure xp_cmdshell.

Without creating user in master database is there other way to grant the same to user xxx.

Regards

Mohd Sufian

Using xp_cmdshell requires a high level of permissions.

You can create a proxy account for xp_cmdshell, put the use of xp_cmdshell into a stored procedure, and then give your user permission for the stored procedure.

Check in Books Online about xp_cmdshell and proxy accounts.

Permission issues

Dear all,

I have 500 tables in a database.

How can i grant select ,update and insert permission to a user on all 500 tables of the database at once.

Thanks

Mohd Sufian

The fixed database role db_datareader will work for SELECT.

You can use a cursor. ...might want to use sp_executesql

DECLARE @.User sysname

DECLARE @.Table nvarchar(500)

DECLARE @.cmd nvarchar(2000)

SET @.User = 'MyUser'

SET @.cmd = ''

DECLARE GrantUser CURSOR

LOCAL

FAST_FORWARD

FOR

SELECT s.Name + + '.' + o.name

FROM sys.objects o

INNER JOIN sys.schemas s

ON o.schema_id =s.schema_id

WHERE type = 'U'

IF EXISTS (SELECT * FROM sys.sysusers WHERE name = @.User)

BEGIN

OPEN GrantUser

FETCH NEXT FROM GrantUser INTO @.Table

WHILE @.@.FETCH_STATUS = 0

BEGIN

SET @.cmd = ''

SET @.cmd = ' GRANT SELECT ON ' + @.Table + ' TO' + @.User

SET @.cmd = @.cmd + ' GRANT UPDATE ON ' + @.Table + ' TO' + @.User

SET @.cmd = @.cmd + ' GRANT INSERT ON ' + @.Table + ' TO' + @.User

EXEC (@.cmd)

FETCH NEXT FROM GrantUser INTO @.Table

END

CLOSE GrantUser

DEALLOCATE GrantUser

END

|||

If this is SQL SERVER 2005, you can grant all these permissions at the database level itself.

So,

GRANT INSERT ON DATABASE::Database_Name to User_Name

GRANT UPDATE ON DATABASE::Database_Name to User_Name

GRANT SELECT ON DATABASE::Database_Name to User_Name

You must be connected to the database on which you are granting the permissions

Permission for Linked Server User

Dear,

What minimum permission do i need to grant to a Remote Login to create a linked server.

Regards

Sufian

I think you will need to use the sp_addlinkedsrvlogin proc to add the login to the linked server.

The minimum permissions for this is alter any login in SQL 2005.

To add the linked Server use the sp_addlinkedserver proc.

The minimum permission for this proc is alter any linked server

HTH,

-Steven Gott

SDE/T

SQL Server

|||

I have created a User say XXX with default database <master> with no other permission apart from Connect.

What other permission do i need to grant to user so that i can use that user as a remote Login in linked Server.

regards

sufian

|||

I am pretty sure you need to grant alter any login and alter any linked server to the login for the user XXX

I did a quick search and found a related article that may help

http://www.databasejournal.com/features/mssql/article.php/3691721

HTH,

-Steven Gott

SDE/T

SQL Server

|||

Hi Steven,

Thanks for the link it helped in better understanding of Linked Server.

My question is still pending regarding the permission to user used in making connection to the remote server?

Well i got the resolution.

We have to grant only two permission to the user to use it in linked server creation.

GRANT CONTROL SERVER TO LinkedServer_User;

GRANT ALTER ANY LINKED SERVER to LinkedServer_User;

regards

Sufian

|||

Sufian,

The CONTROL SERVER permission implies ALTER ANY LINKED SERVER so if you really need CONTROL SERVER that permission alone should suffice.

I am surprised that this doesn't work:

GRANT ALTER ANY LINKED SERVER TO LinkedServer_User;

GRANT ALTER ANY LOGIN TO LinkedServer_User;

Can you confirm that this doesn't work? If it doesn't then I can open a bug with the product group.

Thanks,

-Steven Gott

SDE/T

SQL Server

|||

Created a new user abc and given readonly access to one database x only.

No other permission a part from DataReader to abc.

Created new linked server giving the username and password in the (Be made using the security context) option.

Linked server created successfully.

and i can only see the database on which user have read only access.

After granting below mentioed permission no effect on cataloge

GRANT ALTER ANY LINKED SERVER TO LinkedServer_User;

GRANT ALTER ANY LOGIN TO LinkedServer_User;

Well i think i need to give access to user on other databases also.

Please open a bug if it is.

Regards

Sufian

Permission for Linked Server User

Dear,

What minimum permission do i need to grant to a Remote Login to create a linked server.

Regards

Sufian

I think you will need to use the sp_addlinkedsrvlogin proc to add the login to the linked server.

The minimum permissions for this is alter any login in SQL 2005.

To add the linked Server use the sp_addlinkedserver proc.

The minimum permission for this proc is alter any linked server

HTH,

-Steven Gott

SDE/T

SQL Server

|||

I have created a User say XXX with default database <master> with no other permission apart from Connect.

What other permission do i need to grant to user so that i can use that user as a remote Login in linked Server.

regards

sufian

|||

I am pretty sure you need to grant alter any login and alter any linked server to the login for the user XXX

I did a quick search and found a related article that may help

http://www.databasejournal.com/features/mssql/article.php/3691721

HTH,

-Steven Gott

SDE/T

SQL Server

|||

Hi Steven,

Thanks for the link it helped in better understanding of Linked Server.

My question is still pending regarding the permission to user used in making connection to the remote server?

Well i got the resolution.

We have to grant only two permission to the user to use it in linked server creation.

GRANT CONTROL SERVER TO LinkedServer_User;

GRANT ALTER ANY LINKED SERVER to LinkedServer_User;

regards

Sufian

|||

Sufian,

The CONTROL SERVER permission implies ALTER ANY LINKED SERVER so if you really need CONTROL SERVER that permission alone should suffice.

I am surprised that this doesn't work:

GRANT ALTER ANY LINKED SERVER TO LinkedServer_User;

GRANT ALTER ANY LOGIN TO LinkedServer_User;

Can you confirm that this doesn't work? If it doesn't then I can open a bug with the product group.

Thanks,

-Steven Gott

SDE/T

SQL Server

|||

Created a new user abc and given readonly access to one database x only.

No other permission a part from DataReader to abc.

Created new linked server giving the username and password in the (Be made using the security context) option.

Linked server created successfully.

and i can only see the database on which user have read only access.

After granting below mentioed permission no effect on cataloge

GRANT ALTER ANY LINKED SERVER TO LinkedServer_User;

GRANT ALTER ANY LOGIN TO LinkedServer_User;

Well i think i need to give access to user on other databases also.

Please open a bug if it is.

Regards

Sufian

Permission for Linked Server User

Dear,

What minimum permission do i need to grant to a Remote Login to create a linked server.

Regards

Sufian

I think you will need to use the sp_addlinkedsrvlogin proc to add the login to the linked server.

The minimum permissions for this is alter any login in SQL 2005.

To add the linked Server use the sp_addlinkedserver proc.

The minimum permission for this proc is alter any linked server

HTH,

-Steven Gott

SDE/T

SQL Server

|||

I have created a User say XXX with default database <master> with no other permission apart from Connect.

What other permission do i need to grant to user so that i can use that user as a remote Login in linked Server.

regards

sufian

|||

I am pretty sure you need to grant alter any login and alter any linked server to the login for the user XXX

I did a quick search and found a related article that may help

http://www.databasejournal.com/features/mssql/article.php/3691721

HTH,

-Steven Gott

SDE/T

SQL Server

|||

Hi Steven,

Thanks for the link it helped in better understanding of Linked Server.

My question is still pending regarding the permission to user used in making connection to the remote server?

Well i got the resolution.

We have to grant only two permission to the user to use it in linked server creation.

GRANT CONTROL SERVER TO LinkedServer_User;

GRANT ALTER ANY LINKED SERVER to LinkedServer_User;

regards

Sufian

|||

Sufian,

The CONTROL SERVER permission implies ALTER ANY LINKED SERVER so if you really need CONTROL SERVER that permission alone should suffice.

I am surprised that this doesn't work:

GRANT ALTER ANY LINKED SERVER TO LinkedServer_User;

GRANT ALTER ANY LOGIN TO LinkedServer_User;

Can you confirm that this doesn't work? If it doesn't then I can open a bug with the product group.

Thanks,

-Steven Gott

SDE/T

SQL Server

|||

Created a new user abc and given readonly access to one database x only.

No other permission a part from DataReader to abc.

Created new linked server giving the username and password in the (Be made using the security context) option.

Linked server created successfully.

and i can only see the database on which user have read only access.

After granting below mentioed permission no effect on cataloge

GRANT ALTER ANY LINKED SERVER TO LinkedServer_User;

GRANT ALTER ANY LOGIN TO LinkedServer_User;

Well i think i need to give access to user on other databases also.

Please open a bug if it is.

Regards

Sufian

permission

Dear all
what account permission can run script and backup database ? not sa account
thx
Look for
db_backupoperator Has permission to back up the database.
in BOL
HTH, Jens Suessmeyer.
"123" wrote:

> Dear all
> what account permission can run script and backup database ? not sa account
> thx
>
|||Hi,
To add on to Jens, you could also give the below GRANT permission
exclusevely to a User to BACKUP the database.
GRANT BACKUP DATABASE TO <User_name>
For Transaction Log
GRANT BACKUP LOG TO <USER_Name>
Thanks
Hari
SQL Server MVP
"Jens Smeyer" <JensSmeyer@.discussions.microsoft.com> wrote in message
news:72DC1ABC-B9E5-492A-921D-62E479457462@.microsoft.com...[vbcol=seagreen]
> Look for
> db_backupoperator Has permission to back up the database.
> in BOL
> HTH, Jens Suessmeyer.
>
> "123" wrote:

permission

Dear all
what account permission can run script and backup database ? not sa account
thxLook for
db_backupoperator Has permission to back up the database.
in BOL
HTH, Jens Suessmeyer.
"123" wrote:
> Dear all
> what account permission can run script and backup database ? not sa account
> thx
>|||Hi,
To add on to Jens, you could also give the below GRANT permission
exclusevely to a User to BACKUP the database.
GRANT BACKUP DATABASE TO <User_name>
For Transaction Log
GRANT BACKUP LOG TO <USER_Name>
Thanks
Hari
SQL Server MVP
"Jens Süßmeyer" <JensSmeyer@.discussions.microsoft.com> wrote in message
news:72DC1ABC-B9E5-492A-921D-62E479457462@.microsoft.com...
> Look for
> db_backupoperator Has permission to back up the database.
> in BOL
> HTH, Jens Suessmeyer.
>
> "123" wrote:
>> Dear all
>> what account permission can run script and backup database ? not sa
>> account
>> thx
>>