Viewing 15 posts - 5,356 through 5,370 (of 7,429 total)
Andy is right and you may have to correct the problem with the server name change if you are copying the master over. Several threads on that here.
"Don't roll your...
June 20, 2002 at 5:36 am
Look in SQL BOL at GRANT, REVOKE, and DENY. The syntax is there. I Showed REVOKE but full details on it's use are in Books Online.
"Don't roll your eyes at...
June 20, 2002 at 5:33 am
I believe that in the command prompt you will see error: and the number and failed but not sure what line this will be on and it has been some...
June 19, 2002 at 7:55 pm
Let us know what happens.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 19, 2002 at 6:23 pm
Ok then I suggest running Profiler to trace the transactions that occurr after the load until you cannot find your data. Something has to be issuing a truncate table or...
June 19, 2002 at 6:21 pm
Your biggest enemy is the fact you have four table scans that occurr in your query thus slowing you down.
Based on what I see this is my thoughts
Add an combined...
June 19, 2002 at 6:17 pm
First, will the structure of the data be the same, no column changes? If so then there have been several ways proposed in other threads. If the name is unknown...
June 19, 2002 at 5:52 pm
It has been a while but I believe you can set it up so the guest has rights to access the data (but not alter) then the mdw is not...
June 19, 2002 at 5:49 pm
Sorry you still are not making sense to me. Can you back up and explain the issue and what you need to happen?
"Don't roll your eyes at me. I will...
June 19, 2002 at 5:42 pm
Also can be a problem with your connection as defined in the ASP page (how you make the connection, type of connection (named pipes, tcp/ip). Could be configuration of the...
June 19, 2002 at 5:41 pm
That is odd, I would have thought Administrator would too unless you moved to a domain or ADS environment. But the key is you have an answer that works.
"Don't roll...
June 19, 2002 at 5:37 pm
Links are ok to post here and I am curious about this propsed method.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 19, 2002 at 5:31 pm
Backup, you state the problem is they cannot alter the view. Have they tried
ALTER VIEW theirlogin.viewname
If not a memeber of dbo then the view ill be created as theirlogin.viewname...
June 19, 2002 at 5:27 pm
Sounds like an install issue with EM if you can ultimately get it enabled otherwise I would say permissions. Try reinstalling just EM and see if corrects.
"Don't roll your eyes...
June 19, 2002 at 5:22 pm
For things like create login there is a specific level a use has to be at and it is checked before run. I don not believe you can bypass this...
June 19, 2002 at 5:20 pm
Viewing 15 posts - 5,356 through 5,370 (of 7,429 total)