no error handling in the code   It's just a bunch of truncate and inserts over and over again to build out 40-50 tables daily

sorry for being so ambiguous. I've got a job that’s calling a proc that has a simple insert that is trying to load a dup record relative to the...

sorry, let me be more specific. I'm expecting the proc to error out due to the primary key violation on insert as it is doing in all of our other...

the db was pulled from 2008rs instance. the db is still in compatability level 100

wow. confirmed. if an nt user does not exist is sql at the server levelhowever exists at the database level yet that...

disregard. i'll test it out and let u know

I think u misunderstood. wasn't trying to be tricky just wanted to confirm what I think is the obvious.

If the nt user is orphaned and only exist at database...

so question. I have an nt user who has read and write access to a database but that nt user has been removed from the server logins. The user also is...

thank you. That reference worked perfectly for my needs

what If I have an 2012 instance on SP1 and I need to get it to SP3. Do I need to install SP2 then SP3 or just SP3? I'm assuming just...

the largest table has 15180 records

I must be doing something wrong because the db whose log filewas 30 gigs had an mdf the was 1 gig. I just don't get why...

so combining the two will give u this and it worked for me. Run the below in the source database
--step 1 -------------------------------------------------------------------------------
--RUN THIS ON SOURCE DB
--COPY OUTPUT...

disregard. i found it. I'll reply w/ what i end up with to close the loop

closing the loop here. i ended up doing the following

-- Use the Master database
USE master
GO

-- Declare local variables
DECLARE @serverproperty_servername varchar(100), 
@servername varchar(100)