I think the format is the same as 443, but since I took 447 instead, I can't be positive.

Please do not post new questions to an existing thread. Post a new thread.

The above posts bring up some good points. You have to weigh your domain needs against the job needs.

The reason my workplace uses domain group ownership of the jobs...

I am completely out of ideas at this point. You probably should call Microsoft support.

Sorry I couldn't help.

Right now we're on SP1. We haven't been able to upgrade to SP2 due to space issues (which we're getting resolved shortly).

Maybe that's the difference here. It'll be...

One thing for sure. For those of us who go looking for the answer before we click anything, the QoD sure can hone a person's research skills. @=)

Really?

Hmmm. Looks like ER/Studio merits a second look from me. I'm one of those poor souls whose job it is to wade through all that documentation and I...

Use SQLServerCentral;

GO

Set Rant_Warning ThisThread On;

I...

YesYesYesYesYES... On both.

How many times have we gone out to the websites looking for the solution to a problem and seen the line "This fix is only for X problem,...

IMHO, both are better than Visio. Visio just doesn't have the toolset to do all the things I want it to do.

I've only looked at ER/Studio for about 5...

Matt,

I like that one! Of course, it doesn't work if the table doesn't actually exist in the database you've got the query editor set at (forgot to change over...

Neat trick to get around not knowing column names...

Select Distinct sc.Name + ', '

from sys.objects so

join sys.columns sc

on so.Object_ID = sc.Object_ID

where so.Name = 'MyTable'

Cut & Paste the result set...

What version are you guys using that ER/Studio converts Erwin? And what type of files have you saved in Erwin that makes the conversion so easy?

When I tried to...

Actually, Lynn, I've only given you a small portion of the entire piece, so that might be why you're having problems with it.

I've decided to go with the four individual...

Actually, my problem may be resolved. I thought we weren't going to be able to get the latest version of Erwin, but now I'm hearing differently.

Here's hoping! @=)