Do you have any backup process going on (i.e. Arcserve Backup running on a server dedicated to backing up the other servers)? That can lock the file.

We had one 2...

The point about the barcodes is valid. It is just a font, but the font needs to be available to all client machines...usually loaded at the client level.

In addition there...

One that we are starting to do. Instead of pointing to the server by name, we are creating DNS entries for all our ODBC calls (by program if it uses...

When it comes to backups, even though the backups may be big,
 I only have to backup the DB, not a file storage location.
  And what happens if a...

It sort of depends on latency and data loss acceptablity.

If both servers are on site and the network has enough bandwidth then I would say go transaction repl.

But here is...

Kristin,

Send me an e-mail at " jimpen at go2netmail .com " and I'll e-mail you an Access database that does some file handling and an easy interface for users.

You'll have...

We just had this discussion in http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=125190

Storing the images in the database is considered bad juju. There is nothing that can be...

A lot of our images are tif. Just avoid bitmap. Lots of wasted space.

If the fax server saves the file in one location and you are moving them to another...

Yes. What happens is that you then set the Picture source of the image to the path and either refresh the form or open a new one (depending on...

You would have to build that script before you detach them.

If you have a script for the detach, then it becomes a matter of copying and modifying to be

sp_attach_db...

It works great! Just on note, in the hundreds, forty is spelled wrong.

SET @result=case @b-2

WHEN '2' THEN 'twenty'

...

Best advice - do not store the images in the database! We have an imaging system in my company and all they do is store the location in the database....

You can schedul a DTS job. Just right click on the primary database and select Export Data. Let the wizard walk you through the steps. Then when it asks...

If the sp_removedbreplication doesn't work try the steps below. Note: You should make sure you have a good backup before trying this. This comes from KB 326352: You Receive...

Just a hint from experience....

Try not to use spaces in database names or paths. All they seem to do for me (and everyone else) is cause headaches. If you...