As being only 4 digits, any pin code is rather unsecure. If you want to eliminate "unsecure" pin codes, you'll eliminate quite a few pin codes, and thus making the...

Can you please elaborate. Always remember to include DDL, sample data and expected result in your posts, so that others can clearly understand your issue.

Having looked somewhat more closely on your case, it appears that your issue is a design flaw, where you expect the AC_ID of an "entry" always to be less than...

You have two pieces of code similar to this one:

SELECT MIN(AC_ID) FROM Demo WHERE parentID= @Root

Replace this with

select top 1 AC_ID FROM Demo where parentId=@Root order by [Type],[Name], and...

Can you please post appropriate DDL and code?

Don't install the two on the same computer/server. This is a very well known issue when two products sharing code base are developed. The two products are expected to work...

Can you please elaborate? Do you mean cluster failover or failover of a specific database with database mirroring? Do you want the package to initiate failover, to be run once...

You pretty much summarize everything yourself. Yes, you can use linked servers between the two sites. You will want to have a VPN connection between the two sites, and open...

With a minimum of 4 cores per processor. So, if you have a dualcore CPU, you'll still pay for a quad core.

You ask Dev to violate copyright restrictions? Pretty rude if you ask me...

If you want to want to have a sneak peak of books on the subject, I would recommend...

Dev (11/21/2011)

---

I don’t doubt on quality of the test. I say it a formality (making certifications available to public) because exam fees are too much. If MS really...

The problem here is actually "an old friend". You can rely on implicit cast if you know how it works. If not, you should always use explicit cast. Actually, I...

For those interrested in MCM, I can clearly recommend the MCM Videos. Lots of useful stuff, actually even if you're never going to certify as MCM.

Error code 2 means "File Not Found", and there is a myriad of reasons for files not existing where they should.

Edit: By the way, when you looked for a solution,...

This may not be an error, as Max Server memory affects the buffer pool only, not objects stored outside of the buffer pool. Worker Memory, Linked Servers, Multi-Page allocations, large...