We'll probably need a little more info....

Is this a new database setup, or are you moving from an older one to a new one? Off the top of my...

Gahhhhhh, it's an ID10T error, on me :-/ The order of procedures in my code was causing a valueto be cleared out that this function depends on. ...

Thanks for the reply, and let me see if I can get some specific code about whats going on.

I've narrowed it down to this section of code:

SELECT DISTINCT @GetAILanguage =...

Ahhhhh, intersting! Thank you, that looks like it might work!

Thanks for the input. I might try the stored proc route, or just making a note of it for now. Like I said, for the immediate future, this...

Ahhhh, thanks! I hadn't thought about trying to do it all in a join....I'm working on inherited code here :-). I'll try and compare the performance between...

Yes, I'm connecting as a sysadmin, and using a SQL Server account. The thing is, if I use SQL Server 2000 Enterprise Manager, it works fine (connecting as the...

Nice article. Anyone know of any resources on managing SQL 2000 from a SQL 2005 interface? We're still on SQL 2000 for our production database, but we've started...

I actually just ran into a "problem" involving the server roles in SQL Server 2000 (and I believe 2005). We have a VB application used in house, and users...

Thanks. Basically, we have designers/developers with SQL logins, but they also do things within the application (which records the username). It seemed better to have one login, and...

Thanks for the reply. So if we have certain admin users who log into SQL server but who we want to be able to perform dbo roles, what is...

That looks like what we're going to do. The thing is, old (poor) database design has a corresponding SQL login user for every user of the system (which is...

Thanks for the reply! It's actually a user defined function - it's being called from classic ASP code and returning a value. There is logic within the function...