Having tables and indexes in different filegroups doesn't help you a whole lot unless they are on different physical drive sets. Is this the case?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Mixed mode is required. The operator created for MultiServer Administration (MSXOperator) is a SQL Server login and thus the change.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

You can reseed using the DBCC CHECKIDENT command. For instance:

DBCC CHECKIDENT('Employee', RESEED, 2)

Off the top of my head I don't know of a way of...

I'm not quite sure why it stopped working due to multiple processors, it could possibly be because it's trying to create a plan involving parallelism and it's not able to....

A few questions, just to try and understand the environment.

The colocation server, is it located in your main office?

Is it in the same domain?

Can you ping...

Please do not crosspost. Most readers look at all forums. I have locked this thread for the General forum. The thread in TSQL has been left unlocked...

SQL Server is going to try and dynamically grab enough memory to load databases in memory. It'll also need to reserve some memory for execution plans and user connection...

I've seen this problem on the SQL Server 2000 tools from time to time as well. In that case applying the latest service pack usually fixes the problem because...

Add the username or group along with the Domain. For instance:

MyDomain\AUser

MyDomain\AGroup

In Enterprise Manager,it'll look like:

If you want to use SQL, such as through Query Analyzer, use sp_grantlogin,...

DBCC has several options. The one that checks a database, DBCC CHECKDB, has options to perform various levels of repair. Books Online has a description of what each...

We do something similar for log files we have in a production system. Basically, we have a linked server created where we first move the relevant rows, then we...

There isn't a ton of information available for WAITSTATS, and as Antares has indicated, much of the information is available in other places.

One thing you mention is it...

If you run it when activity is going on, compare between two instances. That will give you some indication how the numbers are changing as the system is active....

The SELECT query using the lock hint WITH (NOLOCK) will not issue a shared (S) lock. A shared lock is typically used if no lock hint is specified, unless...

I think it's a typo. Under the topic "SQL Server and Mail Integration" in SQL Server 7.0's Books Online there is xp_send_mail but it's used right after the correct...