I've found that if I just include the line ' IF ((@TablesToDeleteFrom
& 1) <> 0) ', everything works fine (even though I don't understand the
'&1' statement). That means it's the remaining part of the code that is
causing the problem. Unfortunately I don't know enough about TSQL to
know exactly what that line is doing. I was hoping someone could tell
me what the line:
((EXISTS (SELECT name FROM sysobjects WHERE (name =
N'vw_aspnet_MembershipUsers') AND (type = 'V'))))
is actually doing. It seems that its looking to see if the name (ie
username input param) exists in that view, but that's just a guess and
it seems wrong bc when I manually query the view, I do find the user
with no problem. .
Thanks in advance.
The procedure is checking whether the view exists. I can't imagine why.
Perhaps you should ask the authors.
> IF ((@TablesToDeleteFrom & 1) <> 0)
You should look up the "&" operator in Books Online:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_operator_7fax.asp
What value are you using for this parameter?
ML
Thanks.