this error means the FK already exists:

Unable to create relationship 'FK_AVALIACOES_FOGOS'.

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_AVALIACOES_FOGOS". The conflict occurred in database "SGIPU3", table "dbo.FOGOS", column...

a foreign key has to reference either a primary key or unique constraint in a single table

so if the predios.ID_predios is one of those, you could have a FK to...

Nice usage of a pivot there Gianluca, I really need to get PIVOT into my scripting usage a bit more.

I built something similar without the pivot, yours makes it very...

for most encryption types, youll end up changing the datatype of your column to varbinary to store the newly encrypted value. google "sql 2008 encryption for examples, as it's a...

roles and users are stored inside the database, just like any other table or view object, so yes, roles/users will exist on your standby server.

the LOGINS are stored in the...

they are very nearly the same, i believe; after all, the amount of space needed store any given data type(int/number, varchar/varchar2 is the same in both systems, so you are...

there is a way, but it exposes a users passwords in code; that makes it extra creepy with a domain password

it's possible to map a network drive with a domain...

i've played with a database trigger that adds permissions to a role when a DDL event like creating a table occurs;

this would also do what you are asking:

CREATE TRIGGER...

note: thread is from 2007; three and a half years since last post.

also exec sp_help [tablename] provides a lot of nice information, when you need one specific table's info.

you are seeing multiple roles on a single user, and thinking only one of the roles is in place i think.

i just tested this script, and my user does not...

i think you also need to test if the date is less than a minimum acceptable value ..in your case what's the minimum acceptable date you are looking at?

...

I'm thinking when he does a load of data, the statistics go out of date, and "it grinds to a halt"? updating statistics right after the large load seems to...

our shop has a relationship with a local schools database programming class, and they intern every once and a while in house for a couple of days; sounds like something...

Howard as an FYI for your testing, when i ran your code on SQL2005 SP2, it consistently did an index seek, but on either of my SQL2008 machines, it opted...