Check out

http://www.sqldts.com/default.aspx?205

sqldts.com has a ton of articles about this stuff.

copying between servers is easy, you can set up connections for each server, and create data pump tasks.

Take a...

I'm totally confused.

You should not have to drop the primary key constraint on a table just to drop a column. (Unless the column you want to drop participates in the...

Not sure what you mean by sort by parameters,

But I am assuming you want to sort by fields in your report.

Have you tried to look at the properties of your...

Good article about using "Arrays".

Some good information

http://www.sommarskog.se/arrays-in-sql.html

I usually get this when I have a query/procedure in an endless loop, and I stop it.

Does this procedure return tons of data within a loop?

Make sure your code is...

When U have more than 1 sql server instance installed on a server you must fully qualify your sqlserver name

MyMachine\SqlserverInstanceName

Have you tried using case statement, This is a cross-tab query

select b.customer_id, Product_Name, [year],

       sum(case [month]

          when '1'

            then payment

       end) as [Month1_Year1_Payment],

       sum(case [month]

         ...

You can try some server side tracing, (not using profile)

But I do not think the work can be done in a trigger.

http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm

To give access to other machines you need to make a domain account, that is used only for services, (Cannot log on interactively)

Set sql server service, and agent service to...

Hard to diagnose,

Try running

dbcc freeproccache

which will clean sql server procedure cache and destroy any saved execution plans then try to run again.

Other than this and verifying the...

Could you please more clearly define what you are trying to do.

Post a sample table definition, some sample data, and what your expected results are.

It is not likely that you...

The really really short answer is

Nope

I have not seen anything.

IMHO optimizing is as much an art as it is a science.

The easiest...

Its hard to say, and it all depends

Can you present us the view definition?

When you state "The view takes a long time to run" what exactly do you mean?

Please post...

The job runs under the context of the owner of the job in Sql Agent. (Opent the job in the owner dropdown in the general tab)

The owner needs to be...

Sql server does not have anything out of the box.

You'll need a third party application like Sql Compare, I belive from Embarcadero (Forgive spelling)

Seems like you have a code...