Yes.

You must find the reason why Native Client had failed. Based upon the discovered reason, you must take an action before attempting another install. The action you must take depends...

There are some things you need to know about the fundamentals of relational database design, before you go much further. Otherwise you risk creating databases that contain logical inconsistencies, or...

Mirroring protects the server and...

If a batch of statements is acceptable, you can also wrap a CREATE PROCEDURE statement around my last example, defining 4 OUTPUT parameters. See example C at http://msdn.microsoft.com/en-us/library/ms187926.aspx....

"The specified network password is not correct" is being raised by WMI. The fact that SSCM causes WMI to raise an error, while services.msc fails to raise a WMI error,...

This:

is the key to your first door. However, if the summary and detail are not from the very first failure, you may be...

Go with the Force, Luke. A job really should have one owner, usually should be run on a schedule, and I believe they were designed overwhelmingly for the DBA to...

What I need is for the above code to give me 4 separate variables ie. previous_month, ptotal, this_month, ttotal. The reason for this is a need to get away...

create database test

go

use test

create login test with password = 'test'

create user test

alter role db_owner add member test

setuser 'test'

alter database test set read_only

/*

setuser

use master

drop database test

drop login test

*/

Command(s) completed successfully.

The purpose of a client's timeout setting is to avoid consuming the server's resources for an indefinite period of time. When the client has waited up to its timeout setting,...

In addition to backing up user databases, transactionally replicating user databases (my least favorite DR approach), and backing up system databases, I also periodically script out server configuration, database schema,...

The size of tempdb depends upon uses of it. As a simple example, if a system submits T-SQL that references a temporary table, then one copy of that temporary table...

The issue fixed by http://support.microsoft.com/kb/2720171/en-us (which does not require the latest CU) has a specific cause: "This issue occurs because of the way Integration Services executes packages stored...

Exactly, hence:

Actually, you can (sort of) backup an index. "All" you need to do is define the (nonclustered) index upon its own file within its own filegroup, and then (when needed)...