Does the service account for SQL have access to the network share?

If I understand this correctly, then you have a database in Full recovery mode, a full backup of the database from December, and you have never done a log backup...

4 questions: Was there a differential backup on Thursday 5 am as well? Was it to the same file as the Friday differential? Did you use WITH...

You might look into a company called MapInfo. They have a lot of offerings for location-based info. I'm not sure they have what you need or not, but...

John, to be clear on the suggestions from Amit and Tom, the danger of converting values before comparing them is not limited to int's. Dates face the same issue....

The most explicit reference to your question I found (after an inexhaustive search) is in BOL, search the index under "Backups, transaction log" and look at the scenario under the...

Here too you should not have a problem. If the source is rebooted while doing a log backup, then the backup will fail, and the transactions that would have...

You should not have a problem if either partner goes off radar for a while, as long as they come back online before the log backups start aging out.

As Philip requested, posting your DDL and SQL will enable us to give you more specific advice.

That said, what jumps out at me is the CONVERT() function shown for the...

SP4 can be applied to any earlier version.

If I understand correctly, you want to SELECT * FROM TABLEB, but have the output reflect the column names of TABLEA. The cleanest way would be to alias the...

Wildcards are only allowed when using the LIKE operator, as far as I know. REPLACE looks for an exact match of the substring, and while that feels a lot...

Does the owner of the proc have access to all the tables? Are you using dynamic sql?

If you are using Query Analyzer, try setting Tools/Options/Results/Maximum Characters per Column to 4000.

Not quite true. Inserting a row into a clustered index never causes the entire table to be reordered, it simply maintains the page pointers on split pages so that...