Paraphrasing from a thread from July last year - hope this helps...

There are three versions of Vista that support the installation of SS2K5 including Reporting Services: Business, Enterprise, and Ultimate....

For a membership database, I was asked to automatically create a note with the "before" values when a member's record was changed. There were about 25 fields they wanted to...

A rule of thumb when writing your resume is to include only the last 10 years of work experience. I would expect that a degree that is more than 10...

My understanding is that using something like

if UPDATE ( yourcolumnname )

begin

-- do something for that column

end

will execute the "do something" if the existing value is over-written with the same...

OK, so we all learned something about SS 2005 using level 9.0 compatibility. But this QOD category was T-SQL, not SS 2005.

IMHO when only 1/4 of the members answer correctly,...

The answer "SQL Server 2005 RTM or later " is not correct because it does not state which edition of 2005 RTM is installed, or which edition is replacing it....

Biometrics are the most scary because they would be binary data. Biometric data would not be human-readable, so how could you know if it was the original, copied, or altered?...

sathyendrav,

You CAN install SS2000 Developer on Vista, there was a thread about that here:

http://www.sqlservercentral.com/Forums/Topic367417-5-1.aspx

You basically ignore the warnings and apply the latest service packs. The Vista Sync Center doesn't like...

I'd like to add that there could be legal implications to locking a customer out of the database - I understand the intention is to protect the code, but the...

The Major brings up a good point - DR is more than just doing a successful restore & verify to another server - you need to be able to restore...

None of the links in the editorial point directly to SSDS, but this one does:

http://www.microsoft.com/sql/dataservices/default.mspx

When you connect, for "server name" try using the actual machine name, not "(local)" does that help?

Roberta,

I'd like to add that the code samples using Northwind might be intended to illustrate how to do something, but not necessarily the best or most efficient way to do...

Jamie, can you try this:

select top 1 Name from People where Status = 0

order by PersonID

Quoting from technet

http://technet.microsoft.com/en-us/library/ms187373.aspx

"READUNCOMMITTED

Specifies that dirty reads are allowed. ...Allowing dirty reads can cause higher...

bitbucket,

Can you explain the difference between those two terms? I Google'd about, but all I found is the source that you cited.

In the case of "password mismatch" what action should...