3G ram for SQL server: step

Showing posts with label step. Show all posts

Sunday, March 25, 2012

A couple of quick questions about SQL Server 6.5

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?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
"Russell" <Russell@.discussions.microsoft.com> wrote in message
news:515AAE7C-B95F-4573-BD41-1BFB037F84D1@.microsoft.com...
> 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?|||> 1. I think you would need to look at writing your own that queries the
> sysprotects/sysusers tables.
Or perhaps sp_helprotect?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%230$dreinEHA.3152@.TK2MSFTNGP10.phx.gbl...
> 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
> "Russell" <Russell@.discussions.microsoft.com> wrote in message
> news:515AAE7C-B95F-4573-BD41-1BFB037F84D1@.microsoft.com...
>> 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?
>|||Hi Tibor
I didn't think that was in 6.5?
John
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OwymtcknEHA.3464@.tk2msftngp13.phx.gbl...
> > 1. I think you would need to look at writing your own that queries the
> > sysprotects/sysusers tables.
>
> Or perhaps sp_helprotect?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%230$dreinEHA.3152@.TK2MSFTNGP10.phx.gbl...
> > 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
> >
> > "Russell" <Russell@.discussions.microsoft.com> wrote in message
> > news:515AAE7C-B95F-4573-BD41-1BFB037F84D1@.microsoft.com...
> >> 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?
> >
> >
>|||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/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:ens2aOmnEHA.3392@.TK2MSFTNGP15.phx.gbl...
> Hi Tibor
> I didn't think that was in 6.5?
> John
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:OwymtcknEHA.3464@.tk2msftngp13.phx.gbl...
>> > 1. I think you would need to look at writing your own that queries the
>> > sysprotects/sysusers tables.
>>
>> Or perhaps sp_helprotect?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:%230$dreinEHA.3152@.TK2MSFTNGP10.phx.gbl...
>> > 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
>> >
>> > "Russell" <Russell@.discussions.microsoft.com> wrote in message
>> > news:515AAE7C-B95F-4573-BD41-1BFB037F84D1@.microsoft.com...
>> >> 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?
>> >
>> >
>>
>|||sp_helprotect has been around since since the beginning.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%234k4pTmnEHA.3988@.tk2msftngp13.phx.gbl...
> 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/
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:ens2aOmnEHA.3392@.TK2MSFTNGP15.phx.gbl...
>> Hi Tibor
>> I didn't think that was in 6.5?
>> John
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in
>> message news:OwymtcknEHA.3464@.tk2msftngp13.phx.gbl...
>> > 1. I think you would need to look at writing your own that queries the
>> > sysprotects/sysusers tables.
>>
>> Or perhaps sp_helprotect?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:%230$dreinEHA.3152@.TK2MSFTNGP10.phx.gbl...
>> > 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
>> >
>> > "Russell" <Russell@.discussions.microsoft.com> wrote in message
>> > news:515AAE7C-B95F-4573-BD41-1BFB037F84D1@.microsoft.com...
>> >> 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?
>> >
>> >
>>
>>
>

Tuesday, March 20, 2012

a beginners question about linking data

I have just started (yesterday) to use Crystal Reports. I'm almost embarest to ask this question, it may be a simple step or it maybe impossible.

I'm trying to make a report that will show a trend over three months.
My question is, I have a folder named "database", in that folder are 500 folders. Each folder is a workorder that has going through the plant. Can I pull data out of each of these 500 folders into one report? If so could someone point me in the right direction. I can get the data from one of the work order folders but don't know how to get it from all of them.

The database folder contains two .db files, two .px files and one .net file, and the other 500 folders. the work order folders, contains 16 .db files, 16 .px files (there all refre to different processes in the workorder), one .ini file, and one .mb file.

And the database is on my harddrive.

any advise would be apreciated.I'm afraid that you have to develop a small application to read the data from all the folders and save it in a new file and then use crystal reports

By the way, your data is a paradox database|||That's what I was afraid of. Could you tell what kind of application it would be? If I knew what it was, there maybe something in the appliction that we use to collect the data. It already has templates for crystal reports for a single work order, this I found by digging around in application files.

I knew the database was a paradox from reading the help files in crystal, but I don't really know that must (yet) about databases.

Thanks jggtz of the reply.|||Would I need something like MySQL?|||My advice is that you find help close around you from somebody that already know some programming language, like Visual Basic, to help you to develop that small an easy application that collect data from all the desired folders and print the reports
Or
As you said before, maybe there is an "Export" option in the application you use to collect data and that could be helpful if it has the right features
Or
If you want to work a liitle more, you can attach (link) to Access all the neccesary .db files and manually (or by a sql query) append all the data into a single one table to then print the reports

Sunday, March 25, 2012

A couple of quick questions about SQL Server 6.5

A couple of quick questions about SQL Server 6.5

Tuesday, March 20, 2012

a beginners question about linking data

a beginners question about linking data

3G ram for SQL server

Blog Archive

About Me