Sorry, I already have a permanent job, with an...

does this qualify?

http://www.sqlservercentral.com/Forums/Topic1017057-391-1.aspx?Update=1

erm...You obviously need access to the remote objects you try to access through SSIS....

don't really know how else to explain it?

Do you...

check under SQL Agent, Jobs (right click), view history/

error screen clearly indicated that Login Failed for your account.

please provide...

andy.l (11/8/2010)

---

When i run the following query:

SELECT transaction_id

FROM sys.dm_tran_active_snapshot_database_transactions

ORDER BY elapsed_time_seconds DESC;

I get the ID for a transaction that is currently running. But, how can I manage to find...

post your query?

Brian McGee-355525 (11/7/2010)

---

I have two databases, a publisher and subscriber. The msrepl_tran_version values appear to have got out of synch.

The databases are 540GB each. They are on two...

Harshana-680014 (11/7/2010)

---

normally I'm using command, It is ok for me, but I've teched to newby, to do using SSMS, so that was a headache, coz. using commands is not much...

use the syntax as:

alter table tablename

ALTER COLUMN columnname INT NOT NULL

or if you really want to modify in the UI, do the following:

Tools ->Options-> Designers -> Table and Database...

harita (11/3/2010)

---

Hi, all

How to check the Health of a database in sql server 2005 and what is 'Health' concept,

and how to know if the transactions are committed are not, can...

You need an OS with Cluster support, Server 2003 or 2008 would be best to test.

You'll need to target WMI on the remote/local server to monitor CPU

Under your SQL Agent, you can make use of the Alerts, configure it custom to CPU Util....with a threshold.

Configure the Response to notify an operator.