Viewing 15 posts - 1 through 15 (of 110 total)
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.*...
June 9, 2015 at 5:28 am
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...
July 23, 2013 at 3:11 am
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
May 15, 2012 at 6:31 am
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.
May 15, 2012 at 6:12 am
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
April 11, 2012 at 3:36 am
sorry but not getting what exact problem you are facing
March 30, 2012 at 1:14 am
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 .
March 30, 2012 at 1:07 am
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...
March 30, 2012 at 1:00 am
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...
March 24, 2012 at 12:46 pm
Hey you can send your report through mail using data driven subscription and also you can schedule it.
March 24, 2012 at 12:38 pm
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.
November 11, 2010 at 6:58 am
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...
November 11, 2010 at 1:55 am
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...
April 21, 2010 at 4:35 am
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...
November 29, 2009 at 11:21 pm
Viewing 15 posts - 1 through 15 (of 110 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy