for this query, i think we'd need to see the actual execution plan on this, as well as a list of all indexes on the fctAssetFulfillment and the FulfillmentPartnerInstall...

Luis pointed it out i think; the assignment must be a static value or constant;

a convert cannot be used, even if it was a static date, nore getdate,

and when you...

it's not possible for a foreign key to reference a different database.

foreign keys can only be created within the same database as the two tables exist in.

it's possible to...

well, if there is a view or stored procedure that references a different database or a linked server, you can query for that.

take a look at the view sys.sql_expression_dependencies,...

Thanks for looking Phil!

pretty sure the office is using vs2008 for ssis and ssrs, so that's probably 2008; i couldn't seem to find a 2008 SSIS forum.

Ironically, i had done...

here's a testable solution you can adapt to your real data;

this gets each table, and a comma delimited list of column names.

use this as a model, and change it to...

i'd like to see where you got a statistic or article stating UNION was a vector for hackers; might be interesting reading.

I'm more under the impression that SQL injection is...

I believe there was another recent thread that said scheduled jobs that are executing use "Microsoft SQL Server Management Studio", i believe, which was very misleading, since it's not really...

as far as i know, every login has access to master and tempdb; but they can hardly see anything that has not been granted permissions to them in those databases;...

if this is for a class or homework, we can point you in the right direction;

from experience, your structure is wrong;

individual products or items on the invoice need to have...

well, if a given id exists more than once in your tbl_directdebits, it will insert multiple rows.

...from tbl_directdebits where id= @id

does this query return any rows?

SELECT id, count(id)

FROM tbl_directdebits...

i don't userstand the logic of dropping it and adding it...why not delete, reseed any identities, and insert into again?

your error is due to the fact that

a stored proc...

agreed; what...

yeah, i didn't see a value in it either;

the grant for GRANT VIEW ANY DEFINITION TO AppInsightUser

lets the login see the metadata without having to be a user int he...

You can't.

fragmentation occurs, for example, when data is...