Based on the inforamtion you provided, one database seems better in terms of development, maintanence, and deployment.

SQL server is not good at manage relations between databases. So create one db...

Assume the parameter for the period is @PeriodDate, which is a datetime.

Togenerate the report for the week contains this date,

First of all, find out the @WeekStartTime and @WeekEndTime that contains...

alter database your_db remove file the logical log file to remove

If it gives errors, you need to truncate the log first.

You can use filter on TextData column.

If the client side calls stored procedures, you can trace Stored Procedures-->RPC:Completed and set the SP name as filter.

If the client sides...

I supposed you were using SQL 2k. But It seems you are not.

Can you print the ulActualLen and ldata after get the parameter in the xp by srv_sendmsg?

The following is the pseudo code:

DECLARE @TmpTable (RID int identity, stockid, time, Amt, Delta)

INSERT @TmpTable (Stockid,time,Amt, Delta)

SELECT Stockid,time,Amt,0

FROM YourTable

ORDER BY Stockid, time

UPDATE A SET Delta=b.Amt- a.Amt -- If you...

Use sp_helprole

application role is a database role, not a user

If you use constant as parameter, you can try to cast it to int. Or declare a variable.

DECLARE @retval int

DECLARE @Param int

SET @Param=255

EXEC @retval =...

Are you using application role?

Yes. try exit with different number in your bat

e.g. :

EXIT 3

Another way is to put all your dos command in a bat file. Run the bat file from sql job

AFAIK, you cannot do it.

You can define a temporary table and save the results of your SP there. Then open the cursor by select from the temp table.

You can have text or image data type column in select statement directly. The TEXT column does not need to be the last one. I have this kind of proc...

When the SELECT is not in a transaction, SELECT * FROM WITH(UPDLOCK) will prevent others to update the table while the select statement is running.

If the hint is not there, only...