Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 built-in stored procedure

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-03-20 : 09:49:43
Vagiz writes "I hope I can clearly picture my problem:
There is a built-in stored procedure - sp_addextendedproperty. And one of the properties that it takes - @value=N'False'. I duplicated one database which was created by somebody else and for some reason in the copy version it is written as @value=N'False' while in the original table it is written as @value=False. There are three characters difference. Is it a significant difference? Because when I'm trying to open the table in Access it says that "The stored procedure executed successfully but did not return records." and I tend to think that since those three characters were the only difference in the script they are causing some problems. Why is that? When I'm running the table from SQL Analyzer it shows the whole table just fine.
Thanks"
   

- Advertisement -