How about using the tblName variable the way it is in my example and then running it - what does that get you ?!?!

SET @tblName = '["FAC Treaties$"]'

you could use your id/key column:

SET IDENTITY_INSERT DATABASE1.dbo.TABLE1 ON

INSERT INTO DATABASE1.DBO.TABLE1(Col_PK,COL1,COL2,COL3)
SELECT Col_PK, COL1,COL2,COL3 FROM DATABASE2.DBO.TABLE2 WHERE Col_PK NOT IN 
(SELECT Col_PK FROM DATABASE1.dbo.TABLE1)

SET IDENTITY_INSERT DATABASE1.dbo.TABLE1 OFF

Haven't used bulk insert but you could update the columns in the sql table using the 'REPLACE' function:

DECLARE @string VarChar(100)
SET @string = '‘B’ |12454 | ’CAINE’ | ’TOOL’ |...

Try using dynamic sql:

DECLARE @sql VarChar(100)
DECLARE @tblName VarChar(15)
SET @tblName = '["FAC Treaties$"]'
SET @sql = 'DBCC SHOWCONTIG (' + @tblName + ') WITH ALL_INDEXES, TABLERESULTS, NO_INFOMSGS'
EXEC(@sql)

why does the db have...

I believe .818 is sp3a + 818 hotfix..

& this from the microsoft site:

"Note: Your product version may be different than these values if you applied a hotfix after installing the...

Here's one link - scroll down 2/3rds or search for itzik ben-gan...& you know what they say about great minds...

when was the last time you accessed this site - the web archives stop at "march 2005"!

Amit - I have (most fortunately) not faced anything similar but did come across a couple of good posts that may just yet provide the solution you need..see if they...

jbrewer - since you want the backup overwritten rerun it using the "with format" option instead...

re: retaindays..here's where you'd find the default..

"By default, the expiration date is determined by the...

There's an excellent section on BOL for simple transaction log recovery models...you should read it and see if it's suitable for the kind of database that you're working with..

sounds like despite your "init" clause the backup is not getting overwritten...

check these 2 conditions to see if that's what's happening:

BOL:

All backup sets on the media have not yet...

How about querying the db to see by how many members the site grew each year (on the anniversary) - it's at a impressively whopping # (318,606 ?!?!) right now!...

another link

sorry - forgot to add that the reason you're not seeing anything in the 'productversion' and 'edition' columns is probably because of the length per column setting...if you go to...

Don't believe there's any compelling need - I transitioned over pretty smoothly (from 3 to 4 ie) - but've read several posts here where things that worked with sp3 "broke"...