#DateForumTypeThreadPost
726 Jan 2010 @ 12:39 PSTDatabaseReplycreate table as (select.... takes long timeFirst attempt:Without seeing yor code and having some knowledge of your data it is difficult to establish the exact cause.Are you specifying a primary index (PI) for your newly-created table? If n...
619 Jan 2010 @ 06:18 PSTDatabaseReplyTeradata Query To Fetch TableNametry (not tested):select distinct databasename, tablenamefrom dbc.columnswhere columnname = 'your_column_here';If you want only table references (i.e. not view refs)select distinct a.databasename,...
526 Sep 2009 @ 06:25 PDTDatabaseReplyTDE12 on Win 2003 - Connection Reset by PeerThanks, Jim - I'll give that a try when I get a little time to play.Your help is appreciated. Thank you.
425 Sep 2009 @ 12:56 PDTDatabaseReplyTDE12 on Win 2003 - Connection Reset by PeerHi JimChecked the event log and got this:The following information is part of the event: Event number 33-10416-00 (severity 50, category 10), occurred on Thu Sep 24 21:06:48 2009, at 001-01 (Vproc ...
324 Sep 2009 @ 05:59 PDTDatabaseTopicTDE12 on Win 2003 - Connection Reset by PeerHello all(Sorry for the cross-post. Originally posted in Partner Apps forum by mistake).Getting DBC restarts with fresh install of TDE 12 on Win2003 Server using both "out of the box" and updated (...
224 Sep 2009 @ 04:21 PDTThird Party SoftwareTopicDemo on Win 2003 Server - Connection reset by peerHello allGetting the above with fresh install of TDE 12 on Win2003 Server using both "out of the box" and updated (12.0.0.7) ODBC drivers. Strange things happen when using BTEQWin, too - just had ...
115 Sep 2007 @ 03:02 PDTUDAReplyCompiling Stored Proc - VC++ not installed errorIf you installed VC Express into the default location, create a text file with the following contents:CompilerPath:C:\Program Files\Microsoft Visual Studio 8\VC\bin\LinkerPath:C:\Program Files\Micr...