Aswani - do you first get a warning box saying that "..Debugging may not work properly if you log on as 'Local System Account'..." ?!?!

If you do, then you have...

I didn't realize you hadn't created a database first - what were you trying to restore the backup to ?!?!

Glad that you...

Indigo - you won't find a better source of information than BOL (books online) -

about the part that makes the xx increase by 1...

1) (SUBSTRING(colName, 2, 2) - gives...

I recently came across this error myself and if I remember correctly, all I did was change the path and filename...so in your restore...try and change the "f:\blah\blah\xxx.MDF" to the...

..this seemed to work for me...not sure what you have in your variable declarations...?!?!

declare @varName varchar(10)
declare @Last_Match_Name varchar(10)
declare @Last_Char char(1)
declare @ctr tinyint

set @ctr = 1
set @Last_Match_Name = ''
set @varName...

maybe there's a better way of doing this but I can only think of looping through all the column names and updating each using a cursor...something like this...

CREATE PROCEDURE...

are you using vb ?! does kill fileName not work ?!

what about ERwin ?! haven't used it myself but have heard only rave reviews from everyone who has!!!

something very similar was discussed in another post not too long ago..see if this helps:

pulling sprocs into .xls

Also - in your odbc data source administrator in the control panel you can check the box that says "Use regional settings when outputting currency, numbers, dates and times"!!!

believe it should work if you set the style to 103..

CONVERT(varchar, '31/12/1994', 103)

huh ?!?!

okay - now I really am getting back to work - lest we're accused of slacking off!

LOL...ok - now that we've established who we are...get back to your "popular screen name"...ssc members might start suffering from remi withdrawal symptoms otherwise...

think of yourself as rgR'us...makes it easier!

NO - NO - NO!!!!!!

Remi gets credit for almost all of those...he plays David to his own Goliath (you know what I mean) - I too wait in line for...