getting logins and users for all server in the enterprise

I am trying to mantain a database of all logins and users, Please help, is
there a way I can populate a spreadsheet with all the users and logins for t
he entire enterprise. We have over 30 installations of sql server, doing it
singly using sp_helplogins
or sp_helpuser for each server will be very difficultHi,
You can write a small batch file and redirect the output to a file.
OSQL -Usa -Ppassword -Sservername -d master -Q"select name from syslogins"
>c:\users\logins.txt
OSQL -Usa -Ppassword -Sservername -d master -Q"select name from syslogins"
OSQL -Usa -Ppassword -Sservername -d master -Q"select name from syslogins"[vbcol=seagreen]
Do the same for all servers.
If you need all the logins and the database users associated then:-
OSQL -Usa -Ppassword -Sservername -d master -Q"sp_helplogins"[vbcol=seagreen]
>c:\users\logins.txt
OSQL -Usa -Ppassword -Sservername -d master-Q"sp_helplogins"
OSQL -Usa -Ppassword -Sservername -d master -Q"sp_helplogins"[vbcol=seagreen]
Do the same for all servers.
Save this as a batch file and run when ever you require
Thanks
Hari
MCDBA
"zukky" <zukky@.discussions.microsoft.com> wrote in message
news:BADF8A1F-722D-48AF-A2F5-6C1FC2A92B03@.microsoft.com...[vbcol=seagreen]
> I am trying to mantain a database of all logins and users, Please help,
is there a way I can populate a spreadsheet with all the users and logins
for the entire enterprise. We have over 30 installations of sql server,
doing it singly using sp_helplogins or sp_helpuser for each server will be
very difficult

Getting list of database table names, columns, etc?

Is there a way using MS SQL Server and Enterprise Manager to get a text
document (or perhaps even a Word document) listing all table names,
column names, etc of a database?
--
Sugapablo
--
http://www.sugapablo.com <--music
http://www.sugapablo.net <--personalNo, but you can query the system views like INFORMATION_SCHEMA.TABLES and
INFORMATION_SCHEMA.COLUMNSto get a list of all tables and their columns. You
could probably use the query from DTS to create a text document.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Sugapablo" <russREMOVE@.sugapablo.com> wrote in message
news:vmu9gbqqkhfd84@.corp.supernews.com...
Is there a way using MS SQL Server and Enterprise Manager to get a text
document (or perhaps even a Word document) listing all table names,
column names, etc of a database?
--
Sugapablo
--
http://www.sugapablo.com <--music
http://www.sugapablo.net <--personal|||Narayana Vyas Kondreddi wrote:
> No, but you can query the system views like INFORMATION_SCHEMA.TABLES and
> INFORMATION_SCHEMA.COLUMNSto get a list of all tables and their columns. You
> could probably use the query from DTS to create a text document.
Well that sucks. :)
What I did was to dump the SQL into a .sql file (you know, listing the
CREATE TABLE commands).
Everything is there, it just looks real ugly.
I'm surprised MS SQL doesn't have this simple function, like
PostgreSQL's "/d *".
--
Sugapablo
--
http://www.sugapablo.com <--music
http://www.sugapablo.net <--personal|||Looks like you scripted the tables. But your original mail says, you wanted
to get a list of table and column names, which can be accomplished with the
following query:
SELECT TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
ORDER BY TABLE_NAME, COLUMN_NAME
The results can be directly saved as a text file, from within Query
Analyzer.
What you are asking for is not really the function of a database engine.
It's more of an application thing and there are a lot of third party
database documentation tools out there. One example: fmsinc.com
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Sugapablo" <russREMOVE@.sugapablo.com> wrote in message
news:vmubrmo29o44ca@.corp.supernews.com...
Narayana Vyas Kondreddi wrote:
> No, but you can query the system views like INFORMATION_SCHEMA.TABLES and
> INFORMATION_SCHEMA.COLUMNSto get a list of all tables and their columns.
You
> could probably use the query from DTS to create a text document.
Well that sucks. :)
What I did was to dump the SQL into a .sql file (you know, listing the
CREATE TABLE commands).
Everything is there, it just looks real ugly.
I'm surprised MS SQL doesn't have this simple function, like
PostgreSQL's "/d *".
--
Sugapablo
--
http://www.sugapablo.com <--music
http://www.sugapablo.net <--personal

Getting it right ! - Enterprise manager

A little question to make sure I get it right.
You cannot update records using Enterprise manager!
Or can you?You can, but shouldn't. Use Query Analyzer.
"benoit" <benoit@.discussions.microsoft.com> wrote in message
news:90B9EC08-D75F-461B-B40B-3E02EC9BE352@.microsoft.com...
>A little question to make sure I get it right.
> You cannot update records using Enterprise manager!
> Or can you?|||Hi,
NO. We can update records using EM.
open the rows and then edit the records
Regards,
Herbert
"benoit" wrote:

> A little question to make sure I get it right.
> You cannot update records using Enterprise manager!
> Or can you?|||Yes you can.
"benoit" <benoit@.discussions.microsoft.com> wrote in message
news:90B9EC08-D75F-461B-B40B-3E02EC9BE352@.microsoft.com...
>A little question to make sure I get it right.
> You cannot update records using Enterprise manager!
> Or can you?

