with a check constraint.

you can use a like statement to make it only alpha([A-Z], or allow alpha numeric[A-Z,0-9]

CREATE TABLE Example(

ExampleID int identity(1,1) not null Primary key,

SomeText varchar(30),

ConstrainedItem varchar(13) CHECK...

since CREATE PROC/VIEW/FUNCTION/TRIGGER has to be the first statemtn in the batch, you have to go with dynamic SQL

IF @@SERVERNAME = 'xyz'

BEGIN

EXEC('CREATE...

for code within SQL server,it's actually pretty easy.

there's a view that contains all references, but you have to run this command in every database:

select *

from sys.sql_expression_dependencies sed

where sed.referenced_server_name...

the issue identified is only for Express verisons of SQL: not Standard/Enterprise/Developer.

For Express,

there are several different downloads available for SQL 2014 Express;

it's true that one specific download does not contain...

an issue with denying a column explicitly, is the end user cannot do a select * from a table (nor an application) using that person's credentials.

it can make data access...

nope.

if you give the data away, you give up control of the data.

if you give someone a backup of the data, it's a copy. once they restore it, they can...

first, select * from sys.traces will show you all currently running traces.

you'd typically see one trace, the default trace.

If you see a trace with a NULL path, it's being performed...

excellent!

glad that worked for you!

ahh, the pain of linked servers.

remember, when you deal with linked servers, in this situation, here's what happens:

the entire ate MYSQL_STAGE...wp_users table is copied into tempdb.

the update is calculated...

windows is pretty much ORDER By Filename

whether from powershell, command window, or within a programming language and iterating through files,

the data comes over as ordered by filename, unless you...

thos locations are stored in the registry, and not in any table, or as a property of a server, as far as i know.

...how are you getting them via powershell?

i...

could it be related to implied/deferred schema? SQL lets you be lazy with not explicitly identifying columns, but it gets a bit tighter when you work with other linked server...

also, your trigger is poorly designed; it is not designed take into consideration multiple rows in a single update; it should be referencing the virtual INSERTED table, and not declared...

well it depends on how users connect.

if everyone comes in from an application, and the application uses the same account for all users to connect, you have to get the...

are you using any monitoring software? spotlight, etc?

there's a good chance that some monitoring software is creating a trace to gather stats every five minutes and then killing it's own...