Rangers look good, Rockies in first place, and Yankees playing well, despite getting shut out last night.

Looks like we have some teams roaring ahead out of the gate, others really...

Interesting. Not necessarily a hard query, but I'll have to see if I can fit it in somewhere.

I was hoping to come, but the timing was bad. If it were 2-3 weeks later, I'd...

Can you run the "dir" job from Agent and have that work?

It's definitely a strange error. It's almost like you have some token or kereberos issue with the job.

If...

Do the select without the cast to datetime and see what data comes back. If you convert everything to varchar at first, you can start to look for places where...

You do pull together the teams quickly, but that doesn't mean you haven't built relationships with people over time. We know people across time, we built relationships across time. If...

If you keep the databases in simple mode, you can really only DR from the night before. That's OK, but really ask your payroll people if the db fails at...

In Management Studio, right click a table, select Script Table, as Create, to wherever and paste that in here. You'll have something like:

CREATE TABLE [HumanResources].[EmployeeDepartmentHistory](

[BusinessEntityID] [int] NOT NULL,

[DepartmentID] [smallint] NOT...

I'd highly disagree. You're assuming that one or two interactions would build some confidence. If I corresponded with a mechanic for a year online, and he/she answered questions I had...

sturner (4/6/2011)

---

Jeff Moden (4/1/2011)

---

I've also seen folks that do it just the opposite. Encrypt the item you're trying to find and look that up in the encrypted column. ...

The Transcender practice exams I have seen in the past used to contain the actual questions on the MS exams. There was a time when Transcender, or at least someone...

You can use an application role to limit permissions inside the database to an application, but that does not alleviate some type of login, and as Gail mentioned, it does...

Mirroring would move the connections automatically, though it does require a more regular connection between the systems, or a good log size managements strategy.

Clustering isn't likely what you need, though...

Stephen's suggestions is what I've done in the past for similar situations, though usually for me it's been diff char sizes that exploded things.

In SSIS, you can get a "bad"...

AFAIK, ssms.exe is the SSMS executable. Can you search for that?