there is a procedure sp_updatesubscriber which you could use to change the password for your distribution db to accomodate the new sa pwd.

which is the error message?

you can use sp_MSforeachdb with sp_helpdb

hello

first dbcc loginfo and check status column may be 0 or 2 ,if 0 you can

backup log dn_name with truncate _only

go

dbcc shrinkfile(log_file_id or file_name,size you...

there is a tool  SSMA (SQL Server Migration Assistant) for 2005.

I need something like this

 check syslogins if they exists

if not create

for each database execute sp_adduser

Thanks Lowell,

you help me much.

thanks for hints,

actually I want to rewrite the query for speed

Hi,

I checked KB

Hi,

You can use BII from SQL RKits 2000 , textcopy utility, or  a simple application built in .Net.

Hi,

Thanks so much.I obtained an improvement of speed.

Hi,Check this site for articles,also microsoft.com,databasejournal.com for new featues.

Sybase is a good product especially for financial environement,a better payment for a DBA,the transition from MSSQL is not so difficult,but need good Linux(Unix) skills.

No so easy,but approachable ,for DBA Unix scripts is a must.

Gabriel Stan

The learning curve from SQL server to ASE is not difficult(especially if you work with MSSQl 6.5,many dbcc & sp are the same),rate is about 7 (for 1 to 10),data types...