Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2011-03-13
7
Medium Priority
?
1,382 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 2000 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
Independent Software Vendors: 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

618 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