Solved

How to export SQL logins to txt or excel and publication settings in MS SQL server 2005

Posted on 2011-03-13
7
1,258 Views
Last Modified: 2012-06-22
Dear Expert,

Could you let me know how to export logins to excel or Txt file in SQL server 2005 ?

And let me know the settings steps for Publication in SQL server 2005 ?
0
Comment
Question by:bominthu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 500 total points
ID: 35121281
1. select name from sys.syslogins ==> you can use the import/export wizard to export the query to any file.

2. read this for a step by step guide to replecation

http://www.exforsys.com/tutorials/sql-server-2005/sql-server-configuring-replication.html
0
 
LVL 4

Author Comment

by:bominthu
ID: 35121297
OK i'll check the steps.

How about exporting Logins to txt or excel in SQL 2005 ?
0
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 35121325
if you mean exporting the login names
then just use the import/export wizard and export this query

select name from sys.syslogins
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 4

Author Comment

by:bominthu
ID: 35121373
which one you mean -
just use the import/export wizard and export this query/select name from sys.syslogins  ?

Could you elaborate more ? Sry I'm new to SQL
0
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 35121379
0
 
LVL 4

Author Comment

by:bominthu
ID: 35121745
Hi Ashilo,

The thing i want to export is only users list which is security- logins- (so many users )
How can I export users list to text or excel ?
0
 
LVL 4

Author Comment

by:bominthu
ID: 35143335
Hi Ashio,
I've setup and everything went throughtwell. In SQL replication, in order to replicate I need to open SQL management studio and log in and keep the windows minimize always? Will it replicate if I don't open SQL management studio windows and connect? How can I check the replication status in easy way whether it is replicating properly or not ?
Appreciate for your soonest reply
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question