Yes it is SSIS. SSIS does row by row processing so if you take 20 seconds to insert a 1000 records your date will vary. If you want...

The most common way I have seen recommended for this is to use dynamic SQL. Any other options depend on the behavior you want and the data you have....

I think you are misunderstanding the Target Server Memory and Total Server Memory counters. Target Server Memory represents that Max Server Memory setting for the instance and Total Server...

I'm not sure what is missing because in the update you list prokw3 should be set to ', test5Erwin'.

In all honesty, based on my limit understanding of what you...

Check out this BOL link: http://msdn.microsoft.com/en-us/library/ms143241(SQL.90).aspx

A role and a login are 2 different things. If you dropped user Jack from the database and Jack was a member of the role Jack, you did not...

ronaldo (8/13/2008)

---

I already put various lines in the textbox to print over 2 pages.

When this occurs the print is perfect!!!

Actually the problem is in the third textbox (CONTEUDO), that...

I'm tapped out. Never really worked with INFORMIX and when I had similar issues with DB2 using openquery and/or converting to another data type usually worked.

Jeffrey Williams (8/13/2008)

---

Jack Corbett (8/13/2008)

---

When everything is in the same schema ownership chaining rules apply, so if I have schema1.proc1 and access schema1.table1 then all my user/role needs is exec...

Are you working with SQL Server using MS Access? I don't know if you can use the GUI in Access to make the change but the T-SQL for it...

If you know the defined column length in advance you can do something like this:

Update table

Set column = column + 'text'

Where

...

Jeffrey Williams (8/13/2008)

---

Andy Warren (8/13/2008)

---

Jeffrey, the schema idea is interesting, it's just felt like it was worth doing to me, all too often users need to cross schemas to get...

Having seen the report I now actually understand your real question. I don't think that there is a way to have data in a single textbox span pages. ...

What control are you using on the report? You may need to "nest" controls in order to get the behavior you desire. For example, if you are using...

When you say blank I am going to assume you mean NULL as Concatenating to a NULL yields NULL. So if there is a possibility that one or both...