with NO downtime isn't possible...you can minimize it to under a minute per database, assuming the databases are not huge terabyte sized db's. two ways i can think of, maybe...

I'll ask a different way:

when i create a stored procedure, i only want it to get data from the database it exists in.

It is incredibly rare that i create a...

an index seek is better...an index is stored in order. so if a query tries to look for say, PROD_ID=7, it knows to use the index to SEEK the PROD_ID...

I've got two ideas to look at:

one is related to cross database chaining:

one command points to one database, and the other points to a different one ...which is correct?

set @muusid...

the built in administrators group has rights to everything, so logically you shouldn't add or subtract rights to a built in group.

you usually do this two ways, add a role,...

you shouldn't use varchar fields to carry/pass datetime fields.

your procedure should accept datetime fields instead:

ALTER procedure P_REALTYTAX (@DATE1 datetime, @DATE2 datetime)

as

...

to test whether this would work, simply try sticking...

yeah, there's a stored procedure for it:

exec sp_rename 'tablename.columnname','newname','COLUMN'

it seems that what you are describing is literally the definition of a foreign key.

1.a child table can have the ParentId as a column, and a foreign key constraint in...

your sources are right, it is a set based operation...only one execution for the all affected rows.

this is the advantage of Set Based Operations

if you update a table so...

you want to drop only the tables that are related to your connection; your IF EXISTS statement checks accross all connections, so you could pick up a temp table from...

yeah, in order to have a changedDt column with the last Updated/changed, you'd need to add a trigger to the table. with the trigger, you'd be able to update the...

the timestamp datatype lets you know the last affected automatically, but it's not a datetime field;

here's an example:

create table #sample(somevalue varchar(30),CreatedDt datetime default getdate(),ChangedDt timestamp)

insert into #sample(somevalue) values('value 1')

insert into...

i use this cursor below on our dev machine at work;

it runs as a job twice a day, which is often enough to switch any new or newly restored databases...

it's kinda straightforward i think; a case statement can return only one datatype.

when the case is constructed, i think it is assuming the first item int he case statement will...

AFTER YOU PRINT YOUR VARIABLE, I THINK YOU'LL SEE HTE MISSING OPEN PARENTHESIS FOR OBJECT_ID FUNCTION:

parent_object_id = OBJECT_ID(' + @table + ')'