What are error messages? Is it because of account?

You can run

DBCC LOG (DBName)

You cannot recover sa password. But you can access the server using other account with sa privilege, then, reset the password.

Yes. If you would like to set this audit all the time, following the steps below.

My SQL version is 2000 (8.00.2039). When I used grid for output, I found the weird output. When I used text for out, everything was going fine.

I do not know what is inside your stored procedure. But be careful when you set nvarchar(4000). There is a limit for a row in a table.

Before running your script,

SET TRANSACTION ISOLATION LEVEL Read uncommitted

In your script, enforce rowlock.

I have tested the following snippet. It works.

CREATE TABLE #1 (col1 INT, col2 VARCHAR(1))

CREATE TABLE #2 (col1 INT, col2 VARCHAR(1))

INSERT INTO #1 VALUES (1, 'A')

INSERT INTO #2 VALUES (2, 'B')

SELECT...

I need to have more information to answer your last question.

How about

SELECT * FROM #1 UNION SELECT * FROM #2

Did you try to enclose your string with []?

Your stored procedure is a regular one!

If it is regular stored procedure (a readable file):

1. Open your Query Analyzer;

2. Point to your desired databse;

3. Copy the code on the code window;

4. Run it.

If it is an extended...

I had exactly same experience as you have now.

It is most likely that you used a linked server. The SQL Server Agent had an invalid account or password. Although you...

How about this one:

SELECT so.name TblName, sc.name ColName, si.indid

FROM (sysobjects so INNER JOIN syscolumns sc ON so.id = sc.id AND so.type = 'U') 

INNER JOIN sysindexes si ON si.id...