Getting full security log

I'm administering serveral sqlserversin our company.
Most off the servers are in different domains. For the Enterprise Manager
that's no problem, you can register any server with it's ipnumber or name.
But on all the servers which are not in the same domain, it's security log
is getting full with the audit failure entry's.
How can I avoid this ? Is the enterprise manager doing something 'under
water' ?
Thanks in advance,
T. LeerIt could just be the polling of the servers from Enterprise
Manage so you can try turning that off. In Enterprise
Manager, go to the menu to Tools, select Options. On the
General Tab, remove the check for Server State Polling.
-Sue
On Tue, 19 Oct 2004 13:21:43 +0200, "Ton"
<t.leer@.wanadoo.nl> wrote:

>I'm administering serveral sqlserversin our company.
>Most off the servers are in different domains. For the Enterprise Manager
>that's no problem, you can register any server with it's ipnumber or name.
>But on all the servers which are not in the same domain, it's security log
>is getting full with the audit failure entry's.
>How can I avoid this ? Is the enterprise manager doing something 'under
>water' ?
>Thanks in advance,
>T. Leer
>

Getting full security log

I'm administering serveral sqlserversin our company.
Most off the servers are in different domains. For the Enterprise Manager
that's no problem, you can register any server with it's ipnumber or name.
But on all the servers which are not in the same domain, it's security log
is getting full with the audit failure entry's.
How can I avoid this ? Is the enterprise manager doing something 'under
water' ?
Thanks in advance,
T. Leer
It could just be the polling of the servers from Enterprise
Manage so you can try turning that off. In Enterprise
Manager, go to the menu to Tools, select Options. On the
General Tab, remove the check for Server State Polling.
-Sue
On Tue, 19 Oct 2004 13:21:43 +0200, "Ton"
<t.leer@.wanadoo.nl> wrote:

>I'm administering serveral sqlserversin our company.
>Most off the servers are in different domains. For the Enterprise Manager
>that's no problem, you can register any server with it's ipnumber or name.
>But on all the servers which are not in the same domain, it's security log
>is getting full with the audit failure entry's.
>How can I avoid this ? Is the enterprise manager doing something 'under
>water' ?
>Thanks in advance,
>T. Leer
>

Getting error in Enterprise Manager Taskpad view

I continue to get this error whenever i try to use the Taskpad view of a
database in my SQL Server Entriprise Manager.
"An Error has occurred in the script on this page
Line: 307
Char: 2
Error: Unspecified Error
Code: 0
URL:
res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Too ls\Binn\Resources\1033\sqlmmc.rll/Tabs.html
Do you want to continue running scripts on this page?"
with Yes and No buttons.
No matter whether i click on Yes or No, the error box goes away, and the
view i am trying to create never visualizes. The information that is usually
there is not there.
Has anyone else ever seen this error message? Any clues as to what is
causing it? I'd like to get this view back. I found it quite helpful for a
quick reference.
thanks in advance,
Kay
Kay,
Right click on the database name in EM, then select 'View', then select any
of the four top options (Large Icon, Small Icon, List or Detail). Once the
pane is refreshed, then:
Right click on the database name in EM, then select 'View', then select
'Taskpad'
The Taskpad pane will then reappear. Not sure why, but it has been like
this for quite sometime.
"Kay" wrote:

> I continue to get this error whenever i try to use the Taskpad view of a
> database in my SQL Server Entriprise Manager.
> "An Error has occurred in the script on this page
> Line: 307
> Char: 2
> Error: Unspecified Error
> Code: 0
> URL:
> res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Too ls\Binn\Resources\1033\sqlmmc.rll/Tabs.html
> Do you want to continue running scripts on this page?"
> with Yes and No buttons.
> No matter whether i click on Yes or No, the error box goes away, and the
> view i am trying to create never visualizes. The information that is usually
> there is not there.
> Has anyone else ever seen this error message? Any clues as to what is
> causing it? I'd like to get this view back. I found it quite helpful for a
> quick reference.
> thanks in advance,
> Kay
> --
|||Thanks so much... who'da thought it coulda been so simple :-)
"NetByTelDBA" wrote:
[vbcol=seagreen]
> Kay,
> Right click on the database name in EM, then select 'View', then select any
> of the four top options (Large Icon, Small Icon, List or Detail). Once the
> pane is refreshed, then:
> Right click on the database name in EM, then select 'View', then select
> 'Taskpad'
> The Taskpad pane will then reappear. Not sure why, but it has been like
> this for quite sometime.
>
> "Kay" wrote:

Getting error in Enterprise Manager Taskpad view

