adding the column to every table, or the parameter to every procedure could be scripted from the meta data,but...

the procedures are the problem; every procedure has to be hand...

spin, yes, it's sounding like you need the specific drives;

as you were setting up , you saw there is a selection of some possible drivers, but when you connect to...

you want to use the OUTPUT Clause; it's especially helpful when you insert more than one row.

from what I've read recently, even SCOPE_IDENTITY() function can fail to return correct values...

then you'll have to slow down, take a deep breath, and start identifying the objects/data they need to capture. call another meeting for exactly that: ask those who know the...

If you are not going to install SSMS for them, then something like LinqPad might work. It supports multiple languages, including TSQL, and it is a Decent SSMS replacement: it's...

this link shows another forums building a linked server to that type of db; it's got a description for both SQL Server gui settings and then a scripted linked...

can you exec sp_help fogos ?; isn't that FK already there? i think that;s what that error means.

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