I don't see a reason why you should have SSMS 2005 installed when you already have SSMS 2008.

What are you trying to do?

The best way would be using Windows authentication.

Is it an option in your case?

You're right, sorry for suggesting a wrong solution.

I was thinking about old DTS packages.

You have no other change than running the whole maintenance plan, then.

You should see the log file...

Have you tried with SC? It should delete the service.

Sure. Open the maintenance plan, right click the cleanup task and select "Execute Task".

How do I log...

Weird. If I understand correctly, you say that the service status is "started" after a reboot.

What executable does the service point to?

To get rid of the service, you can...

ashanair70 (11/16/2011)

---

My backup failed last night. This is what I get in then log:

PRODDB Executing query "BACKUP DATABASE [PRODDB] TO DISK = N'U:\\PRODDB".: 50% complete...

Let me say that your table design is a bit questionable. For instance, what's your primary key?

I assumed it was WindowsUserName.

This should put you in the right direction:

CREATE TRIGGER trgAfterInsert_employee...

The simplest and most inefficient way to accomplish this is using a triangular join:

DECLARE @sampleData TABLE (

id int identity(1,1) PRIMARY KEY CLUSTERED,

num int

);

INSERT INTO @sampleData (num) VALUES(1);

INSERT INTO @sampleData (num)...

The filter predicate

trans.Company_Link =

CASE

WHEN @Company_Link <> 0

THEN

@Company_Link

ELSE

trans.Company_Link

END

looks like a great candidate for dynamic sql.

See here for more details: http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

Moreover, you have lots of LEFT JOINs, that don't help overall performance.

Hope...

Does the OCI connect outside SQLServer? You can check that with TNSPING.

If the connection is not successful in Oracle Client, it can't succeed in SQLServer.

If you need the disk space, yes.

Be careful: shrinking the database fragments indexes badly, you should rebuild your indexes after that.

If you don't need the disk space, leave it this...

Database Mail disabled for security reasons?

And OLE automation enabled instead?

Weird, I would do the exact opposite.

Ninja's_RGR'us (11/15/2011)

---

Ninja's_RGR'us (11/10/2011)

---

Actually...

rocky@123 (11/15/2011)

---

Okay...For working with SSIS first can i create linked server between sql server to oracle and then proceed or directly can i use the ssis for migrating oracle data...