If the databases are on the same instance, then use four-part naming to refer to the tables that you need in your join.

If the dbs are on different servers, then...

It seems like the login that you are using to access the API, does not have permissions for the method that you are trying to call.

Are you able to check...

what is the error that you are getting when setting up a linked server?

You can use the import/export wizard to do this

or

create an SSIS package

or

Setup a Linked server and use INSERT INTO.

I would go with the SSIS package..

Mirroring won't help in this situation.

Snap-shop replication could be used though.

Don't do this,

Shrinking the transaction log is not a good idea especially on...

This should work

Select Name, Min(Sal), Sum(Sal)

from employee_san

Group by name

You are selecting more than one column in the sub-query , this will not work in an update statement you need to only select the one column that is...

You will def need to do some sort of cleansing of the data first. Depending on your programming experience VBA is not that difficult to learn, start simple and...

To insall a named instance , just run the SQL server installation again and this will give you the option to install a named instance.

Okay, there are a couple of ways you can deal with this..

You have merged cells in your worksheet this will lead to problems. I would write some VBA...

pat (12/17/2008)

---

Hi all,

I am trying to get the file load from SSIS package btu the problem si i have file with first row is file and other information name!!...

Start --> Control Panel --> Add or Remove Programs --> Microsft SQL Server 2005 --> Remove

yes this is possible,

you will need to use the Substring funciton to split out the CSV values.

haev a look at this article for an efficent way of dealing with this..

...

no worries, glad it worked...