Saturday, September 7, 2013

[SQL Server 2008 issues] Getting this error frequently on SQL Server Error 17832

[SQL Server 2008 issues] Getting this error frequently on SQL Server Error 17832

Getting this error frequently on SQL Server Error 17832

Posted: 06 Sep 2013 03:56 PM PDT

Hi Guys,Log Name: Application Event Type: ErrorEvent Source: MSSQLSERVEREvent Category: (2)Event ID: 17832Description:The login packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendoe of the client librar. [CLIENT: 127.0.0.1]Also i refer this MS KB article: http://www.microsoft.com/technet/support/ee/transform.aspx?ProdName=SQL%20Server&ProdVer=10.0&EvtID=17832&EvtSrc=MSSQLServer&LCID=1033But Error 17832 keeps on occurring.pls reply........thnx

SSMS Showing Create Object in Sprocs and Views

Posted: 06 Sep 2013 12:40 AM PDT

Hello EveryoneHappy Friday!!I have something rather odd happening in SSMS as of yesterday. I had to start another instance of SSMS to run as a different user. Since then, my SSMS is showing the Create Object statements in the Sprocs and Views when I select to open the sproc or view in a new query window.What happened to just showing the code of the query? Seems I ran into this a while back, but cannot remember what I did to correct it.Thanks in advanceAndrew SQLDBA

sp_columns_ex With Link Server to AS400

Posted: 06 Sep 2013 05:49 AM PDT

I am trying to extract data from an AS400 using SQL Server 2008 linked server. The following are the steps taken to create the linked server:• Defined ODBC connection called "HTE" to the AS400• Create linked server called "HTE" in SQL ServerI believe the link server is defined correctly because the follow are functioning:• OpenQuery returns data from the tables on the AS400 (example: SELECT * FROM OPENQUERY(HTE, 'SELECT * FROM QGPL.ABT'))• EXEC sp_tables_ex 'HTE' returns the following:- Table_Cat -- SCH - Table_Schem -- QGPL - Table_Name -- ABT- Table_Type -- TABLE- Remarks -- Some remark about tableThe problem I am having is that when I try to use the procedure sp_columns_ex no results are being returned. BOL[sup]1[/sup] indicates sp_columns_ex receives the following parameters: Table_server, Table_Name, Table_schema, Table_catalog, column, and ODBCVer. Only Table_server is required. The following are examples of the variations used without success:• exec sp_columns_ex 'HTE' , 'ABT' , 'QGPL','SCH'• exec sp_columns_ex 'HTE' , 'ABT'• exec sp_columns_ex 'HTE' , ' QGPL.ABT'• exec sp_columns_ex 'HTE'I am sure I am missing something simple, but… Any pointers would be appreciated.Many thanks,BradleyBOL - [url]http://technet.microsoft.com/en-us/library/ms188330(v=sql.100).aspx[/url]

Time difference

Posted: 06 Sep 2013 05:24 AM PDT

Hi all,I have a rather basic question, but having difficulty.... I need to calculate the difference between 2 times. Any help would be appreciated.Example:09:28:00 - 09:38:00 = 00:10:00

Get resultset from query without running query.

Posted: 06 Sep 2013 02:59 AM PDT

Is there some way to get the result set for a query without running the query? For example take the query "select * from msdb.dbo.sysjobs", and get back the result set columns and datatypes (see below). Is there some way to get that for an arbitrary query/script? [job_id] [uniqueidentifier] NOT NULL, [originating_server_id] [int] NOT NULL, [name] [sysname] NOT NULL, [enabled] [tinyint] NOT NULL, [description] [nvarchar](512) NULL, [start_step_id] [int] NOT NULL, [category_id] [int] NOT NULL, [owner_sid] [varbinary](85) NOT NULL, [notify_level_eventlog] [int] NOT NULL, [notify_level_email] [int] NOT NULL, [notify_level_netsend] [int] NOT NULL, [notify_level_page] [int] NOT NULL, [notify_email_operator_id] [int] NOT NULL, [notify_netsend_operator_id] [int] NOT NULL, [notify_page_operator_id] [int] NOT NULL, [delete_level] [int] NOT NULL, [date_created] [datetime] NOT NULL, [date_modified] [datetime] NOT NULL, [version_number] [int] NOT NULL

login_name shows up as blank in sys.dm_exec_sessions but not in sp_who2

Posted: 29 Aug 2011 06:03 AM PDT

When I probe [b]sys.dm_exec_sessions [/b](joining with other DMVs to get active-session info) I get the login_name column to be blank for a certain session.Yet, for the same spid, the Login shows up properly (not blank) when I execute "sp_who2 active".It also shows up properly in [b]sys.sysprocesses[/b].What could be the reason for the faulty output of [b]sys.dm_exec_sessions [/b]?

subtract mutlple rows from top row value

Posted: 06 Sep 2013 04:13 AM PDT

Here is my sample data: order number, location, stop type, stop datetime, column i made pup =1, drp =2.1303927 Whouse1 PUP 4394903 2013-08-11 07:26:33.000 11303927 Store1 DRP 4394904 2013-08-11 08:31:46.000 21303927 Store2 DRP 4394907 2013-08-11 09:28:57.000 21303927 Store3 DRP 4395040 2013-08-11 10:38:53.000 2What I need to do is calculate the time between the PUP time, and each DRP time. I'm thinking a cursor but looking for suggestions on how to best accomplish this? Thanks.

trying to use a linked server ODBC...

