Have a look at UPDATETEXT in Books Online.

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

Are you sure that the account used to connect has the permissions to execute the SP?

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

I don't know of any solution other than the proposed one, however I would like to say that an empty attribute should have the same effect on the client as...

Remember that blocking 1434 from outside the network will not stop intrusions or the worms from inside the network. Of course you may have meant access to port 1434 from...

I never discuss issues like Oracle vs SQL Server, MS vs Linux etc in a detailed way, since there will always be details about each side that seem better or...

quote:

---

I can specify a column name or a number refering to a column and this works fine. If I used

ORDER BY...

I guess you could create an UDF that takes the key as a single parameter. Then in this UDF do a select to concatenate a return variable. However, this udf...

Relations (including tables) are never ordered. You can never expect a specific order unless you manually sort the resultset. However, if you have a clustered index on a table then...

ORDER BY can sort by any expression, it doesn't need to use actual columns from the table. In this case the expression is just simply the method newid(). However, since...

Instead of actually creating two recordsets just create a single one with a singe SQL query. Example:

SELECT a, b FROM foo

UNION

SELECT c, d FROM bar

Columns in resultsets must be of...

DECLARE @Foo varchar(4000)

SET @Foo = ''

SELECT @Foo = @Foo + CONVERT(varchar(10), mycol) + ',' FROM mytable

PRINT @Foo

--

Chris Hedgate @ Apptus...

grasch, here is one solution (direct from memory so no guarantees). However, it assumes that you can do this in a two-step proocess and that the batchid is unique for...

Clustering SQL Server will not give you loadbalancing, only fail-over. With Distributed Partitioned Views (DPV) you don't have to modify application code as this is completely transparent to the application....

quote:

---

Proper index choices always are considered more of a performance impact than a design issue.

---

Ah,...

quote:

---

Hey Chris, relaized I had lost you thread along the way. I check around and had come across this http://support.microsoft.com/default.aspx?scid=kb;en-us;322002

However...