select * where month = 2

union all

select * where ...

...

???

Enterprise Edition

SP4

8.00.2039

Windows and SQL

Service is started under Windows account which also 'owns' all SQL servers

I get the same error while connected with that windows account

Server: Msg 18456, Level 14, State 1,...

Update

- after system defrag the SQL Server works normal;the defrag was done with system's defrag tool (Win2k server).

What is the experience with window's defrag tool vs SQL server?What are the...

The only errors I see in the sql error log are below ;I think the first caused by MSDTC was not yet up when MSSQLServer was starting

1.

2006-02-17 19:17:58.00 server ...

Same issue

SQL 2000/SP3 Standard edition ;ERP system with 2 CITRIX servers

4CPU/4GB RAM/

SCSI and RAID controllers

HP 64-bit/66MHz Wide Ultra3 SCSI Adapter

24/7 business

Main db (mostly used) 50GB/15GB log

Starting end January system...

That sorted out the issue.

Thanks for the help.

I am being told that it has ,but I would like to check it mysefl;

What test would be concludent ?

Thank you for your information.

Have an issue in similar context

sp_OA will create the txt file on the SQL machine,but will fail to create on a shared network location.

Any comments appreciatted.

Thank you.

Not sure if will work for you,but try to call your SP as follow:

create procedure MainSp ( @PDBName nvarchar(20) )

AS

declare @ProcName nvarchar(20)

set @ProcName = @PDBName + '..YourSp'

exec @ProcName [parameters...

In the case the SP would have an OUTPUT ...

Any ideas how we could get it's value ,assuming SP call is done through dynamic sql?

If you are on Microsoft SQL Server 7.0 have a look at

Microsoft Knowledge Base Article - 814578

[814578 - PRB: OLE Automation Error Occurs When SQL Server Runs a...