Sunday, June 30, 2013

[SQL Server 2008 issues] Failing agent job

[SQL Server 2008 issues] Failing agent job

Failing agent job

Posted: 27 Jun 2013 03:26 AM PDT

Hi,Strange one bugging me have almost identical code running in another database on the server without issue.I have an agent job which runs[code="sql"]DELETE FROM [biostratweb].[dbo].[xx_FreeTextSearch_ABS][/code]However I always get an error:Date 27/06/2013 17:23:50Log Job History (BiblioWeb Merge and FreeTextSearch Update)Step ID 2Server SQLVMJob Name BiblioWeb Merge and FreeTextSearch UpdateStep Name Free Text updateDuration 00:00:00Sql Severity 16Sql Message ID 208Operator Emailed Operator Net sent Operator Paged Retries Attempted 0MessageExecuted as user: NEFTEX\spsqlagent. Invalid object name 'biostratweb.dbo.xx_FreeTextSearch_ABS'. [SQLSTATE 42S02] (Error 208). The step failed.When I run it directly it works fine.Any ideas, I am running SQL 2008.Many Thanks as always,Oliver

Replication DB - Dead lock issue

Posted: 29 Jun 2013 03:32 PM PDT

Hi,We have One Database which is a Replication Db, sometimes during beginning of the month, lot of user activities going and we having Dead lock issue.Any one has idea how to prevent the dead lock in Replication DB?We have to manually kill the user session one by one but if someone having same kind of issue and have any idea?Thanks,

Is there any way to track tempdb usage when checkdb is running

Posted: 27 Jun 2013 06:36 AM PDT

please help me with this q:-)

Replication Distribution Agent Failure "memory mapped file read failed"

Posted: 27 Jun 2013 06:07 AM PDT

Please advise on resolution steps that worked for you for the below error description while delivering snapshot data to subscriber server through Distribution Agent. Error messages:• The process could not bulk copy into table '"dbo"."Table"'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20037)Get help: http://help/MSSQL_REPL20037• memory mapped file read failed• To obtain an error file with details on the errors encountered when initializing the subscribing table, execute the bcp command that appears below. Consult the BOL for more information on the bcp utility and its supported options. (Source: MSSQLServer, Error number: 20253)Get help: http://help/20253• bcp "DB"."dbo"."Table" in "\etworkpath\Table_69.bcp" -e "errorfile" -t"<x$3>" -r"<,@g>" -m10000 –S<Subscriber Server Name> -T -w (Source: MSSQLServer, Error number: 20253)Get help: http://help/20253• Query timeout expired (Source: MSSQLServer, Error number: HYT00)Get help: http://help/HYT00

model and tempdb - service startup problem

Posted: 29 Jun 2013 08:41 AM PDT

Hi all,I have a big problem (it's two actually).I wanted to move system databases back to C: drive (they were installed to a different drive), so I shut down SQL server and copied sys DBs to another drive. (MSSQL 2008R2 Enterprise x64, Win Server 2008R2 x64)I modified the startup command for new master location and admin mode:-dc:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf;-c;-m;-T3608I started SQL service, but it didn't start and cannot open tempdb files (read in Win event log). I had 4 fixed size tempdb files on a dedicated T: partition (4 GB each).I thought I remove 2 piece to free up some space, so I made this in console:(c:\Program Files\Microsoft SQL Server\100\Tools\Binn>SQLCMD.EXE" -S localhost -E)ALTER DATABASE [tempdb] REMOVE FILE [tempdev4]ALTER DATABASE [tempdb] REMOVE FILE [tempdev3]Then I deleted the 2 useless files in Windows.After this I started up SQL service (-T3609 helped to resolve tempdb access problem)SQLSERVR.EXE -m -c -T3608 -T3609... and tried to attach model DB:sp_attach_db 'model','c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\model.mdf','c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\modellog.ldf'..and tempDB was starting... and tried to reach [b]tempdev3 and tempdev4[/b]!!But those are already deleted!I think it's a "deadlock" situation. "model" DB needs "tempDB", "tempDB" needs "model" DB...It would be very important to fix this, it's a production server.What should I do?Thanks in advance!Balint

Understand about index page,B Tree

Posted: 29 Jun 2013 03:28 AM PDT

Hi,I am intermediate on MSSQL . There are many article related to index and Btree . Here i stuck with one question where this Btree structure been defined . In other articles/theories sql maintain index on index pages . When queering any data from any clustered table,sql will pick Btree details from index page ? Or in other words For example a 10M records on clustered table ,to find a particular record sql will use index . This index has many non leaf nodes ,where this been defineed. Please give me some more details..:-)

SSIS Scheduled Job Completes in 2 Seconds

Posted: 20 Jun 2013 09:44 PM PDT

I have a long running SSIS package that I have run manually so far via "Execute Package Utility". Now I created a job to schedule and run it. If I start the job, instead of the package, it completes in 1 second as successful. I thought maybe I commented out the command, but it looks fine:[code="sql"]exec xp_cmdshell 'dtexec /DTS "\MSDB\Website_FTP_Import" /SERVER MyServer /CHECKPOINTING OFF /REPORTING V '[/code]I run other SSIS packages this way ..... strange. Maybe it's a permission thing somehow, but no errors.Any ideas ?

data migration from ms access database to ms sql server 2012

Posted: 20 Jun 2013 10:07 PM PDT

I have a client who is currently using a Microsoft Access Database system to store data of which the system has the maximum capacity storage of up to 2 GB. The system is currently 1.4G and is estimated to reach 1.6 GB in about 6 month's time. **I would like to know if whether does ms sql server 2012 have a UI (user Interface ) part that can be used to develop the Front-end/User Interface of the tool** **Does it have the ability to convert the current UI, developed in CLARION?** PLEASE ASSIST...

DMV's

Posted: 21 Jun 2013 01:40 AM PDT

What is the useful dmv's as dba needs in daily life ?DMVto check the blocking other than sp_who2

Implications of OR in WHERE Clause

Posted: 29 Jun 2013 02:13 AM PDT

Hi Dears,I have a problem that my index are not getting used because of using OR in my WHERE clause. likeselect * from Table1 JOIN Table2 ON Table1.C1 = Table2.C2WHERETable1.C2 = abc OR Table2.C3 = xyzCould you please give me some info or links with respect to this to know more about the implications of OR in WHERE Clause.Appreciating your helps always.

Need conditional sequence number

Posted: 28 Jun 2013 08:10 PM PDT

[code="sql"]declare @t table ( id int, PayCode char(2) null, Amount decimal(15,2) null, CDate date, TranSeq int null)declare @c int,@max int set @c = 1 insert into @t select 1, 'IR' , 1000.00 ,null, null union select 2, 'IP' , 300.00 ,null, null union select 3, 'IP' , 400.00 ,null,null union select 4, 'IR' , -1000.00 ,'2013-02-02', null union select 5, 'IR' , 200.00 ,null, null union select 6, 'IP' , 100.00 ,null, null union select 7, 'IR' , 200.00 ,null, null union select 8, 'IP' , 400.00 ,null, null select * from @t [/code]Required Output is belowid PayCode Amount CDate TranSeq1 IR 1000.00 NULL 12 IP 300.00 NULL 23 IP 400.00 NULL 34 IR -100.00 20130202 15 IR 200.00 NULL 16 IP 100.00 NULL 27 IR 200.00 NULL 18 IP 400.00 NULL 2For every IR sequence will start and get increment with coming IP but when next IR comes in , new sequence will start.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog