Recent content by ousoonerjoe

Will this not work? Bear with the sample. It's snip-its from our Reporting Class that is also a wrapper for displaying reports. Private ParamLisings As Generic.List(Of Microsoft.Reporting.WinForms.ReportParameter) = Nothing If ParamLisings Is Nothing Then ParamLisings = New...

Are you trying to use Server Side reports or is the report local to the app? -------------------------------------------------- “Crash programs fail because they are based on the theory that, with nine women pregnant, you can get a baby a month.” --Wernher von Braun...

Thanks, George. I suspected a column level shift was pretty basic, but yeah, the searches returned some pretty drastic answers that I thought were rather over the top. I appreciate the answer. -------------------------------------------------- “Crash programs fail because they are based on...

Simple question... I think. I have a table that all the VARCHAR fields got converted to "SQL_EBCDIC037_CP1_CS_AS" whereas the rest of the system is using "SQL_Latin1_General_CP1_CI_AS" which is the system default. Don't ask how it happened, this is an inherited system. Five years later, we're...

Many years ago, I worked for a Doc Imaging Company. What we did was store the image (usually a TIFF) on the server and it's relative path in the database. Then when the user clicked <Next Item>, we would pull the file path and pass it over to the image control. Granted, this was back in the VB6...

Like your boss or not, I would advise against burning your bridges. It has a way of coming back on you down the road. Micro-mangers are the worst, and it would seem that the higher-ups are at least aware there is an issue. You're out of the frying pan, and just leave it at that. Hopefully your...

UPDATE: It appears that it is an issue with the Indexes. 1 PK on an Identity Seed, 1 on a Date field, and 2 on VARCHAR fields with a 90% Fill Factor. It would seem as the indexes were splitting and re-ordering on INSERTS, the heavy traffic of that table couldn't keep up. Once we dropped the two...

About 15 years ago I worked as a hardware tech and warranty repair counter. I taught myself basic networking, and started dabbling in programming. I found I had a knack and real love for programming and went to a 2 year school and got my Assoc. in it. After applying to over 400 different...

I think this is the correct forum. If not, please let me know, and I'll repost appropriately. We are currently using VB.Net 2010. The discussion came up about upgrading to either VS 2012 or VS 2013. We have talked about integrating Windows phone capabilities for the sales guys (Contact...

Thanks for the reply. We can systematically recreate deadlocks and timeouts with Updates, etc. The problem we're having is that everything we know about the Deadlock rules states that they should not be in effect here. Procedure1 INSERT 1 record into TableA. Procedure2 INSERT 1 record into...

Close.... BEGIN TRANSACTION; UPDATE coilspec.dbo.coilspec SET wire1 = ws.coil FROM coilspec.dbo.wirespec ws WHERE coilspec.dbo.coilspec.coil = ws.coil; ... wrote freehand, so check it before committing. -------------------------------------------------- “Crash programs fail because they are...

haha... That's exactly how I found out that it was the source of the deadlock. The dump shows both the Offender and the Victim were dbo.Audit. There are no triggers. Three indexes (possibility?) that get rebuilt every weekend with the back up process, and do not have Page Locks enabled, only Row...

Using SQL Server 2008 R2 I have an intermittent deadlock that happens on one of our audit tables. From what I understand of Row Locking, it shouldn't be happening at all here. All our stored procedures have the following layout (trimmed for ease of debugging). Now with all things being equal...

Well, they (NetAdmins) have that locked out. So I used the sp_procoption you mentioned previously until they decide to get around to doing it. George, thank you greatly for the assist. -------------------------------------------------- “Crash programs fail because they are based on the theory...

George, Thank you. That's close enough for what I need. DBCC TRACEON (3605,1204,1222,-1) It's a simple little setting that enables the DeadLock information to be reported. I then have a job that dumps that info to an email and sends it to us. In fact, I got it from SqlServerCentral.com here...