?
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,299 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

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

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.

752 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