Showing posts with label detected. Show all posts
Showing posts with label detected. Show all posts

Wednesday, March 21, 2012

Primary key in views.(SQL Server 2005)

Hello,

When I use MSSQL Server 2000, primary key in views(The primary key of base table) detected by sql server 2000.
But, new version (2005) do not this, that mean when I "Modify" a view in Enterprise Manager, there is not any Identity filed in list and I have some problem in my programming.
Please help me.Not sure I understand the request. What are you trying to modify. You can always use query editor to create/alter/modify a view's definition.

Can you elaborate more.

Wednesday, March 7, 2012

Previous version detected

I just dowmnloaded sql 2005. I have been trying to install sql 2005 install keeps saying a previous version exists cannot proceed three is no sql anywhere to be found. what do i do? The support to this point is non-existent typical MSFT if you are not the peron to help who is?

Can you go to Add/Remove Programs and let us know if you have any entries for SQL Server 2005 (including Native Client)? Do you have any other SQL Server entries in ARP?

Also, what version are you trying to install?

Thanks,

Sam Lester (MSFT)