Showing posts with label include. Show all posts
Showing posts with label include. Show all posts

Monday, March 26, 2012

Gen Script - Include Role Permissions

I need to generate a script that includes the permissions set within a role
on various tables.
How?
KevinFrom the Generate SQL Scripts dialog, check the "Script object level
permissions" box on the Options tab.
"Kevin Evans" <kevin@.convenientcomputing.com> wrote in message
news:e3oK4eL2DHA.4060@.TK2MSFTNGP11.phx.gbl...
quote:

> I need to generate a script that includes the permissions set within a

role
quote:

> on various tables.
> How?
> Kevin
>

Friday, February 24, 2012

Full-Text Search in SQL Server 2005 express

I installed SQL Server 2005 express with advanced services which is supposed to include full-text search capability but I can't get it to work. When I try to create a full-text catalog it gives me an error because it does not think the full-text service is installed or loaded. I can't seem to find a reference to the full-text search feature to enable or install it. any ideas?

There are problems as you already know but there is a work around solution in the link below. Hope this helps.

http://www.wherecanibuyit.co.uk/ASP/full-text-search.html

|||

That was helpful. Thanks. I had to remove sql server 2005 express and reinstall it and then everything worked fine.

Caddre:

There are problems as you already know but there is a work around solution in the link below. Hope this helps.

http://www.wherecanibuyit.co.uk/ASP/full-text-search.html

|||

dsa1971:

That was helpful. Thanks. I had to remove sql server 2005 express and reinstall it and then everything worked fine.

Caddre:

There are problems as you already know but there is a work around solution in the link below. Hope this helps.

http://www.wherecanibuyit.co.uk/ASP/full-text-search.html

I am glad I could help.