Viewing 15 posts - 1,996 through 2,010 (of 7,506 total)
No.
Just perform the grant as you used to
grant execute on dbo.sproc to youruser ;
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 10, 2011 at 6:42 am
Puja Shah (6/10/2011)
ALZDBA, Thanks for help.Following command worked:
GRANT EXECUTE ON SCHEMA::[dbo] TO user_name
-Puja
DO NOT grant to schema DBO !
This may be opening doors that shouldn't be.
The dbo schema contains more...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 10, 2011 at 6:06 am
By default, every execute permission needs to be granted explicitely ( unless the calling user is member of dbowner group or sproc owner ).
Since MS implemented Schema ( sql2005 )...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 10, 2011 at 4:02 am
- What's the exact error message ?
- Can you post your (new) sproc ddl ?
- can you post the ddl of a working sproc (by the same calling application)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 10, 2011 at 1:43 am
Congrats Gail.
Thanks at least that number of times for saving our ***. :kiss:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 9, 2011 at 10:31 am
jcrawf02 (6/9/2011)
Kiara (6/9/2011)
Grant Fritchey (6/9/2011)
Kiara (6/9/2011)
Tom.Thomson (6/9/2011)
Kit G (6/8/2011)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 9, 2011 at 7:05 am
No, it doesn't
It shows the actual startup time of the instance and just adds the database names at row level.
If you really seek for db startup, you may be able...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 9, 2011 at 6:29 am
GilaMonster (6/9/2011)
Is this person irritating anyone else, or am I just in low-tolerance mode at the moment?
Are you in desperate need for coffee 😉
You provided the perfect answer for him...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 9, 2011 at 4:04 am
It was my pleasure to get a first glimps of your article.
This is a lesser known topic, but definately has its place in SQL instance management topics.
Great job !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 9, 2011 at 1:41 am
Please post the full ddl of your object tcsINVTB00026_AttribAsgn
(i.e. script its create statement including all indexes and constraints )
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 9, 2011 at 1:35 am
You need to check this constraint 'AK3tcsINVTB00026_AttribAsgn'
Figure out what it is ( obviously a unique key ) and for which column(s) it goes and figure out what is wrong with...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 8, 2011 at 2:14 pm
If you mean adding the db name to the result rows ...
SELECT @@servername as ServerName, getdate() - S.login_time as SQLServer_UpDateTime_1900_01_01
, D.name as DbName
FROM sys.dm_exec_sessions S
cross apply sys.databases D
WHERE...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 8, 2011 at 12:51 pm
if sqlserver is running and the database is open, you cannot delete the file on the operating system.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 8, 2011 at 6:54 am
Yes
Keep in mind your Witness server doesn't need to be EntEdtn. fwiw it can be an express edtn.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 7, 2011 at 2:52 pm
mister.magoo (6/7/2011)
ALZDBA (6/7/2011)
SQLRNNR (6/7/2011)
ALZDBA (6/7/2011)
What's with the watermark on our SSC ??Is it webmaster fun, or is SSC changing logo ?
Where do you see this watermark?
I get to see it...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 7, 2011 at 2:50 pm
Viewing 15 posts - 1,996 through 2,010 (of 7,506 total)