I have several hurdles with this particular server.

1. It's a dedicated sql server used by a dedicated app server that hosts a 3rd party software.

...

Excellent explanation. Thank you so much!

I ran sp_removedbreplication and it ran successfully, but the errant replication artifacts are still hanging there causing errors.

/****** Object: LinkedServer [SomeServer.SomeDomain.NET] Script Date: 05/22/2014...

That script rocks!!! It should meet the developers' needs. Thanks!

Thank you everyone for the advice and info. I've had to concede that this is just how it's going to be and this person is going to do whatever they...

The job is only meant to be run manually. There are steps that have to be done on someone else's end creating and putting files in place, etc. It's archaic...

She needed to be able to add a button to her "application" (aka Access form) that when pushed, will fire off a SQL stored proc that calls a SQL Agent...

I'm seeing info about using an ODBC connection instead. That way the credentials would be masked. Isn't that a big performance hit though?

Yes. Thank you

I don't even know where to start. Do you know SSIS at all?

Sean Lange (4/28/2014)

---

robin.pryor (4/28/2014)

---

Can someone please give me advise on a better way to write the following?

SELECT a.BoxId, b.field1 as value1, c.field1 as value2, d.field1 as value3, e.field1 as value4...

Eric M Russell (4/15/2014)

---

The xp_logininfo stored procedure can be used to return the members of a domain group.

A couple years back I wrote a script that combines sys.server_principals and xp_logininfo...

Sorry the original "question" is so all over the place. Your response was very enlightening actually.

I put it in the Security SS2K8 section:

http://www.sqlservercentral.com/Forums/Topic1555563-1526-1.aspx