Hi,

BCP is a seperate standalone utiltiy that needs to be executed from command prompt. You can't run it directly from Query Analyser or SSMS, if you want to execute it...

Hi,

Kindly provide modify privilege to SQL service account to the path "C:\Program Files\Terrsoft CRMX25" and then try executing the script.

Hi soenita.sattoe,

Can you post the connection string thaty you are using in your application??

Hi,

I think you need the backup of the database to be mirrored to another path in the same server Right???

If yes, then you have the option in Backup database command...

I'm not sure in this, I think Copy database wizard is not in SQL Express.

You can detach the database in source server, copy it to destination server and attach it...

Hi,

Im not sure whether this helps, try installing native client manually. You can go to Tools folder in the second CD under setup folder you can find a file sqlncli.msi,...

Hi,

You said you can install in Local system account. Then install SQL in Local system account, because service account can be changed later using SQL server configuration manager.

Before changing...

Hi,

You have said that you have first created login and then restored dbs. By doing above the default db for the login will be changed to some other database, because...

If you are having third party software, then you can rely on this since it has some features compared to native backup.

Refer the below links, this has been already discussed in SSC

http://www.sqlservercentral.com/Forums/Topic266697-146-1.aspx

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1208884&SiteID=1

I hope these links will help you

You can also do the following things if you forget your "sa" password.

Consider sql services are running in "sqlservice" account.

------------------------------------------------------

1.) Provide logon locally privilege for sqlservice account

2.) Login with sqlservice...

Hi,

Most of them prefer SQL server native backup, since you dont need to pay additional cost for taking backup.

If you are moving for third party backup tool you need to...

Hi,

If you are going to set recovery model to simple then try the following

1.) You can shrink your db logfile so that the size can be reduced.

Shrinking the Transaction Log...

As said earlier, can you check errorlog and post the info here. Since the same situation has happend to me, while checking the errorlog i found there are lot of...

Hi,

Try this

1.) Create a linked server to the MS Access db

2.) Create the DDL trigger and using the created linked server you can update the MS access db.

I hope this...