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
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,176 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
  • 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
backup and restore 21 30
SSRS Deployment problem 5 66
TSQL XML Namespaces 7 24
Get Next number from Stored Procedure 8 23
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

828 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