July 28, 2009 at 1:55 am
Hi.
I have instaled SQL Server 2008, with all of its components, but the system catalog views doesn't appear. for example, the instruction "select * from sys.credentials" doesn't work, because the view doesn't exist.
What do I have to do to create the system catalog views?
Why the sys.credentials view doesn't exist?
Thank you in advance.
July 28, 2009 at 2:12 am
Didnt understand your language. Can u state the problem in English please as most of the members use english here....
July 28, 2009 at 4:00 am
Hi, excuse me for my mistake.
I translate the message now.
I have instaled SQL Server 2008, with all of its components, but the system catalog views doesn't appear. for example, the instruction "select * from sys.credentials" doesn't work, because the view doesn't exist.
What do I have to do to create the system catalog views?
Why the sys.credentials view doesn't exist?
Thank you in advance.
July 28, 2009 at 5:45 am
There is no process for creating system catalog views. They are part of the normal running of the system and will be there after a successful install.
Are you sure you're connected to the right server, you don't have a typo in the code... something.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 28, 2009 at 6:42 am
Hi.
Thank you for your answer.
I have a laboratory with SQL Server 2000, 2005 and 2008.
I have discovered, that SQL Server 2008 engine works right, but... the real service that the engine is using, is de EXE file wich is in the SQL Server 2000 directory.
I'm trying to correct it.
I'll tell you if was it or not.
Thank you.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply