Viewing 15 posts - 1 through 15 (of 71 total)
All right, as we used to say in the Marine Corps, 'Belay that last'. The posts in my most recent test were conducted from my dev machine, but just now...
August 3, 2011 at 12:14 pm
opc.three (8/3/2011)
You've lost me. The database owner is sa. If the procedure owner is dbo, isn't that also sa?
That's the hope, however I have a feeling...
August 3, 2011 at 11:50 am
opc.three (8/2/2011)
Permissions
Requires membership in the sysadmin fixed server role or membership in the public fixed database role in the master database with EXECUTE permission granted.
I think...
August 3, 2011 at 12:04 am
opc.three (8/2/2011)
The service running as Network Service sounds fine. You are obviously receiving domain info per the xp_logininfo results you posted.
Great, that's a step in the right direction.
Who owns...
August 2, 2011 at 5:03 pm
opc.three (8/1/2011)
If account_name and members are specified, a list of the next-level members of the group is returned. If account_name is a local group, the...
August 2, 2011 at 3:56 pm
Ok, thanks everyone for the input. Guess I'll leave it the way it is.
July 26, 2011 at 5:45 pm
Sean Lange (7/26/2011)
July 26, 2011 at 11:39 am
steveb. (7/26/2011)
Are we talking about a Transactional Database or a Database setup for reporting purposes (data warehouse / OLAP)
I'm not sure which category this fits. I've read up on...
July 26, 2011 at 10:53 am
OK, thank you everyone for the advice. Based on all that, it doesn't seem like full-text is the correct tool for my needs in this particular instance. I'll stick with...
July 26, 2011 at 9:55 am
ChrisM@Work (7/26/2011)
That's slick, and definitely going in my toolbox. I never would have guessed that could be done with set-based code.
July 26, 2011 at 6:55 am
GSquared (7/25/2011)
It would make sense to use FTS for that, but instead of defining all the combinations in the AlternateText column, build/buy/find a custom thesaurus for names.
I could do that,...
July 25, 2011 at 3:35 pm
Brandie Tarvin (7/25/2011)
The searches are based on words, and variations of words, that SQL "knows." Because you are using...
July 25, 2011 at 3:20 pm
GilaMonster (7/11/2011)
So it seems that for all my simple (two-field) lookup tables, I should have the primary key on the autonumber ID field, and an index on the text field...
July 12, 2011 at 3:17 pm
GilaMonster (7/11/2011)
pdanes2 (7/11/2011)
You say index the table with included columns, but the primary key is clustered automatically (and not just by default, as you wrote earlier, but unchangeably so)
By default...
July 11, 2011 at 1:15 pm
GilaMonster (7/10/2011)
pdanes2 (7/9/2011)
GilaMonster (7/9/2011)
pdanes2 (7/9/2011)
That's just to start though. For indexing queries one typically starts with the columns in the where clause. Order of the key makes a major difference,...
July 11, 2011 at 12:24 pm
Viewing 15 posts - 1 through 15 (of 71 total)