- Keep in mind that your clustering-index may be uniqueified by sqlserver itself if it is not a unique key _and_ it is added to all nci ! So keep...

stop it and start it again without the -m parameter

I'd suggest you make a stored proc to perform this functionality. Use temporary objects to store intermediate data and returen your selected subset from the temporary object.

store it as a separate smallint, just indicating timedifference to GMT. If doing so, it might be interesting to include a gmt-datetime column because otherwise you'll have to include "daylightsavings"...

<<We are using the same login name and password, Windows Authentication...and contiually get an error message that says the user name is "null".  >>

So, are you using SQL-authentication _or_...

exec sp_MSforeachdb @command1 = 'SELECT [TABLE_CATALOG], [TABLE_SCHEMA], [TABLE_NAME], [COLUMN_NAME], [ORDINAL_POSITION], [COLUMN_DEFAULT], [IS_NULLABLE], [DATA_TYPE], [CHARACTER_MAXIMUM_LENGTH], [CHARACTER_OCTET_LENGTH], [NUMERIC_PRECISION], [NUMERIC_PRECISION_RADIX], [NUMERIC_SCALE], [DATETIME_PRECISION], [CHARACTER_SET_CATALOG], [CHARACTER_SET_SCHEMA], [CHARACTER_SET_NAME], [COLLATION_CATALOG], [COLLATION_SCHEMA], [COLLATION_NAME], [DOMAIN_CATALOG], [DOMAIN_SCHEMA], [DOMAIN_NAME] FROM ?.[INFORMATION_SCHEMA].[COLUMNS]...

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.