Posted: 06 Sep 2013 01:42 AM PDT

Not sure what forum to post in but I have the DSN/ODBC setup and working properly except for 1 thing. i can see and access the odbc data using the openquery option but when i try to directly select the data i get error about not able to obtain the dbschema_columns. the odbc driver/software does provide the column information. after doing some tracking down/support work i have discovered that a system table from the odbc vendor has all the column name per table. HOWEVER, one of the columns in that table is FORMAT. which i suspect is the problem but the vendor says it is not.select * from openquery(LINKEDSERVER,'select * from SYSTEM_COLUMNS') throws an error back to me.Msg 7342, Level 16, State 1, Line 1An unexpected NULL value was returned for column "[MSDASQL].FORMAT" from OLE DB provider "MSDASQL" for linked server "LINKEDSERVER". This column cannot be NULL.I was wondering if the support person from vendor is correct in saying that the column name FORMAT is not the problem, or is it?

Tempdb workfile creation/sec is high

Posted: 06 Sep 2013 12:49 AM PDT

I have alert mails from SCOM which indicates the counter workfile creation/sec is high. When checked its going above 38.Tempdb is not growing. I have SQL 2K8 Ent. 64 bit 8GB Memory for sql.My doubts are bleow.What is the value for workfile creation/sec to be worried?How should I dig deep into to check what is causing this?

Cannot insert duplicate key row in object 'sys.syscommittab'

Posted: 06 Jun 2011 01:22 AM PDT

Hi thereI have a SQL Server 2008 R2 on a windows 2008 server.After one failed backup, I started getting these errors:Error: 2601, Severity: 14, State: 1.Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'.Error: 3999, Severity: 17, State: 1.Failed to flush the commit table to disk in dbid 5 due to error 2601. Check the errorlog for more information.From Microsoft, I found this:A backup Operation On A SQL Server 2008 Database Fails If You Enable Change Tracking On This Databasehttp://support.microsoft.com/kb/978839But this bug refers to SQL Server 2008. What should I do if in my case is a R2 version?Thanks in advance

SQL 2008R2 to Oracle Transactional Replication Issue

Posted: 05 Sep 2013 11:37 PM PDT

Hi All, I have configured transactional replication between a SQL2008R2 (SP2) instance to an Oracle 11g subscriber and am receiving the following error (in pre production):[i]Command attempted:SELECT * FROM sp_MSins_TABLE_NAME WHERE 0 = 1(Transaction sequence number: 0x000007A700006DE9004700000000, Command ID: 1)Error messages:ORA-04044: procedure, function, package, or type is not allowed here (Source: MSSQL_REPL_ORACLE, Error number: 4044)Get help: http://help/4044[/i]This is the command that is trying to replicate (found using sp_browsereplcmds on the distributor)[b]{CALL [sp_MSins_TABLE_NAME] (29927,'xxx','A','123456789',NULL,'A ',100,2013-09-06 11:16:00.000,10,NULL)}[/b]Our Oracle guys think that the issue could be with the date as it's not passed in quotes - however when I check sp_browsereplcmds in our LIVE environment there are no quotes either.Does anyone have any ideas on what I could check next? The posts I've found through Google aren't much help...Cheers, Chris

How to count ALL INSERTS for database for a period of time?

Posted: 05 Sep 2013 09:20 PM PDT

Hi,Is a simple way to count all inserts for a given database for a period of time without using Data Collection?Thx in advance

Primary Key and Foreign key on the same column

Posted: 05 Sep 2013 07:44 PM PDT

Good DayI did some investigation on the database system I inherited (SQL Server 2008 R2 with 2005 Compatibility Mode) and found that the Primary Key and Foreign key both reffence the same column in one table . Could that cause unnecessary overhead on the system ? Is it a valid solution ? Is it common practice ? Any ideas ? Thanks .Lian

Imrort export wizard

Posted: 05 Sep 2013 08:35 PM PDT

Hi, I am converting data from excel sheet to exixting table with diff datatypes in sqlserver but that throws an error of conversion so plz help me

Condition requirement

Posted: 03 Sep 2013 02:52 AM PDT

Hi,I am trying to do a lookup in SQL and have to create a SQL code for the following condition under the where clause------------------------------------------------If the Continent_cd (tableA) value is in ("EUR","MED") for the matching POL_Location_cd (tableB) value in the Location_cd (tableA) column then it should be classified as OUTIf the Continent_cd (tableA) value is in ("EUR","MED") for the matching PDL_Location_cd (tableB) value in the Location_cd (tableA) column then it should be classified as INelse it should be NON------------------------------------------------The DDL and sample data are as follows-----------------------------------CREATE TABLE [dbo].[tableA]( [LOCATION_CD] [varchar](5) NULL, [CONTINENT_CD] [varchar](5) NULL)CREATE TABLE [dbo].[tableB]( [POR_LOCATION_CD] [varchar](5) NULL, [PDL_LOCATION_CD] [varchar](5) NULL, )insert into [tableA] values('UYMVD','ESM') insert into [tableA] values('BEANR','EUR') insert into [tableA] values('DEHAM','EUR') insert into [tableA] values('USSSI','MED') insert into [tableB] values('UYMVD','PHMNS') insert into [tableB] values('BEANR','SGSIN') insert into [tableB] values('DEHAM','PTLIS') insert into [tableB] values('MXVER','USSSI')----------------------------------------------Does anybody know how this can be accomplished ? Any suggestions on using lookup in SQL would also be helpful.Thanks.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog