In some cases, yes, but not in all cases. My GSEC practical is now online. Its title: SQL Server 2000: Permissions on System Tables Granted to Logins Due to the...

Are both NICs active on the network? Do you mean just SQL traffic or all traffic?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

I agree with nyulg here. Intel itself says the performance gain isn't the same as a second physical processor. Their benchmarks show about a 30% increase on some server apps....

Keep in mind that as either a member of the db_owner or db_ddladmin role, you could create objects that are dbo owned. We make it a standard practice where I...

Check with your legal department. There may be a legal channel to be able to force her to turn over the passwords or she'll be liable for the damage. People...

What version and service pack of SQL Server? Does this happen on other databases?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

It is important to remember that the application is vulnerable to SQL Injection, not the database. The root of the problem is input validation. Should all input be properly validated,...

As long as the second stored procedure is called from within the first one (the one creating the temp table) then a local temporary table (CREATE TABLE #<TableName>) will work....

If you are dealing with tables, when you are in the Create Table screen, there is a Properties button (Hand pointing to a list) on the toolbar besides the Save...

There has been no documented way of recovering DTS package passwords, no.

You might try and place a support call with Microsoft to see if there is something they can...

The user has registered the SQL Server with the proper credentials? This seems like a no-brainer, but it's always the first thing I check, having been burned before.

K. Brian Kelley,...

A few points. None of this is meant to be harsh, so I apologize if it may come across that way.

1) Utilizing the same user to login to SQL...

I agree with Frank. Post count is nice to show overall contributions. But the guy with a single post might have the answer everyone needs.

K. Brian...

Books Online. The provided documentation on SQL Server. You can get an updated copy at:

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

There have been a couple of threads recently where a set of values is passed in via a single parameter. The query then does a charindex() in order to "parse"...