[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1484
  • Last Modified:

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

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
bominthu
Asked:
bominthu
  • 4
  • 3
1 Solution
 
Aaron ShiloChief Database ArchitectCommented:
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
 
bominthuAuthor Commented:
OK i'll check the steps.

How about exporting Logins to txt or excel in SQL 2005 ?
0
 
Aaron ShiloChief Database ArchitectCommented:
if you mean exporting the login names
then just use the import/export wizard and export this query

select name from sys.syslogins
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
bominthuAuthor Commented:
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
 
Aaron ShiloChief Database ArchitectCommented:
0
 
bominthuAuthor Commented:
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
 
bominthuAuthor Commented:
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

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now