I continue to get this error whenever i try to use the Taskpad view of a
database in my SQL Server Entriprise Manager.
"An Error has occurred in the script on this page
Line: 307
Char: 2
Error: Unspecified Error
Code: 0
URL:
res:// C:\Program%20Files\Microsoft%20SQL%20Ser
ver\80\Tools\Binn\Resources\10
33\sqlmmc.rll/Tabs.html
Do you want to continue running scripts on this page?"
with Yes and No buttons.
No matter whether i click on Yes or No, the error box goes away, and the
view i am trying to create never visualizes. The information that is usuall
y
there is not there.
Has anyone else ever seen this error message? Any clues as to what is
causing it? I'd like to get this view back. I found it quite helpful for a
quick reference.
thanks in advance,
KayKay,
Right click on the database name in EM, then select 'View', then select any
of the four top options (Large Icon, Small Icon, List or Detail). Once the
pane is refreshed, then:
Right click on the database name in EM, then select 'View', then select
'Taskpad'
The Taskpad pane will then reappear. Not sure why, but it has been like
this for quite sometime.
"Kay" wrote:

> I continue to get this error whenever i try to use the Taskpad view of a
> database in my SQL Server Entriprise Manager.
> "An Error has occurred in the script on this page
> Line: 307
> Char: 2
> Error: Unspecified Error
> Code: 0
> URL:
> res:// C:\Program%20Files\Microsoft%20SQL%20Ser
ver\80\Tools\Binn\Resources\
1033\sqlmmc.rll/Tabs.html
> Do you want to continue running scripts on this page?"
> with Yes and No buttons.
> No matter whether i click on Yes or No, the error box goes away, and the
> view i am trying to create never visualizes. The information that is usua
lly
> there is not there.
> Has anyone else ever seen this error message? Any clues as to what is
> causing it? I'd like to get this view back. I found it quite helpful for
a
> quick reference.
> thanks in advance,
> Kay
> --|||Thanks so much... who'da thought it coulda been so simple :-)
--
"NetByTelDBA" wrote:
[vbcol=seagreen]
> Kay,
> Right click on the database name in EM, then select 'View', then select an
y
> of the four top options (Large Icon, Small Icon, List or Detail). Once th
e
> pane is refreshed, then:
> Right click on the database name in EM, then select 'View', then select
> 'Taskpad'
> The Taskpad pane will then reappear. Not sure why, but it has been like
> this for quite sometime.
>
> "Kay" wrote:
>

Getting error in Enterprise Manager Taskpad view

I continue to get this error whenever i try to use the Taskpad view of a
database in my SQL Server Entriprise Manager.
"An Error has occurred in the script on this page
Line: 307
Char: 2
Error: Unspecified Error
Code: 0
URL:
res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\1033\sqlmmc.rll/Tabs.html
Do you want to continue running scripts on this page?"
with Yes and No buttons.
No matter whether i click on Yes or No, the error box goes away, and the
view i am trying to create never visualizes. The information that is usually
there is not there.
Has anyone else ever seen this error message? Any clues as to what is
causing it? I'd like to get this view back. I found it quite helpful for a
quick reference.
thanks in advance,
Kay
--Kay,
Right click on the database name in EM, then select 'View', then select any
of the four top options (Large Icon, Small Icon, List or Detail). Once the
pane is refreshed, then:
Right click on the database name in EM, then select 'View', then select
'Taskpad'
The Taskpad pane will then reappear. Not sure why, but it has been like
this for quite sometime.
"Kay" wrote:
> I continue to get this error whenever i try to use the Taskpad view of a
> database in my SQL Server Entriprise Manager.
> "An Error has occurred in the script on this page
> Line: 307
> Char: 2
> Error: Unspecified Error
> Code: 0
> URL:
> res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\1033\sqlmmc.rll/Tabs.html
> Do you want to continue running scripts on this page?"
> with Yes and No buttons.
> No matter whether i click on Yes or No, the error box goes away, and the
> view i am trying to create never visualizes. The information that is usually
> there is not there.
> Has anyone else ever seen this error message? Any clues as to what is
> causing it? I'd like to get this view back. I found it quite helpful for a
> quick reference.
> thanks in advance,
> Kay
> --|||Thanks so much... who'da thought it coulda been so simple :-)
--
"NetByTelDBA" wrote:
> Kay,
> Right click on the database name in EM, then select 'View', then select any
> of the four top options (Large Icon, Small Icon, List or Detail). Once the
> pane is refreshed, then:
> Right click on the database name in EM, then select 'View', then select
> 'Taskpad'
> The Taskpad pane will then reappear. Not sure why, but it has been like
> this for quite sometime.
>
> "Kay" wrote:
> > I continue to get this error whenever i try to use the Taskpad view of a
> > database in my SQL Server Entriprise Manager.
> > "An Error has occurred in the script on this page
> > Line: 307
> > Char: 2
> > Error: Unspecified Error
> > Code: 0
> > URL:
> > res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\1033\sqlmmc.rll/Tabs.html
> >
> > Do you want to continue running scripts on this page?"
> >
> > with Yes and No buttons.
> >
> > No matter whether i click on Yes or No, the error box goes away, and the
> > view i am trying to create never visualizes. The information that is usually
> > there is not there.
> >
> > Has anyone else ever seen this error message? Any clues as to what is
> > causing it? I'd like to get this view back. I found it quite helpful for a
> > quick reference.
> >
> > thanks in advance,
> > Kay
> >
> > --