When you run it as a package it works because it runs under your credentials and I'm guessing your login has access to execute/write.

When you run it from a...

I'll give that a go but what is confusing is in Connection manager I can enter in a Username/Password which is what i want, but the site doesnt prompt me...

Hey, the exact scenario to do this manually is like this

1. Go to...

Thanks guys, i've tried both and both get the same results as i expected. I thought i had use cross apply just wasn't too sure how to use it...

Bob Griffin (11/19/2012)

---

Specifically, the user that the sql database server is running as has to have permissions to read the backup file. If possible, browse to the bak file...

surma.sql (11/19/2012)

---

Hello

I had one task.

I need to restore on DATABASE on [Server A] from [Server B].

[Server A] is on VINEMAPPLE Domain and

[Server B] is on mpeboe domain.

so when I...

satishdbaid (11/19/2012)

---

Hi John,

Thanks for the reply..

Im not sure on how to use sysjobhistory data..

and

My request is job named "reorganize" which is in scheduled for daily at 8 Pm.

User...

I just learnt something new...

Eugene Elutin (11/19/2012)

---

You need to use free-text wildcard "*" in your search string!

SELECT *

FROM table_name

WHERE CONTAINS(*, '"*eran*"');

Also, read my previous post regarding hyphens and ampersands... It will make it...

eranzo111 (11/19/2012)

---

Hi Tava,

With those 2 queries, I get partial results.

Let say the the text I query by is "eran":

SELECT *

FROM table_name

WHERE FREETEXT(*, 'eran');

SELECT *

FROM table_name

WHERE CONTAINS(field_name, 'eran');

And the DB has...

eranzo111 (11/18/2012)

---

Hi,

I am quering a big table (about 150,000 rows) with a big varchar field (size 2000) which can't be indexed (and there's no point even if it could be)....

Tava (11/12/2012)

---

briancampbellmcad (11/12/2012)

---

Both the PO_Number and HeatTicketNumber are already Varchar as the table datatype... so (?) no need for conversion (?)...

I ran the code above and now have a SQL...

briancampbellmcad (11/12/2012)

---

Both the PO_Number and HeatTicketNumber are already Varchar as the table datatype... so (?) no need for conversion (?)...

I ran the code above and now have a SQL error...

No problem, hope it all worked

avdhut.k (11/7/2012)

---

Hi,

I have Excel File with following coloumn and sample data.

example,

No TranRefNo

1 1111

2 ...