What service pack has been applied to the SQL Server 7 installation? Also, is it running under the context of a Windows user (not LocalSystem)?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish...

The problem you are running into is a distinction between the login (server level) and the user (database level).

When a login is made the owner of a database, the user...

There are a couple of issues with applications roles that you need to be aware. Application roles immediately eliminate user context and login context permissions as soon as they are...

It may have had to do with the fact that you had to open the shrink-wrap in order to read the licensing agreement... at which point you had accepted the...

Hehe, Bob, I agree with you, it is a nasty, nasty evil, but you know what? I've seen it more times than I have fingers (and I have my full...

SP 3 for SQL 2K allows for cross-database ownership chaining which means the user doesn't have to have SELECT rights against the base tables. Of course, the security can of...

The thing that kills you is the nice little semi-colon. For instance, imagine I had a page where I'm passing parameters like so:

http://www.myserver.net/showCustomer?id=1

And my code did something to the effect...

#4: Transcender, single-version, can't be redistributed once you've purchased it:

quote:

---

This license does not allow the product to be passed on, resold or...

A trigger on a system table won't be supported by Microsoft. However, auditing was a big concern, especially to get the NSA's C2 compliance for SQL 2K. Microsoft accomplished this...

You can use db_ddladmin so they can create stored procedures owned by dbo and db_securityadmin so they can assign permissions. Also, if a user is in both roles, the user...

And remember, if you do so Microsoft won't support it should you have a problem on that server.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Under NT 4.0 it probably has more to do with the fact that I only have two levels of hierarchy:

Global Group

Local Group

Of course with AD in Native Mode I can...

I've done it as a test to how well SQL Server handled "true" recursion and we even have a few stored procedures being used in a production environment that use...

Woo hoo! They finally released something on it, though it doesn't give info as to what causes the issue... oh well.

I think this is the GUI fix to resolve...

If the SQL Server is on a different system than the Cold Fusion server, you'll need to configure the client to recognize the port change. I can't speak for Cold...