I think the only way to do this is via dynamic sql

It probably comes down to

'Can my system be implemented on the platform'.

The answer is almost certainly yes on both SQL Server and Oracle.

It will work better if it is...

Sorry - that site (amazing grapics!) is hosted by ntl and I've lost the ability to update it.

I'll add you when I move it somewhere else. Plan to host it...

This sp

http://www.nigelrivett.com

sp_nrLocks

Will give you a list of the locks held and spid info and can give the commands that the spid is executing.

You can maybe get the page...

>> A sp is compiled at creation, isn't it

Not any more - it is compiled at first run - and possibly at every run if it is dependent on transient...

You can use sp_executesql to run the d-sql - set a return parameter from @@rowcount and return that.

There is an example of using sp_executesql to return parameters from d-sql and...

You can just run

select 'dbcc dbreindex(' + name + ')' from sysobjects where xtype = 'U'

(or something like that).

The run the output

Alternatively it's not difficult to write a script to...

You can use the com object calls to use it.

If you want to use xp_sendmail you can stop the mail service and start it again with a different return address...

I suspect that it is more possible to design a database write code in sql server to utilise the available memory more efficiently (that might just be because I...

Have you looked in the bol?

A fill factor defines how much free space should be left in a page. The moer free space the more likely that new data can...

you could send a kill <spid> command from another connection. It will close the connection <spid> if at all possible.

select id, name = max(name)

from tbl

group by id

You have a mls_photo table which has the trigger on it and you want to insert into the mls table in the trigger?

If that's the case then

insert mls (...)

select ...

from...

I'd left one reference to inserted which is probably why it fails

CREATE TRIGGER photo_numbers

ON mls_photo

FOR INSERT , UPDATE

as

insert into mls(p_mod_date_time, photo)

Select Left(CONVERT( varchar , getdate() , 1),8),

case when m.medium_photo...

have you looked in the bol?

try

Datediff(mi, Logtime, Getdate())