?When our transaction log grows large and we want a quick way to shrink it, then we have to change the database recovery mode of the database we want to...

Also,

You can check the sql servers services running status by just pinging them from cmd

telnet sqlservername 1433

If a blank screen follows, that means services are running, otherwise it will tell...

@ rick,

thanks, I got it

The excel file was not on the server where i was trying to import it.( it was on local pc)

Regards,

Sushant

@ pradeep

Yup that did it....

I guess, the excel file was not on the server where I wanted to import.

Thanks a lot...

🙂

Regards,

Sushant

@ rick

I am getting this error when I am trying to run the script (openrowset).

When I run the import wizard it gives same error as mentioned earlier...0xc00470fe error code

Regards,

Sushant

I was on my local pc widout any SSIS installed,

so I went to remote server and opened management studio and wrote this query :

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\Users\xyz\desktop\FullLoad1.2.xls', 'SELECT...

just 1 time i guess.

So that means you have a temporary solution or what?

The earlier error ,I was getting when i was on my local pc without SSIS installed,

so I...

@ rick

I am on remote server with sql server 2005 sp3 installed on it...

I have excel 97-2003 on it.

i am running --

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\Users\xyz\desktop\FullLoad1.2.xls', 'SELECT * FROM...

@ pradeep

2005 Enterprise edition with SP3

Regards,

Sushant

@ rick

Thanks for replying so fast

Its sql server 2005 enterprise edition with sp3

excel is 97-2003 with xls extension

Regards,

SusHANT

me also same problme

any help

??

there might be some network issues then.

try pinging the sql server from the cmd prompt

telnet servername 1433

If there is blank screen and nothing happens, that means connection is fine ,...

@ prabuk

Check in SSMS, server, properties, connections, wat is the remote query timeout

?

Regards,

Sushant

Often, it's the database being offline/closed or the SQL Instance being restarted/offline

Check it.

Regards,

Sushant

@ derrick

So, that means if it does ping successfully, then no need to check configuration manager?

OR

both are different and have to be checked seperately to ensure proper working of...