Viewing 15 posts - 241 through 255 (of 280 total)
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...
December 12, 2011 at 2:44 am
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,
...
December 9, 2011 at 4:38 am
I would use a TRY ... CATCH routine to check for the FILE EXISTS condition.
December 9, 2011 at 4:25 am
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.
December 9, 2011 at 4:22 am
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...
December 9, 2011 at 4:10 am
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,...
December 9, 2011 at 3:59 am
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...
December 9, 2011 at 3:54 am
I thought so. Thanks for your reply!
December 1, 2011 at 4:39 am
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...
November 24, 2011 at 8:29 am
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...
November 24, 2011 at 8:21 am
Courtesy of Phil Brammer here -> http://www.ssistalk.com/2010/05/04/sql-server-2005-how-to-introduce-data-corruption-without-trying/
November 24, 2011 at 8:17 am
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...
November 24, 2011 at 8:15 am
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...
November 24, 2011 at 8:11 am
Viewing 15 posts - 241 through 255 (of 280 total)