Search results for query: *

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...

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...

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...

I must not be putting in the right key words to Google. I have a simple DBCC command I want to run every time the server/service is restarted. The Maintenance Plans do not support an "On Start Up" option for execution times. Does anyone know how to accomplish this? Is it possible? I appreciate...

Using SQL 2008 R2 Over the past several months, we have developed a deadlock issue with our Audit table. We use the following at the beginning of all our stored procedures: BEGIN TRANSACTION; INSERT INTO Audit(ProcName, CmdType, Statement, ExecFrom, RecordIdNum, Arg1...

Using Vb.Net 2010 SP1 I have encountered this a few times now and for the life of me do not understand what is happening or why. I have a DataGridView named dgParts. It has multiple columns (with prefix of "dc") associated with it. I used the GUI interface to create it all. At run time the...

How can I find if a table already has IDENTITY_INSERT set to ON so it can be turned off? I've looked in the sys.tables, sys.databases, sys.etc for a flag but can't find anything. Tried Google, but guess I'm not wording it right. -------------------------------------------------- “Crash...

Using 2008 R2. We're finally getting to where we can convert the old table structures into a real database with relational structures and everything! (long story). I am looking for suggestions for an Addresses Table that supports international addresses. There's a million different ways to do...

Using: SQL 2008 R2 I've come across some old procedures that need error trapping, but have CURSOR(s) in them. How do I determine the Cursor's state to test if it needs to be closed and/or deallocated from within the CATCH block? What happens to the Cursor when there is an error or RAISERROR...

Have you looked at REPLACE()?SELECT [Names] = AccountName, [Addresses] = AccountAddress, [Display] = AccountName + ' ' + REPLACE(REPLACE(AccountAddress, CHAR(13), ''), CHAR(10), '') FROM tblAccounts; -------------------------------------------------- “Crash programs fail because they are...

Using: SSRS 2008 R2; SQL BIDS (which is basically VB.Net 2008). Probably something completely obvious. Where do you set the Display Name of a report being deployed to a report server? I see the description field, but the report name (rptJobStatus) posted is the file name. I'd like to set an...

Does anyone have a good way to covert a DataRow and a DataGridViewRow back and forth? Depending on the direction of data, is the direction needed and I'm just getting irritated with the bulky IF statements and conversions. Problem is I have a grid that may or may not have a DataSource loaded...

Has anyone found a way to view Flash with iPod Touch, iPhone, or the iPad? Maybe another browser that supports it or a Safari plug-in? I read that Adobe created a plug-in, but Apple is refusing to approve it for the devices. Apple's blockade of Flash is really getting the way of a lot of...

Using Vb.Net 2010. I've run into an issue while loading a DataGridViewComboBoxColumnin a DataGridView control. All columns are created via the designer. Everything works, but only when using String data types for the ValueMember. When assigning the Integer (Int32) data type (to use the look up...

Using SQL 2008 R2. Trying to UNPIVOT 3 groups of columns in the same SELECT statement. Can UNPIVOT do more than one group at a time? I was hoping to be able to do in a single statement. Any assistance and/or advice is welcome.SELECT [InvNum] = aptrn_inv_no , [PoNum] = aptrn_ponum...

Using 2008 R2 (also happened with 2008). When restoring a copy of the production database to a point in time restore, the process terminates with the following error:System.Data.SqlClient.SqlError: The current transaction cannot be committed and cannot support operations that write to the log...

Using SQL 2008 R2. Does rebuilding the indexes while On Line create transaction entries? -------------------------------------------------- Stubbornness is a virtue -- if you are right. --Chuck Noll --------------------------------------------------

Using VB.Net 2010. After spending some time with the MonthCalendar Control, I realized the DoubleClick Event does not exist. I found where the MouseDown and MouseUp events contain e.Clicks which supposedly tell you the number of times a day was clicked. The idea was to double click a day in the...

Using VB.Net 2010. After wading through the swamp of MSDN files, I realized I've been traveling in circles all morning. When using a DataGridView, I want to allow the user to place a comment "under" the cell (storing it in the ToolTipText). I'd like to be able to adjust the cell's borders to...

Using SQL 2008 R2. A couple of months ago, we turned on CDC on some select tables. The following week, we had to turn off the Index Rebuild process of the weekly maintenance job due to the fact that CDC blocks the dropping of the Primary Key and caused the maintenance job to fail (which also...