problem solved.

the project has about 6 different stored procedures that run at different intervals. i had changed 5 of them from varchar(8000) to varchar(max) but i'd forgotton to change the...

if you select from a subquery. i think its the same thing anyway.

select

x.col1,

x.col2

from

(select col1,col2 from table1)x

there's no real need to have more than one column if its an "IN ()"...

i've done a count of how many characters its allowing in this column and it stops at 4000

thanks for your replys.

i've tried kruti's suggestion and just ran

'select..... and then the xml file in quotes and it doesn't work either.

this leads me to believe taht the problem is...

the print statement actuall prints nothign at all 🙂

the function is grabbing everything between the "code" tags.

but i'm thinking that if doesn't exist in the XML within the variable...

Otoniel Cantu (4/22/2009)

---

so if we are talking about servers and software attributes would it be a good idea to have a 3rd table that has all the attributes that are...

i suppose its up to your discretion.

personally, if there are columns that aren't being used by hardware but are by software and vice versa then i'd put them in different...

so you have 'hardware' data and 'software' data?

lets say that they have 5 rows that can apply to both hardware and data.

hardware has another 5 rows that software doesn't

and software...

ha, i blame everything on too much coffee. not lack of 😛

can you go to tools/options/results and set the maximum characters per column to a higher amount?

OK. I think i've unecessarily doubled up in my SP. i've got an output parameter and i'm also using a return statement :hehe:

create procedure dbo.sp1 (param1 int,param2 int, paramOutput =...

to be honest my manager isn't a big fan of triggers so we dont tend to use them as a matter of course.

for example, if we want a row to...

just read up on the scope_identiy on msdn. i suppose because i dont have any triggers in my stored procedure i'll be OK?

i dont want to do a blanked...

thanks for the reply. i'm now half way through the process of testing what i've done.

i've created a stored procedure on the 2000 server to insert to the table...

Carolyn Richardson (4/20/2009)

---

It's 3pm on a Friday, your production OLTP environment is down, every hour down costs the company one million dollars. People are phoning constantly, folks are rushing the...