Not multi - VLAN, I believe; the servers are in AWS and VLANing isn't supported there. The subnet masks are set to make the multi - subnets, aren't they? So...

Something to remember if aliasing - it can become VERY confusing for a new starter. I've been dropped into an environment where some servers used aliased names and struggled to...

One thing to remember is that, while the DB will be entirely in the proper format - DDL dust bunnies will have been vacuumed up! - I believe that the...

Fully agree with the previous 2 posts - but from a purely practical point of view...

Remember you could create very tight permissions for the account which needs to access the...

Just to add a comment - I have exactly the same issue. Looking at why a query has suddenly stopped returning I found the same thing - a string of...

sp_update_job is definitely the way - the GUI disable and updating the table directly both seem to cause failures.

The deployment was using SSMS 2008 on a remote PC. The security setup was (on the development package) the default encrypt sensitive using user key, and on the import to...

Sorry, all - this is actually SQL2008 not 2005 but I can't see how to switch forum/delete the post so I've created a new one in 2008 General!

I guess the table is about 25GB so I think the log will fill and then the statement will stall.

How about:

- Create a new copy of the table (with the...

You sound very surprised about the number of rows - are you sure it's actually true? I'd be inclined to run some DBCC to make sure it's not got its...

That's absolutely correct. SQL works in a similar way to Windows - once you are authenticated in the server you're fine until you disconnect. This is the same with Integrated...

I have also seen remote queries do wierd things in the optimiser. In addition multiple joins into a remote table will be relatively slow. How about this:

1. Create a temp...

Brandie

This definitely happens when disabling from the GUI (see previous post). The system SP runs another SP, sp_sqlagent_notify, which clears the cache for the job; again, see previous post. So...

Just a note, if you remove the users' local admin rights on the machine, you will then need to get a domain admin (or someone else who is a local...

Found an update. SQL Server, in the sp_update_job, runs "exec msdb.dbo.sp_sqlagent_notify @op_type = N'J', @job_id = @job_id, @action_type = N'U'" which resets the cache for this Job_ID. So there is...