next time i'll read the whole article !

<snip>

If you cannot give users direct access to the tables, you cannot use dynamic SQL, it is...

okay - still a bit confused though

working on the assumption that i am sa.

if i write a stored procedure to run under user...

I'd start learning a .Net language, something like C#.

UDTs can be created in any .Net language and 'registered' within Yukon, allowing functions to be exposed and avaialable in SQL.

BUT Transact...

cool. thanks

roll on Yukon eh

just done the perfmon thing described in another thread and the max server memory is reported as 15.8 gig ...

we are,however, getting a few reports saying the server is slower...

okay,

i did the following

1. created a user to run sql server under and chnaged the start up service name. sql server is now running under the new account.

2. edited the...

This is pretty wierd as I started working on exactly the same kind of project today, and my comapny is also too poor to afford the PAF files ...

I have...

quote:

---

In reference to the above, deletes have supported joins since Sybase 4.9x, prior to Microsoft ever getting involved, and it was certainly...

Surely it would make more sense to add RI to do this. If the database supports it but it wasn't added when it was designed then that would be a...

quote:

---

hanslindgren:

It is good i agree. I can give you the link for the company i use, i don't know if they...

quote:

---

Well in the UK there are two ways of doing it. Either you set up a limited company, and pay accountants...

quote:

---

Actually your brain, how much experience you have and how much time you spend learning your craft are most important. Degrees...