it would return strings that start with the highest ascii value;

i would expect it to return a string that starts with the letter "z" if it existed, and if there...

newbieuser (1/18/2012)

---

Thanks a lot.

Another question, when the users run a select on the Oracle table via linked server from SQL db, will there a lock created in the sql...

did you migrate your data into the [sysdb] instead of a different database?

five_ten_fiftyfold (1/19/2012)

---

We have a system that has been ported from Oracle using SSMA. I can find very limited info about permissions for the SYSDB database. I've noticed that there is...

when you have a result set where the order matters, you must have an ORDER BY clause; in your example, you'd need an additional column that you want to order...

for the scripting of jobs and linked servers, look in the script section here; there's several that do a great job there;i haven't done it in a while, so i...

all Reporting services is is a front end for generating html from your data; there's no built in ScrollableArea object, so you'll have to expand your boundaries a little bit...

mymistake, it's the TABLOCK option that prevents parallellism for BULK INSERT:

BULK INSERT BULKACT FROM 'c:\Export_o.txt'

WITH (

...

i think you also want to set MAXDOP =1 during the bulk insert as well as inserting into the identity table as sturner suggested.

this is really an html question, more than a report server question, i think.

you can do it with a div, by putting the table/list in the div;

it would end up...

yes, but it takes a little bit of configuration on your part: you need at least TWO Oracle users in the Oracle database to accomplish this; one for when YOU...

DBA_SQL (1/18/2012)

---

I actually need to update an existing column with incremental numbers..as shown... Can you help me to...

another option is to have each table hav a foreign key to the designation instead;

much easier and makes sense to me:

the "designation" table would just be a lookup table.

CREATE TABLE...

i would just add two separate foreign key columns, one to each table, and a constraint to prevent both foreign keys from existing for a given record;

then if a...

it depends; you have to look at oracle and see the size that is assigned; you can't just read NUMBER, when you describe the table you need the size also:,...