Unfortunately I have seen no documentation on this, that I can point you to. I learned the last from watching TempDB in profiler when a temp table was created and...

Sorry I am still not finding anything usefull. Try this. If you can, use a query to define the records to be exported and do SELECT TOP 5 and see...

You may need to do this in a WHILE loop or CURSOR. But the CHARINDEX is a good approach. You need to look for ' ' so you know where...

Redundancy means you do more steps than absolutely needed. In this case all that is needed is a Full Backup. However making a TL backup first allows for two recorvery...

Check under SQL Agent in EM in the Alerts section. The alert that outputs this message may be turned on and can be disabled. I made this mistake originally when...

Language is a choice and all have there merrits. Please refrain from being rude. I work with VB, ASP, JAVA, VC++, and ACCESS and I never have any troubles with...

With SQL 7 you have to export the data then rebuild the server with Case sensitive on then import the data back in.

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

Sorry, you cannot do this. All filegroups must be restored (not neccessary to be same path). You cannot restore a file group to another database.

"Don't roll your eyes at me....

What do you mean not updated. The only thing that should matter is the jet drivers must be installed. I have no issues doing this on any of my machines....

The following link is to a script that will accomplish shrink the log file. http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26&CategoryNm=Maintenance and Management &CategoryID=1

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

Not really. If you are makign a full backup of the databases and did a TL backup right before it then it is just a redundant process.

"Don't roll your eyes...

Or if use BACKUP DATABASE and backup to a file or tape and restore to the other server, same issues may arise.

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

This problem comes from the vitual logs inside the transaction log not freeing. Look here for a script to help force the file back down. http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26&CategoryNm=Maintenance and Management &CategoryID=1

"Don't roll...

Are their any strange characters in the database name or table name? ALso try creating a very small 2 or three query with SQL STMT completed and see if you...

Wth AS take a look here and see if fits your situation http://support.microsoft.com/default.aspx?scid=kb;en-us;Q278325

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