reset sa password msde (sql server 7)

Hi Guys,
We've lost the password for the sa. No other users belong to the admin
group. I've tried logging in using osql -E (windows authentication)
without success. Is there anyway to reset the sa password? The database
is MSDE and the version seems to be 7 (sql server 7 folder on pc). It
is running on Windows 2000 professional.Any help would be greatly
appreciated.
Regards,
EddieAm 24 Sep 2006 14:10:15 -0700 schrieb eddie:

Quote:

Originally Posted by

Hi Guys,
We've lost the password for the sa. No other users belong to the admin
group. I've tried logging in using osql -E (windows authentication)
without success. Is there anyway to reset the sa password? The database
is MSDE and the version seems to be 7 (sql server 7 folder on pc). It
is running on Windows 2000 professional.Any help would be greatly
appreciated.
Regards,
Eddie

AFAIK since SQL 7 you have authentication and it is not possible to disable
login per windows authentication. So if you are logged in as windows admin
you should always be able to connect to a database like "master" (if the
server is running :-)) ). Then you can use sp_password for setting a new
password for sa.
Or you stop the server, save your database-/logfiles, make a new install of
SQL Server and then attach your database files again.

bye, Helmut|||Is it possible to upgrade the database without the sa login (and noone
else belonging to admin group)?
Helmut Woess wrote:

Quote:

Originally Posted by

Am 24 Sep 2006 14:10:15 -0700 schrieb eddie:
>

Quote:

Originally Posted by

Hi Guys,
We've lost the password for the sa. No other users belong to the admin
group. I've tried logging in using osql -E (windows authentication)
without success. Is there anyway to reset the sa password? The database
is MSDE and the version seems to be 7 (sql server 7 folder on pc). It
is running on Windows 2000 professional.Any help would be greatly
appreciated.
Regards,
Eddie

>
AFAIK since SQL 7 you have authentication and it is not possible to disable
login per windows authentication. So if you are logged in as windows admin
you should always be able to connect to a database like "master" (if the
server is running :-)) ). Then you can use sp_password for setting a new
password for sa.
Or you stop the server, save your database-/logfiles, make a new install of
SQL Server and then attach your database files again.
>
bye, Helmut

Reset Excel Destination for Error Logging

I am using sheets in an Excel spreadsheet to receive redirected error rows. The trouble is that it keeps appending the rows to the bottom of the sheet - even if I delete the rows in the spreadsheet. If I remove the spreadsheet all together then I need to set-up the Excel Desitnation Sheets again.

Each time I run the Control Flow I would like it to be removing old log entries and writing in the new ones.

There must be an easy way?

Unfortunately the Excel driver does not support anything like TRUNCATE TABLE. Even if you opened Excel and cleared the contents of those rows, the driver would still see them as "used" ... the only solution is to delete the rows themselves from within Excel. And you would want to check the range definition to make sure that you were in fact deleting all the rows in the range.

Of course the cleaner solution would be to drop and recreate the table. You could use an Execute SQL task for this purpose, and probably get one of the SSIS components to write the SQL for you to copy and paste in.

-Doug