select a.controllerID

from SendController a

inner join (select distinct regionID, count(regionID) as RegionNo FROM SendController GROUP BY regionID) b

on a.regionID = b.regionID

...

You have to submit backup statements from mulitiple sessions.

Can you post stored procedure "sp_SarBoxAudit"?

It depends on how much data your business can afford to loss. We backup it every 15 minutes for business critical database.

Try to reinstall the 64-bit version of MDAC 2.8 which comes with the 64-bit version of Windows Server 2003.

I will install 64-bit SQL Server soon and see whether...

Restore the database from your backup.

Do you restart SQL Server after running sp_resetstatus? Try that.

select sysobjects.name, syscolumns.name as name1 into DP_AUDIT

from sysobjects, syscolumns

where sysobjects.id = syscolumns.id

and sysobjects.xtype='U'

Try SELECT * FROM mylinkedserver.yourcatalogname..mytable, your catalog name can be found from EM by click tables under the linked server.

Have you try to use Microsoft Jet OLE DB Provider to...

Open your maintenace plan, goto reporting tab, check "write report to text file in directory', run your job and come back the director to find out report which may have...

1.Create a new database with the same name or a different name. You will have to use a different physical file name, which is fine.

2.Stop SQL Server.

3.Rename the...

http://support.microsoft.com/default.aspx?scid=kb;en-us;319016&Product=sql

http://support.microsoft.com/default.aspx?scid=kb;en-us;239885&Product=sql

Do you have to change the IP? Run the setup to uncluste SQL Server and re-cluster it. See KB Q244980 for details.

The 9004 error message indicates that the log dump is corrupt.

Drop the suspectd database and restart the restoration.

Schedule it to run automatically when SQL Serevr Agent starts.