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 2000 Forums  SQL Server Development (2000)  Identifier to long?

Author  Topic  Wouter Starting Member 8 Posts Posted - 2000-11-02 : 12:21:31 Hi, I wanted to pass a string to a stored procedure. As soon as I execute the stored procedure I get the error message: The indentifier that starts with '....' is too long. Max. length is 128 I use the following code: strSQL = "sp_Messagelist [text goes here........]" The variable declaration is set to 1000 chars. which is more than I would pass to the stored procedure. I use SQL server 7. Anybody an idea what the problem could be? Thanks