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...

You can give a user EXECUTE rights on sp_sdidebug, an extended stored procedure, and this should allow the user to debug.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsdebug/html/vxlrfSettingUpDebugUser.asp

This also works on MSDE 2000, but I'm not sure...

They have to prefix it. By default only the database owner (who maps to dbo), those who are aliased to dbo, and sysadmins (who map to dbo) automatically create objects...

Sounds like someone needs to go look at that video conference policy, though. If removing it solves the issue, and other links have the policy and don't have problems, it...

It's hidden well, isn't it? I missed it initially, too.

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

OpenHack 4's configuration is an extreme, but very effective solution. However, I don't know if it is considered "supported."

A good resource, though, which includes Registry security, is Microsoft SQL Server...

Keep in mind that I have foundational knowledge of networking concepts, but am in no way an expert, especially as far as QoS is concerned. But here are some questions...

I know very few companies that have a very small domain admins group. This seems to be a perpetual nightmare.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide...

You've made it harder to get at the code (though a disassembler still does it). The only requirement is you've got to have someone with the expertise in C++/VC++. Doable....

It's on the menu bar (Home | Resources | Community | Products, etc.) at the top of the page.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to...

Try this:

http://www.sqlservercentral.com/Search/fulltextsearch.asp

You can select whether to search against just forums or just articles.

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

Steve Jones has posted a script that he found that works wonderfully. Here it is:

http://www.sqlservercentral.com/scripts/contributions/26.asp

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

Actually, Full-Text is supposed to run under localsystem. Configurations of full-text other than this aren't supported:

http://support.microsoft.com/default.aspx?scid=kb;en-us;295034

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

This is very true. If you are using local groups, look at using sp_change_users_login to get the database users in sync with server logins. This also works if you are...

If you are running SQL Server Agent, you can set up an alert to fire for both create and delete.

The error numbers you'll want are:

Create Database: 1805

Drop Database: 3738

When you...