This is also usefull.

dbcc sqlperf ( LOGSPACE)

select max(qty) from (

select orderid, qty = sum(quantity)

from [order details]

where orderid between 11000 and 11005

group by orderid

) a

Each TSQL Step in Every Job has got a property called as "Run as user" which by default is "(Self)". It is the same account as that used by SQL...

Try this three together

EXEC master..xp_cmdshell 'SUBST D: /d ' , NO_OUTPUT  -- REMOVE EXISTING SUBST (IF ANY)

EXEC master..xp_cmdshell 'SUBST D: c:\product\app\downloads' , NO_OUTPUT -- ADD...

Two points over CHECKSUM.

1. it does not work with image data type

2. it can take * , not a.*

for binary comparision use BINARY_CHECKSUM

Try This.

select a.* from Tracker..task...

I USED THIS FROM MSDN  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro03/html/sp03l12.asp 

Hope this helps

SELECT

     KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME'

   , KCU1.TABLE_NAME AS 'FK_TABLE_NAME'

   , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME'

   , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION'

   , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME'

  ...

create table mytable

( item char(1) ,  day int , inhand int , demand int , endingbal int, ind int identity (1,1 )   )

GO

insert...

Try this. it works. (befor it make sure you turn your macro security in MS word to medium or low )

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=724&lngWId=5

you have ideal situation for a partitioned view.

otherwise,  consider this. (increase the code length for all other countries .....)

DECLARE @C VARCHAR(20)

-- SET @C = 'NZ'

IF

is this you want ?

SELECT IDENTITY(INT,1,1) AS IdCol INTO #A FROM YOUR_TABLE

SELECT CASE WHEN IdCol % 4 = 1  THEN 'Cached Data '  ELSE 'Centura Data ' END FROM #A

ORDER...

the osql scripts are nothing but TSQL statments called from command prompt. Build your restore command and call it with osql.

e.g.

osql -E -S . -Q "select...

Run this ....

INSERT A DEFAULT VALUES

DELETE #Test_Delete

WHERE MyId IN ( select MyId FROM dbo.Account)

I tried replacing the ColumnName MyId insided subquery with MyId1,  MyI, or anything else other than MyId, it does give...

Can you put Stored procedure code on forum ?

xp_cmdshell runs on SQL Server Machine, It runs under the same security account as used as sql server startup (services).

so check if Excel is available on server and the startup accoun of...