SQLRNNR (5/4/2011)

---

Another possibility is an app is trying to do something against that instance. Somewhere there is a connection string with sa in it that needs to be changed...

No Job is supposed to run every minute.

Regards,

Sushant

Why does...

When I import data from...

@ phil

Exactly

thanks a lot

Can you provide some links for all that stuff, so

that i can read and understand the basics..

Thanks

Regards,

Sushant

Yes there is enough free space on it...360gb out of 1.2TB is free.

Regrds,

Sushant

I am storing the backup via job in SSMS to another server.

Regards,

Sushant

When I scheduled the SSIS package in sql agent job, and ran from there

the error came up different :--

Column 'Description' cannot convert between unicode and non unicode string data types...

WARNING...

Phil Parkin (4/15/2011)

---

Have you tried connecting to the 2000 instance from within 2005 Management Studio? Once that's in place (use a linked server), you can just use standard queries to...

Horrible!!!

This is sql server forum for people all over the world...

How can u ask questions related to US....????

Wat abt the people outside states??

How...

I think I am getting near to the answer of my own question...:-P

Phil Parkin (4/14/2011)

---

SSIS can move data around as much as you want, but if you are new to the product you are going to have to spend some time getting...

[Jim].[dba].[Murphy] (4/13/2011)

---

Service Packs definately fix many issues, but also potentially alter the behavior of SQL Server too. They can include adjustment to how the Query Optimizer decides how to...