sp_databases dosn't return any value in Sql server 2008 express.
-
i'm trying to execute the "sp_databases" proc in sql sever 2008 express as "sa" but it doesn't return any value even though there are two customer created DBs available. what must be the problem.. any idea about this issue. thanx in advance.
-
i'm trying to execute the "sp_databases" proc in sql sever 2008 express as "sa" but it doesn't return any value even though there are two customer created DBs available. what must be the problem.. any idea about this issue. thanx in advance.
what happens if you execute
select * from sys.databases
As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
-
what happens if you execute
select * from sys.databases
As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
hmm i get all the DBs in the server . at the same time a found some articles saying that there is a permission problem i used
USE master;
GRANT EXECUTE ON OBJECT::dbo.sp_databases
TO public;
GObut still get the "Cannot find the object 'sp_databases', because it does not exist or you do not have permission." message. and also in the same machine i have another standard instance is installed and running, but there i get the list of DBs with this sp_databases. have any idea... thanx in advance..
-
hmm i get all the DBs in the server . at the same time a found some articles saying that there is a permission problem i used
USE master;
GRANT EXECUTE ON OBJECT::dbo.sp_databases
TO public;
GObut still get the "Cannot find the object 'sp_databases', because it does not exist or you do not have permission." message. and also in the same machine i have another standard instance is installed and running, but there i get the list of DBs with this sp_databases. have any idea... thanx in advance..
try
exec master..sp_database
As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
-
try
exec master..sp_database
As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
exec master..sp_databases executes but it shows nothing
-
hmm i get all the DBs in the server . at the same time a found some articles saying that there is a permission problem i used
USE master;
GRANT EXECUTE ON OBJECT::dbo.sp_databases
TO public;
GObut still get the "Cannot find the object 'sp_databases', because it does not exist or you do not have permission." message. and also in the same machine i have another standard instance is installed and running, but there i get the list of DBs with this sp_databases. have any idea... thanx in advance..
prasadbuddhika wrote:
dbo.sp_databases
Could this need changed to sys.sp_databases? I have 2008R2 and the sp is sys not dbo.
-
prasadbuddhika wrote:
dbo.sp_databases
Could this need changed to sys.sp_databases? I have 2008R2 and the sp is sys not dbo.
sys.database is a system table introduced with SQL 2005 and used in sql 2008 where sp_database is an actual stored procedure that has been present since sql server 2000 I believe
As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
-
sys.database is a system table introduced with SQL 2005 and used in sql 2008 where sp_database is an actual stored procedure that has been present since sql server 2000 I believe
As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
I guess I will wake up sooner or later. :zzz: The sp is sys.sp_databases
-
I guess I will wake up sooner or later. :zzz: The sp is sys.sp_databases
oh that something new learnt today it also works executing it on sys.sp_databases too :-D
As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.