asked on

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 ?

ASKER CERTIFIED SOLUTION

Aaron Shilo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bominthu

ASKER

OK i'll check the steps.

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

Aaron Shilo

if you mean exporting the login names
then just use the import/export wizard and export this query

select name from sys.syslogins

bominthu

ASKER

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

Aaron Shilo

folow this guide => http://www.kodyaz.com/articles/sql-server-export-to-excel-using-import-export-wizard.aspx

bominthu

ASKER

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 ?

bominthu

ASKER

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