I see; sort of like a self contained mini Query Analyzer/SSMS interface; I understand that, but why save the entry to be executed then?

i had done something along those...

well first let me throw out the standard security caveat: executing unverified, unsecure TSQL code that comes from an external source is a bad thing.

I'd love to hear the...

more details are needed i think; i think you are misusing the trigger functionality.

it sounds like you are reprocessing every record in the 10 million row table if someone fires...

like GSquared said, it's possible, and substantially slower too.

here is a simple example, which just runs sp_who; change your server name and this should work:

SELECT *

...

yes you can use a CTE and recursive CTE's in a function;

a lot of the Tally Table examples you'll find here do exactly that to build a Tally table dynamically,...

ok...how about the hyphen in the server name? wrap it in brackets?

-TECH-01 to -[TECH-01]

it's probably permissions then...the service account does not have access to the C:\ drive.

if you change it to just the file name , without the C:\, the file would get...

i think the basic version of SQLExpress does not come with a GUI, so you end up having to use a different program like LinqPad or something to use for...

all my snippets I'm looking at do not have a space after any of the flags, for exampe -S TECH-01

should be -STECH-01

SET @sql = 'bcp "' + @sql +...

those all look like objects owned by INFORMATION_SCHEMA

since your cursor is hardcoded to sys.objectname, it is trying to revoke sys.COLUMNS , which does not exist, instead of INFORMATION_SCHEMA.COLUMNS , which...

the list of tables is usually child tables that reference the original table via a foreign key;

if the table is going to be dropped and rebuilt completely, rather than a...

falcon59x (1/12/2010)

---

Hey guys,

Thanks for the response they are really helping. When I incorporated searching for the schema instead of just using sys. I was actually able to knock 26 down...

i found out that in SQL 2005 and above, some of the data management views have the client ip address, and you can narrow it down to the specific SPIDs:

this...

another idea is to add a column of type rowversion and use that as a semaphore for whether the person should update;

so for example:

data example:

create table myTest(testid int identity(1,1)...

It depends on your approach. you can move the code that was being executed in the stored procedure directly into the trigger; that way you can insert from the INSERTED...