I am going to server level security. right clicking add new user, sql auth

then when I go to user mapping.

as soon as click on DB1 DB_DATAREADER is selected and public

then...

yea.....that is the first place I looked...

you would thing that is the problem.since whatever is in public is by default everywhere else....but no luck

that did it .

thanks folks

keep it simple

set up your perf mon to fire off every 5-10 min and then set it save to cvs. Then you can just use EXCEL......after that you can...

I am not sure that there is reason to fire of #2.....I would just drop it.

beside that I would leave the way it is

try micheal coles book

full text reasch in sql server 2008.........

it is one of the few books on the market the cover this area

I would stay with the SP you could try to eliminate the branching....

do this by reusing the base SP for each new SP. Just a copy and paste....I think I...

We need lots more info....yes the index could be causing this. But to go from 30 min to 8 hrs you most likely have something else going on...

1. are you...

go to SQL server configuration manager/ sql native cliect config/aliases.....that should do it.....hope that is what you are looking for

good call guys...that was the ticket...thanks should have thought of that one

not sure exactly what you are looking for, sounds like you want to backup the database from the server to your client machine?

if so then create a job and set...

FYI for anyone out there

first declare both pieces as there own variables

Testvar = /c c:\practice_move_pdfs.bat

book = 48

then use the express builder @[User::TestVar] +" " + @[User::book]

just a heads up in, since FTS is not part of the SQL engine you will need be able to find log info through SSMS

the log can be found...

you are going to need a lot more RAM!!! to start.

but we need more info? how big are databases, what version and edition are you going to be running? so...

Perfect.......Thanks a bunch......dont know what I was thinking.....must of been on Crack!

THANKS again