Anita,

Here is what I use to back up a DB:

-- Create a logical backup device for the full backup.

EXEC sp_dropdevice 'par_pos_1'

EXEC sp_addumpdevice 'disk', 'par_pos_1', 'd:\sqldata\MSSQL\data\par_pos.bak'

-- Back up the full database.

BACKUP...

None of the choices seem 100% correct to me. If you read the referenced kb article:

"Database snapshots operate at the data-page level. Before a page of the source database is...

The other side of the problem is equally bad - I have a customer that sends 14,000 legitimate emails to their paid membership (it has a link that enables them to vote online on...

Spam, like junk snail-mail, is still a problem because somebody somewhere is making money from it. If nobody ever responded to the fake Rolex's, drugs without an Rx, inside stock...

Have you tried adding the ".Value" to the end of the expressions?

I would like to point out that the new Yahoo! email client has a similar bent-corner thing next to their account login info, but theirs DOES NOT move and shimmy...

One of my pet peeves is when somebody will read a question and either they don't understand it, or they don't know the answer -- does that stop them? Nope...

I wouldn't trust this post either. Now that the ASP and .net junkies can reach in and do stuff via the CLR, it's anybody's guess. And it is still so...

I totally agree with Clifton. M$ is moving at too fast of a pace to produce quality work. They don't seem to be improving the results, only the product line...

There's a utility called TurnFlash from nirsoft.cjb.net that sits in the system tray, you can use it to flip the registry key for flash on / off. Very handy.

I also prefer VB 6 to .net. One reason is that because it is so old, it is fixed and unchanging; and it's not hard to find a 10-years-plus VB...

The best choice for report layout is to use either a Table or Matrix, if you intend to export to Excel.

Lowell, I don't think you can grant permission to TRUNCATE TABLE if we're talking SQL 2000 with SP3 or higher, due to security changes.

Here is a VB6 or VBA script to do one db, you could easily adapt to script them all...

Sub ScriptDatabase(dbname As String, outfile As String)

    '

    '   this procedure requires...

Has the structure of the Sql table changed? Access remembers and stores the schema for attached ODBC data sources only upon the first connect, so if the Sql table was changed...