dbadude78 (8/31/2012)

---

Hi

Thanks for the quick reply. As a test i executed the whole script on my local instance. But got a the following message "Msg 297, Level 16, State...

I don't understand how you arrive at your expected result from the data you've provided for 2011 months 1,2 and 3.

The below matches all the other outputs (I'm assuming your...

You need to have some extra quotes (two single quotes escape to a double quote) otherwise you're applying the modulo operator to your two strings (a percentage sign) rather than...

Ok, apologies, I thought you were talking about two VM's on a single machine.

With standard edition, you have limited options, which pretty much boil down to:

1) Set up transactional...

Well, with Standard Edition, Readable Secondary's are not available, which pretty much leaves you with replication.

However, are you suggesting that both will be on the same physical server, with the...

If your partitioning key is not referenced at all in queries, then, generally speaking, it will give no performance gains as it will have to scan each partition to find...

Tobar (8/22/2012)

---

HowardW (8/22/2012)

---

What's the ProtectionLevel property of the package set to? If it's "Don'tSaveSensitive" then the password cannot be stored by entering it into the connection manager, you must have...

What's the ProtectionLevel property of the package set to? If it's "Don'tSaveSensitive" then the password cannot be stored by entering it into the connection manager, you must have a configuration...

GSquared (8/7/2012)

---

CELKO (8/5/2012)

---

I would have to do some digging for exact rules, but this is a T-SQL dialect error. The conversion should fail with a message that the string cannot...

There must be something else in the error log or a previous error log that shows the error that caused it to become suspect. The messages you've posted aren't relevant...

Most likely to be corruption of some sort and you may ultimately need to restore from a backup. I'm no expert on the subject (you want to wait for Gail...

This sounds a really simplistic question, but based on what you've said, it should just be:

update xys set submitdate=NULL where id in ('1','2'.........'100')

I feel I must be missing something as...

I'm not sure if there's an absolute limit. I can see a few suggestions that there may have been in SQL 2000, but nothing concrete.

I would strongly reconsider this design...

You should only make an index unique if the data is unique and guaranteed...

I'd probably go with a Nexus 7 right now, if budget's a consideration.

I'm still quite excited about Win8/Microsoft Surface (the Windows RT version) and may well hang on to see...