If you take GSquared's approach, all the common data will be in one single database. There should be no issue in referential integrity.

If you know what the job is doing, you may check the status (percent-complete, estimated complete time) in sys.dm_exec_requests if you could figure out the sessionid, requestid etc...

Rather than install another Instance on the cluster, maybe you could ADD your new databases under the same existing instance.

I think it depends on your major duties.

In my company, we have a Database administrator Manager whom I am reporting to. As the only SQL DBA here, my main...

On your passive node, Go to your START-->>RUN, type in 'sqlwb.exe' and see what will happen.

Also, I use management studio for all forms of management, If I reboot my computer, it means that I loose all the connections that I have made with all the...

Charles Hottle (1/29/2009)

---

It looks like the job may be associated with a maintenance plan. Try to find that and delete the maintenance plan first. That may also delete...

Not sure what you want to compare exactly...

Found the following two on codeproject.com

Database compare: http://www.codeproject.com/KB/database/DBCOMPARE.aspx

Schema compare: http://www.codeproject.com/KB/database/SideBySideSQLComparer.aspx

Go to Column Filter,

Choose TextData ,

in LIKE, put %YOURTABLENAME% in

AND CHECK the box ' Exclude the rows that do not contain values'

Not sure what you really want to achieve.

Does your filepath dynamically change according to the job steps?

or is it just a static filepath that is repeatedly used?

If it is...

What error did you see when you tried to create a maintenance plan?

How did you try to create the plan?

Maybe locking pages in memory could help you.

Look at these:

How to: Enable the Lock Pages in Memory Option (Windows)

Or here[/url]

also look at this... for what can be...

Ask this on the SSIS forum.

http://www.sqlservercentral.com/Forums/Forum148-1.aspx

Bet you will get a better shot.

You can use variables in job steps.

But you can not refer to a variable that is in another step.

You have to declare them seperately. and the scope for the...

Run the following and see what are there:

USE YOURDATABASE

SELECT object_name([object_id]) AS Objects_IN_Filegroup

FROM sys.indexes

WHERE data_space_id=104