Invest

Take a look at GRANT

GRANT SELECT ON .... TO ....

GRANT INSERT UPDATE DELETE ON .... TO ....

Also take a look at ROLES in case you need to do this to...

School

Anyone in the UK after a "SQL Trainer" contract role? Travel across Europe all expenses paid?

I would have jumped on this like a sky rocket, but I have...

Take a look at sys.dm_os_performance_counters

Try it out see what happens. Restore a DB with NORECOVERY to leave it in a restoring state, then run your maintenance plan.

Site is slow for me today, taking a good 30 seconds to a minute to switch between topics and posting.

Just took 60 seconds to get to forum 433-1 and then...

You will need to hack the script to remove the servername from the backup path.

Tractor

If I understand right, you don't need a loop for this if the other values are static.

declare @month date ='2015-10-01'

create table #destination (code char(3), mon date, value int, measure char(6))

create...

Cow

Add a second join a second copy of sys.columns and join back on the referenced column data instead.

select distinct

A.name as tab_name ,

B.name as col_name,

C.name as col_type...

Please see your other post, I posted an updated query

http://www.sqlservercentral.com/Forums/Topic1729985-2799-1.aspx

Biker

For the FK details, left join to sys.foreign_key_columns on the parent values to the sys.columns values

select distinct

A.name as tab_name ,

B.name as col_name,

C.name as col_type ,

case when...