Sounds silly, but should at least let you ensure it is just the user account change and nothing else...  Change the account back and see if your problems go away. ...

Obvious simple choice   Should've suggested that!!    Will only work though if the tables have the same...

There is a wonderful little-known command line tool called textcopy.exe - it is somewhere in the program files\microsoft sql server folder.  You can use its command line switches to have...

And where is the whitepaper?

"Please refer to this white paper for a better understanding of partitions in SQL server 2005."

Sounds like some cut + paste?

You say you are not doing a virus scan, but most virus scanners include "on access" scanning as well as "on demand" scanning - the "on demand" scanning is the...

Also check out the account under which SQL Server Agent is running - it may not have proper access to MSSQL, the MSDB database or the backup destination folder (to...

It shouldn't matter what order you do things in.   A "login" in SQL is mapped to a "user" in a DB (or is it the other way around?

I would suggest that you use unicode to ensure you can handle any strange characters that may arise.  There's no single codepage that covers both spanish, english, etc that I...

Definitely agree.  If you have 2 rows in table A and 3 rows in table B then you'll get repeated data, etc - yukky to deal with in client side...

Nice MS article from Jeff - would be nice if it said what the implications of a concurrent log backup are (if any)?

Main thing I liked from the MS article...

It looks like you are using VB of some sort (I'm not a big VB user - at least I try not to be

Analysis services is one of those areas of SQL Server that I have never investigated but have always wanted to.  Thanks for the intro article - very timely repost actually...

I think you've hit the nail on the head.  There would be missing transactions in the middle (those that were truncated) that were never backed up into a log.  Thus...

I can see cans with worms spilling out of them depending on how you interpret "file backup"....

If by "File Backup" you mean using...

we may still be able to eliminate the need for your UDF if you post its code?