When setting up a linked server the name you give it shoul match with what you put in the client network utility. For your example you can define a SQLSERVER1...

As with any query it can vary. In some situations it may be subselect has more overhead than having, but other might be the opposite. The best way is to...

CAST (DATAVALUE AS DATATYPE)

or

CONVERT(CHAR,DATAVALUE,DATEOUTPUTFORMAT) (See BOL CONVERT about the values for DATEOUTPUTFORMAT)

Also keep in mind that dates can be formated on input differently and you may need to use SET...

You can store anything without a clustered index or any other index. However if you have a logical clustered index (unique or not) that fits the order of the dbase...

You may also want to look at xp_cmdshell in BOL if the app excepts cmd line parameters.

"Don't roll your eyes at me. I will tape them in place." (Teacher on...

have they emailed you yet? If so then keep an eye on the newsgroups. There is some prilimnary work going on with documentation and should begin in mid september. If...

If you choose overwirte existing media it is the whole tape not just the DB. Choose instead overwrite on first db and append for each additional db backup to be...

Another thing that may help catch it, if it is a piece of code is a blackbox trace. Just like a flight data recorder it makes entries for problems and...

If it occurrs around a specific time then look at and consider processes/tasks run at that time or shortly before. Even things such as a bad driver for a backup...

My opinion is better safe than sorry. So what if you have to do more maintainence, if someone comes along later who doesn't understand ordinal order by's then you end...

We have had no issues, but it does run far superior on Win 2K that NT4. What is the bug?

"Don't roll your eyes at me. I will tape them in...

Unfortunately there is no way to find the exact cause unless you were looking at the time it occurred. Could have been anyone of a number of factors. One thing...

Should work fine, but you will need to have the machine on the same domain and SQL will have to have rightd to that share or you will run into...

You will still need to go one at a time especially if they have to occurr in a specific order. If not then you can setup several seperate unlinked tasks...

The other thing to keep in mind is SQL 7 has known issues with shrinking a bloated LOG due to the virtual logs. There is a script on this site...