If you use Profiler, you can do several things:

1) Filter out TempDB. This will eliminate any temporary table creation.

2) You can parse T-SQL statements for CREATE, DROP, and ALTER, bur...

But SQL Server Agent is a Windows service. That means it runs under the context of a Windows user account or the LocalSystem. If it's running under LocalSystem and you've...

I see what you're saying. There's no way to add a new snap-in.

You may be able to modify the system.adm to add a policy to handle Enterprise Manager. There's...

Determine what account the SQL Server agent is attempting to run under. Add that user account to the System Administrators role (sysadmin) on the SQL Server itself.

In Enterprise Manager >>...

Yes, and this is actually true of any app. Unless the OS was booted with the /3GB switch or the /PAE switch and the app has been configured properly to...

Try having someone edit the group policy from a system where the Snap-In (the SQL Client Tools) have been installed.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance...

The second node will function just the same as SQL Server starting up, meaning database recovery, etc. In our own testing, we've not seen times > 30 seconds, which is...

Yes, you can. The sp_password will work on SQL Server logins even when the SQL Server is set to Windows Authentication.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server...

Best way to approach using EFS is to follow the rules as set forward in the Win2K Resource Kit. Basically, you need to have your recovery agents in place.

This...

Travlin, are there no options for "junior DBAs" within the environment? Perhaps some local developers and operations folks that can be trained to assist with the load?

I'll play devil's advocate...

Data and log file can be done using Encrypting File System. I have an article about how to do that on the site.

Tables are a different matter. You'll need...

In comparison based on the link, yes, hosting does seem more expensive in the US. Wow.

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

I see education in the category "Nice to have."

I think of it like scoring a vendor. There are some items that are must haves. There are other items where...

I'd love to go to PASS, but conferences are considered part of our training budget, hence the reason I've never gone. But every time Brian, Andy,...

Can you post the T-SQL code behind the tables and specifically the foreign key constraints?

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