i wouldn't give them the db-owner role, but instead create a role something like the following:

remember the role of db_owner has the ability to drop the database, which you probably...

the why is easy...by design, when you use the GUI to change a table, it drops the table and recreates it. Not always, but since it is so easy to...

that would occur if any space existed in the last name, before the slash.

a name like Mac Bride/Bob Lee would make that happen... you'll need to tweak it based...

it takes a bit of manipulating, but you need to use substrings and charindex to find the slash, and grab the left and right parts of it; you have to...

the Export Wizard gives you the option of copying tables or using a query in like the sixth step: much easier using the wizard than SSIS.

you have to select your...

remember a foreign key can be created only on a column with a primary key or unique constriant; on it, an integer column that happens to have an FK doesn't...

i'm just guessing at your interface, but do you have some UI that has a link per SQL statement and they click one link to get the results, vs...

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...