Absolutely, good point about sp_rename. What could have been inlcuded (even though it might break stuff, just as sp_rename) is a system proc for sysadmin use only that changes UDTs....

Ah, phew. I was getting a bit confounded there for a while.

--

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

http://www.sql.nu

Ah, of course, yes you're right. I'll be quiet now so that kreskins can sjow us the statistics.

--

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

Actually I think it is good that there is no way to do this, other than those suggested by Tim. The reason why you use an UDT in the first...

quote:

---

I use MS SQL and I use Unix OSes. The Unix OSes don't have anywhere near the number of security issues and...

Using AWE on a server with 3 GB memory is not possible, it won't do anything. Of course, I may be wrong in understanding the following as in the server...

Yes, they could very well help, but it would still not solve the problem of searching for a string inside a lagrger string. The problem is not running a function...

Sorry, but I think you're left to brute force.

--

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

http://www.sql.nu

Try this:

CREATE view vw_test

AS

SELECT year, account#, units

FROM table_name

WHERE year = (SELECT MAX(year) FROM table_name)

--

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

http://www.sql.nu

Setting up true column level security, or possibly using views, is still the only way if you really need to deny unauthorised users of the actual database, not some app...

Do you run this procedure for every updated row? In a cursor or how do you exeute it per row? The trigger should definately be able to keep up, there...

Must say I don't have much experience of DB2, but one thing I do know and like about it is that it is probably the closest to standards conformance of...

Out on a limb here, but I think you could create a VB app that 'talks' DDE and then inserts the data into a table in SQL Server. Or just...

Same as Steve, no specific ideas, but my guess would probably be faulty memory. I'm guessing you now have three 1 GB RAMs in the machine. Have you tried running...

quote:

---

How can I pass temporary table to stored procedure because I know that there are multiple rows at functional level?

---