Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ousoonerjoe

    Collation Mismatch

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

    VS 2012 versus VS 2013 Thoughts?

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

    Odd Deadlock Issue

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

    Run script on DB Startup

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

    Deadlock occurs with INSERT VALUES

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

    DataGridView Column Indexes all return 0

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

    SET IDENTITY_INSERT

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

    International Address Table

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

    Determine CURSOR state within CATCH block

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

    Select Statement to return single string of rows

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

    Setting Report Name

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

    Convert DataRow to DataGridViewRow or DataGridViewRow to DataRow

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

    Flash

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

    Loading DataGridViewComboBoxColumn

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

    UNPIVOT

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

    Error Restoring Database

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

    Rebuild Index effect Transaction Logs

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

    Adding Event to Existing Control

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

    Change DataGridView Cell Border

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

    Index Fragmentation

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

Part and Inventory Search

Back
Top