If your sqlagent is serviced using a windows-account, you can perform remote-backups, as long as your windows-account has write-permission at the destination-folder where the .bak-file resides.

Check BOL backup devices

Sorry Frank, didn't know you were here today

- keep sql-injection in mind ! Check http://www.sqlservercentral.com/columnists/chedgate/sqlinjection.asp

- just define your variables as sp-parameters and handle your statement in your sp. You...

tsm only makes file-copies !

This will work only when the db is offline (sqlserver7 instance is down).

they were not wrong , they did too much work, which is against the nature-law that a dba is lazy by default and therefore always chooses the shortesd way to get...

In this case the sp_tableoption N'Employee', 'text in row', 'ON'

is overhead, because BOL says 'on' enables it OR an integer value from 24 through 7000.

Another reason for the simple minded to implement whatever comes up   , same like buying a bigger box if the current one can...

like BTW = "by the way", BOL stands for "books online"

Start\Programs\Microsoft SQL Server\Books Online

look for "Defining...

why not setup an alert and have sqlagent sending you the mail ?

(check BOL)

There are demo-alerts with sqlserver instaled, but not activated.

yep, all programming starts with copy & paste.

did anyone modify the dts-package from his/her client connecting to the server (and not being at the server-console ?

MDAC can cause some pains in this case because dts stores (client)-objects.

maybe a stored proc can give the solution ?

watch out for noeld's litle typo

, SUM(CASE WHEN MONTH(workdate) = 11 THEN bhrs ELSE 0 END ) as Dec

--should be ---------------------------12

sql2k with sp3a on a multiprocessor box ? There is an issue with count(*). Hotfix is available at MS.

Might be the issue described at http://support.microsoft.com/default.aspx?scid=kb;en;241643. Forwarded it to my Windows administrators.