Jeff Moden (2/24/2015)

---

Just curious... does anyone use RedGate Compare to promote code from Dev to Staging to Prod? Looking for both positive and negative comments on experiences. Thanks...

I have seen some high-level DBAs make some interesting career/pay decisions....

One chose to reduce his work days....he worked four days a week. Having the three day weekend every week...

kevin77 (2/18/2015)

---

I think this is the best one I've seen thus far. Good job, Bob.

I can just imagine giving a co-worker a fly swatter or something an labeling it...

It is possible the mismatch isn't due to leading/trailing spaces or the special characters. It might be extra spaces inside the text. For example:

These don't have leading/trailing spaces...

As I see it, maintenance plans are like a GUI....they get the job done, but you are allowing SQL Server to create the scripts and figure out how to do...

I'm not sure how much 'contracting' work you will get for just telecommuting. Think of it this way, if you owned a company, would you hire someone you don't...

First, this site is for Microsoft's SQL Server and while they are similar, MySQL has some differences and one of them is where your issue is. This part is...

I missed something in your original post...you are tracing for RPC. Change that to SP:Starting and SP:Completed. Those are for stored procedures.

-SQLBill

Leave out the database name. I've found that to be an issue and here is the reason....

You need to find out who/what is running proc1 that exists in DB1....

While you can't 'mask' the GUI options, there is a possible solution (at least for the CREATE DATABASE part).

Try a Database Trigger....

CREATE TRIGGER tName

ON ALL SERVER

FOR CREATE_DATABASE

AS

<code the criteria>

I've...

I think for most people who stay employees (myself included) is the "guaranteed income", along with the paid benefits (health coverage, etc).

Consulting can be great, but until you are 'known',...

schleep (12/31/2014)

---

Thanks for the reply Sigerson,

What I'm actually after is a T-SQL procedure or function to which I can pass the variable containing the generated code...

I tried a roll-your-own proc...

yes. You can create a SQL Server login just for your application to use. You just have to apply the appropriate permissions.

For example:

create myAppLogin

grant it access...

Go Steelers!!!!

If there's no error in your logs, that seems to indicate the connection isn't getting that far.

Are both your coworker and your database server on the same domain?

Did your coworker...