yes send me.

attach here as a post

change the datatype to nvarchar and then try again

and also try changing the file to csv and then try

bcp command

try the openrowset function

for example :_

SELECT * INTO dbname.dbo.tablename

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\filename.xls', 'SELECT * FROM [sheet name$]')

Change the location as applicable... its on C drive here..

huh..okk..

Tell me wat is hte extension of ur excel file (.xls/.xlsx) and

also the no of rows in excel file ?

Regards,

Sushant

also the length of the data type allowed

check out the datatype if it allows

all the data to copy...

do u see the colum and data when u click on

edit mappings/preview in the import tasks?

Regards,

Sushant

I was facing the same situation,

Its very diffficault to find entry level junior DBA in states.

I got an offer from caribbean company and shifted there..now iam happy..

U can look...

Same here

Can full backups, transaction log backups and rebuilding index go at the same time?

Isnt there...

I had the impression that reindex jobs increase the size of log file (ldf) not the data file(mdf)

Regards,

Sushant

@ k brian

Thanks a lot

Regards.

Sushant

note

its 3 yr old thread

Regards,

Sushant

ohh

But now If i refresh it, i found all the logins are created,

So is it fine, that they are already created

or there will be error when the user tries...

okk.thanks..

Now when iam trying to import the logins by sp_help_revlogin

I am getting (for almost every user) :-

Supplied parameter sid is in use.

I think it is because the logins at the...