you can create one simple audit table for columns you required and insert deleted records into that ....either you write trigger or you can do that by using output deleted.*...

yes , except is good option.

we are facing same error as below....

not able to kill that process .................

Msg 3023, Level 16, State 2, Line 1

Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and...

can you run sp_configure

and tell us what values right now showing for Ad Hoc Distributed Queries

in minimum,maximum,config_value,run_value

hi,

if you have already configure then try this way to read data from excel

SELECT *

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\users\USER\desktop\book.xlsx;IMEX=1',

'SELECT * FROM [Sheet1$]')

check your path where file located once.

with recompile i think you can go ahead in case your procedure is the way like it going to create new execution plan most of time

sorry but not getting what exact problem you are facing

from ssis import this three different file into three tables then from join those table you can get your desired result.

let us know if you want more help .

Hey, i think you can simplify this by adding default constraint where value is null or the other way.

but yeah for your problem i have two quick solutions hope this...

Truncation may occur due to inserting data from data flow column "Column 2" with a length of 50 to database column "Acctno" with a length of 15.

-- increase the...

Hey you can send your report through mail using data driven subscription and also you can schedule it.

is that fine if i will change filesize of datafile or logfile on weekly base means any problem that can cause performance or fragmentation issue.

my main question is that if i will increase initial file size as per needed is this right practice ...?

for example my current file size 20gb it increase around 2...

RBarryYoung

hi, i want to know that if i am using that broker service then should i need to use master key encryption,

because yesterday in our production server i found that...

hi,

i can understand what you feel when is there any change into one table you need to do changes into lot of sp for one column .......

i have one suggestion...