Not sure how the SQL will differ for Access to MS SQL Server and unfortunately I don't have time to test it.

Do you see what I'm trying to get at...

Must add I haven't tested it.

Instead of:

SELECT DR_DCATCD,

SUM(SUM(DR_DQTY)-SUM(POUT_QTY)) AS QTY,

SUM(DR_DQTY*DR_DUPRICE) AS AMT

FROM DRDTL

INNER JOIN

POUT_DTL

ON DRDTL.DR_DICODE=POUT_DTL.POUT_BC

WHERE DR_DDATE BETWEEN #6/1/2009# AND #6/30/2009#

AND DR_DSTORE IN('342','338','333','302','315','303','312','332','316','325','339','129','217','128')

GROUP BY DR_DCATCD;

Do:

DECLARE @DR_DQTY_VAR INT

DECLARE @POUT_QTY_VAR INT

SELECT SUM(DR_DQTY) INTO @DR_DQTY_VAR,

...

I would use a TRY ... CATCH routine to check for the FILE EXISTS condition.

http://msdn.microsoft.com/en-us/library/ms175976.aspx

Do you mean Intellisense?

I believe it wasn't present in 2005 RTM but may have been subsequently added in the 4 SPs.

See here for Microsoft's guide to enabling it.

http://msdn.microsoft.com/en-us/library/ms173743(v=sql.90).aspx

I imagine something like...

CREATE TRIGGER foo_trigger

ON ALL SERVER

AFTER ALTER_DATABASE

AS

EXEC sp_foo @param1='foo', @param2='bar', ...

GO

Triggers are not my strong suit though, you will want to research valid...

Presumably this is a 64-bit box? On 32-bit you would additionally need to give the Lock Pages In Memory privilege to the SQL Server service accounts and enable AWE,...

I would concur with the other answers. Each member of the filegroup will be filled using a 'proportional fill' algorithm ie. turn-based fill, hence if one file is fixed...

I thought so. Thanks for your reply!

Just thinking that maybe the restore threshold value was met on the primary server due to some sort of network interruption. The SSMS screen where restore thresholds are set...

Can you run:

EXEC SP_HELP_LOG_SHIPPING_MONITOR_PRIMARY @primary_server = 'servername' @primary_database = 'databasename'

GO

EXEC SP_HELP_LOG_SHIPPING_MONITOR_SECONDARY @secondary_server = 'servername' @secondary_database = 'databasename'

GO

This should return the log shipping configuration as SQL sees it.

Using Robocopy as the...

Courtesy of Phil Brammer here -> http://www.ssistalk.com/2010/05/04/sql-server-2005-how-to-introduce-data-corruption-without-trying/

Kalen Delaney (I think - I might be wrong) had a blog post explaining how to insert a few 0s into a data page. You could also open the...

Have you received any errors along the following lines?

MSSQLERVER(14221 - Server): The log shipping secondary database SERVERNAME.databasename has restore threshold of x minutes and is out of sync. No...

If you're new to SQL Server then use SQL Server Management Studio (SSMS) GUI to point-and-click your way through the configuration. Open SSMS, connect to the database instance...