Viewing 5 posts - 1 through 5 (of 5 total)
vk-kirov (8/24/2011)
Hafiz Muhammad Suleman (8/24/2011)
no use and still it executes our db sp when execute sp_one
Database context should be changed to 'master' before executing the sp_ms_marksystemobject procedure:
USE master
GO
EXEC sys.sp_ms_marksystemobject 'sp_one'
GO
USE...
August 24, 2011 at 1:57 am
vk-kirov (8/24/2011)
michael.kaufmann (8/23/2011)
Hafiz Muhammad Suleman (8/23/2011)
one question : how can we create a system procedure in master by ourselves ?
I may be wrong, but as far as I know, you...
August 24, 2011 at 1:09 am
Christian Buettner-167247 (8/23/2011)
elbedata (8/23/2011)
Has this changed in later SQL versions? I am pretty sure...
August 23, 2011 at 2:50 am
MS documentation is wrong as i tried and it exectue test2 DB sp instead of master db sp , but micrsoft says that it should first search in master db...
August 22, 2011 at 11:41 pm
Important If any user-created stored procedure has the same name as a system stored procedure, the user-created stored procedure will never be executed. (from Microsoft)
then how it executes test2...
August 22, 2011 at 10:50 pm
Viewing 5 posts - 1 through 5 (of 5 total)