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.
| Author |
Topic |
|
john70
Starting Member
1 Post |
 Posted - 2002-08-08 : 04:33:23
|
| Hi, I have a stored procedure that I execute against a SQL 7 database without any problems....I have then the same database installed on a SQL2000 server, what I want to do is simply to execute the same stored procedure against the 2000-database. When I execute it against the 2000 database I get the following error msg " Error 1004: Invalid column prefix T2 : No table name specified " .....my stored procedure looks like this :SELECT @pwd = T2.ATTRVALUE, @node_id = T2.FNODEFROM NODEDATA T1 INNER JOINNODEDATA T2 ON (T1.FNODE = T2.FNODE) WHERE (T1.ATTRID = 'LOGIN') AND (T1.ATTRVALUE = @USER) AND (T2..ATTRID = 'PWD');Can someone please give me a hint why its possible to run this code in SQL7 but not in 2000 ??????****PLEASE RESPOND TO GROUP ***Help very appreciatedRegards/John |
|
|
OMB
Yak Posting Veteran
88 Posts |
Posted - 2002-08-08 : 04:45:30
|
| Might have something to do with the(T2..ATTRID = 'PWD'); Should be (T2.ATTRID = 'PWD') OMB |
 |
|
|
|
|
|
difference between SQL7 and Sql2000???