How is the need for dual connections strings, both to data originating server versus where the data is going, handled?

that looks a bit too easy.

so as long as my connections are fine and i parameterize the to server/from server portion the SQL should work.

If this is the case why...

SELECT count(*) FROM msdb.dbo.sysschedules where name = @ScheduleName

gets a line count that will tell me what I need.

sry to bother, figured it out.

DOH! found it

SELECT job_id, [name] FROM msdb.dbo.sysjobs;

well not quite.

gives me jobs... not schedules.... will keep looking, it has to be similar.

Thanks!

will go forth with distrust in my heart, and suspicion in my actions ;). am paranoid a bit when it comes to my data....

I think i need to use: sp_add_schedule do accomplish that.

from microsoft docs:

EXEC dbo.sp_add_schedule

@schedule_name = N'MyJob',

@freq_type = 1,

@active_start_time =...

yea, am a paranoid.... and feel leery of this solution. Self scheduling scripts.... sigh, just makes me nervous.

I would most definitely add an email message and destination for documentation,...

yes this is option two. :-). I think I'm looking for the 'minimal' approach here. or basically, the least # of times i have to run the job...

Steve Jones - SSC Editor (1/23/2012)

---

I'd choose #1, but I'm conservative, and tempdb gets written to a lot, so I'd be worried about failure.

With the four files, one filegroup? Depending...

would either be stand alone or mirrored. Yes, I had considered that for speed as well, but decided against for that very reason. Thanks!

wondering if it was partially AD. I can get in but can't select out of a specific table. this account has datareader permissions.... can't read?

no restore.

exec sp_change_users_login 'Report'

generates an empty list of Username/UserSID

yes the Staff and Faculty database user is linked to the SFCC\Staff and Faculty DB Server User.

it was a minor syntax issue:

correct parens fixed. Der....

CASE

WHEN (SELECT WDF_SiteURL FROM dbo.vw_BASE_WebData_FacultyWebs_Classes_Join WHERE CLASSID = dbo.vw_BASE_CCSSM_REP_Stu_Class_D.CLASS_ID) is NULL THEN (SELECT WDF_SiteURL FROM dbo.vw_BASE_WebData_FacultyWebs_Classes_Join AS...