Michael

What kind of table are you creating - temp table, global temp table, or table in a user database? Are there multiple instances of the same package running at...

If you look on the Books Online page for sp_spaceused, you'll get your answer.

John

What account does the IBM Scheduler run under? Does that account have access to the databases?

John

Mal

We use LiteSpeed, but when I unsuccessfully tried to do an object level restore, I raised a call with Quest. They told me that our licence doesn't cover that....

I think frites have been adopted by Belgium as its own national delicacy. Indeed, there's a song in the Europop tradition (sung in English) called It's Great to be...

But that's my whole point. You've done it before and now you're having to do it again. That should tell you that the space that the database files...

I would recommend that you investigate how much free space you have inside each database before going ahead with this. If your files are full, this isn't going to...

Unless, for some bizarre reason, he wants those figures repeated as many times as the function returns rows.

John

Thanks Lynn. I saw those other threads... just thought I'd try this once. If I don't get the required information, I shan't be asking again.

John

Please post the whole of your code, including the parts where @temp1 and @ReportData are declared. Please also post the definition of dbo.fRealizedGainLoss and any table definitions and sample...

You should try to help yourself, and post back if you come across anything you don't understand. I bet that if you typed "How to rename SQL Server" into...

I've just noticed that you said the server is not in a domain. I think that's your problem - it sounds as if you're trying to run SQL Server...

Phani

Sure. If you have WinZip or another such utility installed, you can use xp_cmdshell, which you can also use for the COMPRESS command if you have the Windows Resource...

I've seen that SSPI error occur when a Windows password has recently expired or been changed.

Also, please will you check that the time of your most recent SQLAgent.OUT file coincides...

As far as I'm aware, you can,...