what database are you STARTing in?

select * from dbo.MyTable would fail if you start in master. there's no MyTable in master, regardless of your permissions in MyDatabase

a three part query...

don't know if this helps, but i use a powershell script as a SQL Agent job step, which in turn calls robocopy to copy all my redgate *.sqb files

that job...

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