Hi,

Good shot 

I did it already but not the same as ur told me .

I share with how i did it may help...

u should have log on permission on the nt or windows server.

from

Killer

by what account ur sqlservices running.Do not use local account.

from

killer

Hi,

Did u fix the memory usage for SQL Server is yes then change to dynamic.

Look in the SQL Server Properties.

HTH

from

Killer

Hi,

Ur database is in full recovery mode.As ur databae size is very small so chage the recovery mode to simple.

Then the logfile with not grow so much.

As in full recovery...

Hi,

Thanx a lot , it run so well.

from

Killer

Hi Sergily,

It is in binary ex:0x...... but i removed 0x from the bignning of the records, i transfered the record in a varchar field as written above.

I am not  good at programming i need the data...

Yes it is.

from

Killer

Dear ,

Can u pls paste the code here.

from

Killer

Hi Rahul,

This is not Exactly ur BCP Timeout Error .Ur Sql Server is not responding to the conmmand u executed.

U can increase the timeout time from SQL server Setting.

If ur...

Hi,

This is how we can execute the DBCC command on linked server or Remote Servers.

EXEC svr_test.master.dbo.sp_executesql N'DBCC MEMORYSTATUS'

from

Killer

hi,

U can setup profilor or u can  also enable C2 auditing level from sp_configure.

HTH

from

Killer

Hi,

U can check two views sys.databases and sys.sysdatabases then u can easly notice that there 6 sysdatabases given id as 1 to 6 and else are userdefined databases.

So can use...

Hi,

U are using the ip address which will not work with BCP give the ServerName and give logon user permission to the folder u are copying the file.

Ex:  Server.rs.com

if ur...

Hi,

In my second post i had written i solved the remote connection issue.

I solved the problem.When we work on local machine we have to choose Truasted connection.

But when connection from...