Viewing 15 posts - 8,986 through 9,000 (of 9,720 total)
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...
January 31, 2008 at 9:04 am
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...
January 31, 2008 at 8:27 am
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...
January 31, 2008 at 8:14 am
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! @=)
January 31, 2008 at 8:11 am
Yes, this thread was hijacked by smk for different questions.
s.rich, did you get your question answered?
January 31, 2008 at 4:11 am
Have you tried testing this report with your own internal email address? It might be you're having problems because you're trying to send the report to an external address.
I'm...
January 31, 2008 at 4:08 am
That's an old Customer Service / Retail adage too. You never tell your customer "I don't know" or risk losing their business. You always make an effort to...
January 31, 2008 at 4:05 am
Let us know how that works for you.
January 30, 2008 at 10:27 am
Hmm. I just went and looked at the Group name that we're using for our jobs. In MSDB, this group has Public, RSExecRole, SQLAgentOperatorRole, SQLAgentReaderRole and SQLAgentUserRole all...
January 30, 2008 at 7:27 am
DB_Owner shouldn't matter. You are correct in assuming that SysAdmin will override that. I was worried about possible DENY permissions getting into the mix. Maybe there are...
January 30, 2008 at 6:20 am
AD shouldn't affect what you see in SQL Server.
Can you give me a list of all the settings you've got in SQL on that particular group login? ...
January 30, 2008 at 5:43 am
Triple check all the login properties of the group. Make sure the Server Roles really does have SysAdmin checked. If not, check it. If so, then see below.
Test...
January 30, 2008 at 5:09 am
I've never had to do that. I've always been able to change the owner via the SSMS GUI.
Just to clarify, what I've always been able to do (because the...
January 30, 2008 at 4:53 am
I'm a little bit confused, then. How can the group have sysAdmin access if the group doesn't have a SQL Server Login?
Check both the server security section and sp_helplogins...
January 30, 2008 at 4:18 am
Ed,
That is an *excellent* way of rephrasing the question! Thanks for that. @=)
January 30, 2008 at 4:16 am
Viewing 15 posts - 8,986 through 9,000 (of 9,720 total)