if it's in an nvarchar column then soembody forgot to put the N' identifier in the insert statement and you have non-ascii characters stored in your string in unusable format

We run a system that is a hybrid.

local hardware for our internal needs, cloud hosted servers for computational grunt and cloud services (such as ddb, EMR and SQS) for all...

i really don't think, we should continue this - the original poster seems to be just taking the mick. - and our responses are proboably becoming inappropriate - also i...

nsi (5/21/2012)

---

Hi,

we have a table that has 714k rows. The table takes up 850Gb, where each rows actual data is no more than 2-4k. It has a few int, nvarchar...

hey - what's wrong with askjeeves.com

there are 2 ways

right click on the database and choose properties and then in one of the screens there will be a recovery mode box (i don't have sql...

from the sp_helpdb it looks as if they are all ONLINE

yep - you need to drop and add the subscription for that table only. - although the article has the same name i think it gets a different internal identifier

I think the use of the word profile in the error might be relating to some jet 4 components.

if you only need to import this data once then you could...

looking at that you definatly have a couple of DB that are in simple (WRHL for one) and that will cause that statement to potentially fail..

i think you should really...

pjl0808 (5/21/2012)

---

Hi all,

I need to remove an older table (article) from a publication and add a new table back in using 'exec sp_addarticle'.

The new table is Very large and is...

shani19831 (5/21/2012)

---

Hi guys

I'm having trouble on finding out what causing this error on one of out sql servers.

Date: 5/21/2012 Source: MSSQLSERVER

Time: 3:00:00 AM Category (6)

Type: Error Event ID 17055

User: NT...

i'd be tempted to build a small loop (pseudo code below)

while records affected>0

begin

merge oldest record for each widget

remove oldest records from staging for each widget

end

in that...

Schadenfreude-Mei (5/21/2012)

---

k.subramanyam1017 (5/21/2012)

---

Hi friend,

Thanks for u r experience given answers but one thing what is the third question answer that is -3!(like year gap)pls...

jparenzee (5/21/2012)

---

Hi ,

Im a newbie to the world of report building and BIDS in particular.

I need assistance - I need to illustrate a breakdown in charging time of a battery...