SQL Server, A couple of quick questions about SQL Server 6.5

microsoft.public.sqlserver.server - Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.


SQL Server >> A couple of quick questions about SQL Server 6.5

by UnVzc2VsbA » Sun, 19 Sep 2004 00:23:03 GMT

I have a couple of quick questions to do with SQL 6.5.

1. Is there a stored proc that I can use in conjunction with
sp_foreachtable to step though all the user tables and list the permissions
that the public role has.

2. When I use the generate SQL Script , to have it script up all the
logins,users and permissions. I then look at the resulting script and it seem
to set all the passwords to (Null). Is there a way to have the passwords
intact?

Top

SQL Server >> A couple of quick questions about SQL Server 6.5

by John Bell » Sun, 19 Sep 2004 17:11:21 GMT


Hi

1. I think you would need to look at writing your own that queries the
sysprotects/sysusers tables.

2. I believe this is by design. You may want to look at:
http://tinyurl.com/5yw77

John



permissions
seem




Top

SQL Server >> A couple of quick questions about SQL Server 6.5

by Tibor Karaszi » Sun, 19 Sep 2004 20:50:08 GMT

> 1. I think you would need to look at writing your own that queries the


Or perhaps sp_helprotect?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/









Top

A couple of quick questions about SQL Server 6.5

by John Bell » Mon, 20 Sep 2004 00:14:20 GMT

Hi Tibor

I didn't think that was in 6.5?

John

"Tibor Karaszi" < XXXX@XXXXX.COM > wrote in





it
passwords



Top

A couple of quick questions about SQL Server 6.5

by Tibor Karaszi » Mon, 20 Sep 2004 00:22:50 GMT

Hi John,

To be honest, I'm not 100% certain. But if I'd guess, I'd guess that the proc did exist in 6.5.
Due to a disk crash, I don't have my VM Ware images with 6.5 anymore, so I guess we'll wait until
someone with 6.5 or 6.5 BOL can tell us for certain. :-)

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/












Top

A couple of quick questions about SQL Server 6.5

by Kalen Delaney » Mon, 20 Sep 2004 00:31:44 GMT

sp_helprotect has been around since since the beginning.
--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com


"Tibor Karaszi" < XXXX@XXXXX.COM > wrote in











Top
Similar Threads

1. Quick 6.5 question 

Does anyone know the maximum number of rows a SQL 6.5 
table can hold..
I've got an old 3rd party app suddenly throwing out lots 
of these errors - 'The server could not expand a table 
because the table reached the maximum size. '


Thanks in advance.

2. Two questions about SQL Server 6.5

3. sql server 6.5 question: it runs out of locks 

I know that nobody supports 6.5 any more, but we still do have some 
production servers on this version. Application is old, and not supported any 
more, so we are not sure if it would work with the new version of sql server. 

Recently, we ran ito this issue, from time to time, server runs out of 
locks. We didn;t change anything (locks is set to default, 5000), and actual 
number of locks is not more than 10-15 at the moment when we're getting this 
message.
Service pack level is 5a.

Did anybody ran accross this issue before? Does anybody know if there is 
some tool equivalent to profiler on this version? Any ideas?

Thanks in advance,
Pedja

4. A couple SQL Server 2000 Questions - SQL Server

5. SQL 6.5 to SQL 2000 performance question 

We are running SQL Server in 6.5 compatability mode.  We have some queries
that are supported in 2000, that is the reason for the 6.5 version.  What,
if any, would be gained in performance by switching to 2000.

6. Problema para actualizar SQL Server 6.5 a SQL Server 2000 en Windows 2000 Server

7. Problem upgrade sql server 6.5 to sql server 2000 enterprise edition on Windows 2000 Server 

Hello,

I have problems with upgrade sql server 6.5 to sql server 2000
enterprise edition on Windows 2000 Server.

I have in the server, sql server 6.5 with service pack 5a and sql
server 2000 enterprise edition with service pack 4 - both in
spanish-.

But when I try to run the 'Wizard to upgrade sql server', I have
received the following error : " The export server must be running
Microsoft SQL Server 6.5 ".

I did everything that the procedure say but I haven't had luck.  I
need to solve this problem as soon as possible and I don find the
solution.

Thanks and Regards,

8. (Hopefully) Easy SQL 6.5 Question - Getting Table Structure