Read the transaction log (ldf) file. My first post ever :)

Transact-SQL

Index ‹ SQL Server

- Previous
  - 1
    - Service Pack 2 Failure Ed, I'm getting the same error when and am showing the same settings as you in your log how I can't get Database Services to upgrade to sp2. Have you found anything or tried anything yet that has worked for you getting this fixed Product : Database Services (MSSQLSERVER) Product Version (Previous): 2047 Product Version (Final) : Status : Failure Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log Error Number : 11032 Error Description : Unable to install Windows Installer MSP file Tag: Read the transaction log (ldf) file. My first post ever :)
  - 2
    - messages stuck in sys.transmission_queue Remus - thank you so much for your quick response. I was hoping you would see this... :) To answer your questions: Are all messages in transmission queue on the same dialog or on different dialogs When you say dialog, do you mean the same conversation The conversation handles are indeed different. They are for the same message type They all happened during a 4 second duration 20 days ago They are all from one service to another (meaning all 119 originated from service a -> service b) They all have valid messages. I manually queried the first few out of the transmission queue and checked out the contents of the messages - non poisonous and in good working order. The transmission status is blank, so no errors occurred Are the messages remote or local (if local, is it same instance or same db) The messages are all local within the same database. All services, queues, etc. happens in the same database Attaching the profiler and monitoring for events in the Broker category shows any activity There indeed is alot of activity in the system. Messages are correctly flowing throughout the system. There are several messages a second that are flowing from the same service a -> service b and are being consumed. Is there any route for the messages destination service in the database I do not have any routes set up. The system is very simple in architecture - service a will communicate with service b, and service b then sends an end conversation back to service a. Granted service a can talk to b, c, d, or e, but there are only two services involved in any message. (i.e. a message will not go from a to b, then b to c, c to d, then back to a.) Do new messages sent end up in the same situation or they get trough fine Yes. Last night there was an "event" on the server which caused ~200 more messages to get stuck in the transmission queue. There are other messages that are traveling along the same route (this is the return call from end conversation from service b -> service a) and are getting to their destination just fine. I would love to recycle the service, but we are very very very busy this time of year, and this isn't an option for another couple weeks. Also, being new with service broker I would love to better learn the internal workings, and poke around with the system views to understand what is turned off, etc. Any guidance, ideas, suggestions or guesses are greatly appreciated! :) Thanks in advance, John Hennesey Tag: Read the transaction log (ldf) file. My first post ever :)
  - 3
    - Calculated Average w/o a dimension specified The biggest problem I've got with Axis(0) is that it include the subtotals and grand totals as simply another row, and since I don't have a fixed dimension to work with, I've been unable to filter them out of the set. The Rows/Columns issue you mention is a problem, but not the end of the world. The users doing the queries will be reasonably experienced, just not enough to craft their own MDX. I can warn them about that scenario (if the other problem can be fixed) How many dimensions So far 4 is the largest number for the basic queries currently planned, though when people start wanting more estoteric comparisons, it will increase. So that could be feasible. Tag: Read the transaction log (ldf) file. My first post ever :)
  - 4
    - Mirroring problem between pcs in different location (Witness Issue) Error 64 typically happens when you connect to the other party (the witness) and during handshake the other party cannot validate the access (CONNECT permision ont he endpoint). In this case the witness abruptly closes the connection because it cannot trust the conectee. To investigate the issue, you must look into the witness host (C), it will generate Profiler events when this happens. Monitor the 'Security Audit/Audit Broker Login' and 'Broker/Broker:Connection' events. Most likely either the certificate used by the A is not installed on C's master [database] or because the login that owns A's certificate on C does not have CONNECT permission on the mirroring endpoint. Same for B, he has to be trusted by the witness as well. HTH, ~ Remus Tag: Read the transaction log (ldf) file. My first post ever :)
  - 5
    - Schedule SQL Express BAckup using SQL DMO I would like to schedule back up programatically in ASP. If I want to use WSH , It can only run VBScript and JScript files that are .vbs or .js. It does not run .asp files. If you wish to run the VBScript code contained in an .asp file in the WSH environment, you need to remove all of the HTML tags; the <% and %> tags, and rename the file with a ".vbs" extension. Also, remove all references to any of the ASP intrinsic objects. What would be the best solution Tag: Read the transaction log (ldf) file. My first post ever :)
  - 6
    - Jump to URL Just use the following code "javascript:void window.open('http://houapps277/ReportServer/Pages/ReportViewer.aspx %2fIMS-Reports%2fCR000699', '_top', 'location=0, menubar=0, toolbar=0, resizable=1, width=800')" hope it will work Tag: Read the transaction log (ldf) file. My first post ever :)
  - 7
    - Migrating Data from MySQL Hi, I was in the process of trying to load data into a SQL Express DB with bcp see Unable to open BCP host data-file when I ran across this post. I read the above linked articles. The DTSwizard seems to only want to add a new table where bcp will load data into an existing table using a format file. I have used bcp to load data in SQL Server 2000 but am having trouble with SQL Server 2005 Express. We are planning to purchase the standard version of SQL Server 2005, but I was wanting to get some feel for 2005 it until the $$$ actually come through. Isn't that what Express version is for Any help Tag: Read the transaction log (ldf) file. My first post ever :)
  - 8
    - Cross Domain Windows Endpoint Authentication? The forwarder forwards messages and messages have all the necessary means to authenticate services using certificates (the service owner and remote service binding stuff). No windows authnetication is required, nor possible, at the message level, so no real Windows credential forwarding occurs (in the terms of Kerberos delegation and such). The endpoint authentication (the GRANT CONNECT ON ENDPOINT::... and SQL Service account stuff) refers to allowing two processes (SQL Server) to authenticate each other in order to exchange messages. This can be Windows or certificate based (to be precise, is TLS as provided by schannel SSPI ) So if a forwarder F (in DomainF) sits between two machines A (in DomainA) and B (in DomainB) then the forwarder has to be able to connect to both A and B, it can use Windows or Certificate based authentication for either of these connections. So, if Windows authentication is used, DomainA and DomainF must have a trust relationship and DomainF and DomainB must also have a trust relationship. However, absolutely no requirement exists between DomainA and DomainB directly, since A and B never directly connect. The only 'authentication' between A and B happens only at the higher level of the SSB services and is always based on certificates. BTW, to be absolutely accurate (and just to complicate things in case were too easy to understand), when a SQL Server SSB in DomainA whishes to connect to a SQL Server instance in DomainB (and viceversa) mututal trust is not required, one way trust is enough. But if one way trust is used (say DomainB trusts DomainA but not viceversa) the SQL Server instance in the untrusted domain (DomainB in our case) must be installed to run as an user in the trusted domain (DomainA\user) HTH, ~ Remus Tag: Read the transaction log (ldf) file. My first post ever :)
  - 9
    - Periodic "SQL Server Assertion" error I reported this on Microsoft Connect: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=264653 Tag: Read the transaction log (ldf) file. My first post ever :)
  - 10
    - pass hidden parameter from one dataset to another I have 2 datasets in my report and I want to pass a field from the 1st dataset as a parameter to the 2nd dataset. How can I do this I tried to set the report parameter from a query using the 1st dataset but the parameter is always equal to the first record in the recordset-it never changes per row. Tag: Read the transaction log (ldf) file. My first post ever :)
  - 11
    - Activation Failure We have also recently upgraded to sql 2005 sp2 and are experiencing the same error. Log Database Mail (Database Mail Log) Log ID 139 Last Modified 6/7/2007 12:50:06 PM Last Modified By sa Message Activation failure. Does anyone have any suggestions on what be causing this problem and potential solutions. Thanks Tag: Read the transaction log (ldf) file. My first post ever :)
  - 12
    - How To Connect Remote Server's DataBase from another's Server's QueryWindow Thank u Hilary... It was really helpful... as u said i executed exec sys.sp_serveroption [192.168.2.20],'data access','true' It is Giving this type of error ... Msg 15015, Level 16, State 1, Procedure sp_serveroption, Line 101 The server '192.168.2.20' does not exist. Use sp_helpserver to show available servers. I think we have to link the servers .. can u please guide me how to do it....... Tag: Read the transaction log (ldf) file. My first post ever :)
  - 13
    - SSIS What connector and driver are you using to get to the AS400 data Tag: Read the transaction log (ldf) file. My first post ever :)
  - 14
    - Help - Can't get Compact Edition to work with CE.NET 4.2 ! And your CE 4.2 OS includes all the dependencies required by SQL CE 3.x, it that right Tag: Read the transaction log (ldf) file. My first post ever :)
  - 15
    - What solutions make returning from a disaster easier? That's the $64K question. There are a LOT of things that go into this, which is why I teach a 5 day class that just starts to cover the basics. I'll try to recap some of the highlights in a short space. Getting the data to the standby is the easy part and can be accomplished all kinds of ways. Getting the data back, as you're finding, is the one thing that virtually no one ever talks about. Want to watch a sales rep from one of these companies that either has DR services or sells DR software quirm Ask them this question and you'll get a lot of stuttering, stammering, and non-answer answers. To effectively do this, you need to employ something that inherently allows changes to be made at any location since it has built in capabilities to queue all of the changes and then just move all of the deltas, bringing the entire system back in synch. Log shipping can't do this and neither can clustering. You can do this with either replication or Database Mirroring. Database Mirroring accomplishes this by first controlling where you write to and only allowing writes in one location, which is why you can reverse roles back and forth easily and both database remain in synch. If you are using Database Mirroring to a DR site, I VERY STRONLY suggest using High Performance operating mode (asynchronous). This way, you do not impact the application throughput with your DR stuff. The other option is to utilize replication. Transactional with queued updating subscribers or merge would be two options. With either option, you would want to have writes only occuring on one side or the other although this is not strictly required or enforced. Both of these methods will send changes as they occur to your DR site, applications can be re-pointed to access the DR servers if needed and continue to write transactions, as soon as the primary site is back online replication will automatically recognize it and send any changes back, then you can decide when to switch applications back over. Tag: Read the transaction log (ldf) file. My first post ever :)
  - 16
    - Error while importing Text file using Import Export Wizard I'm convinced also that some kind of bug must exist here. I keep getting this error: The "output column "XXXX" (42)" failed because truncation occurred, and the truncation row disposition on "output column "XXXX" (42)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. This makes no sense. The data in question is nowhere near large enough to cause a truncation. All the columns are properly mapped. All of the rows are properly delimited. I've tried to make sense of the "Error Output" tab on the OLE DB Destination Editor, but I can't make any sense of it. If I could maybe I could find a way to tell SSIS to ignore whatever fictional truncation errors it is making. Dan Tag: Read the transaction log (ldf) file. My first post ever :)
- Next
  - 1
    - SSIS Connection Manager passwords Try the SQL Server Service Pack 1. http://www.microsoft.com/sql/sp1.mspx Tag: Read the transaction log (ldf) file. My first post ever :)
  - 2
    - How to drill down on fields Hi All , I am new to Sql Server and Reporting services .. I was trying to make a drill down report I have created Grooup on detail row and set the Visibility with one of the group rows just above .. But when preview the report I cannot see any data .. How ever If I Delete the Groups I can see the data .. Is there anything that I am missing Please help Tag: Read the transaction log (ldf) file. My first post ever :)
  - 3
    - System.Data.SqlServerCE.dll reference causes error ... Hello All ... I am attempting to create a program that will run on the PocketPC 2003 environment. I have upgraded Visual Studio to SP1, I have installed SQL Server Compact Edition on my development machine and I have installed SQL Server Compact Edition Tools For Visual Studio on the development machine. I have created a new project Visual Basic - Smart Device - Pocket PC 2003. I have created a form for user input. I build and deploy the form to the Symbol Pocket PC to test - no connection to data and it works. I then add a reference to System.Data.SqlServerCE.dll and rebuild and redeploy the application to the handheld. When I attempt to open the form I receive the following error: psmPocket.exe NotSupportedException System.Drawing.Bitmap at System.Resources.ResourceReader.LoadObjectV2() at System.Resources.ResourceReader.LoadObject() at System.Resources.RuntimeResourceSet.GetObject() at System.Resources.ResourceManager.GetObject() at System.Resources.ResourceManager.GetObject() at pmsPocket.frmSetSOPType.InitializeComponent() at psmPocket.frmSetSOPType..ctor() at System.Reflection.RuntimeContructorInfo.InternalInvoke() at System.Reflection.RuntimeContructorInfo.InternalInvoke() at System.Reflection.ContrcutorInfo.Invoke() at System.Activator.CreateInstance() at MyForms.Create__Instance__() at MyForms.get_frmSetSOPType() at psmPocket.SetSOPType.Main() Now the confusing part is that I haven't changed any of the forms or the code behind the forms, I have simply added the reference to the project. Any idea why adding the reference to System.Data.SqlServerCE.dll would cause the system to start generating these errors I've checked, the install process has loaded the .NET 2 framework to the handheld. And as indicated at the beginning of this message, the application showed the form prior to my adding the reference. Thoughts Thanks ... Tag: Read the transaction log (ldf) file. My first post ever :)
  - 4
    - Deploying reports to MOSS 2007 Can you make sure you are using the upgraded Report Designer that ships with SP2 CTP2 / CTP3 btw, what Authentication mode (Windows Integrated or Trusted Account) did you use to setup the SharePoint Integration thanx, Prash Tag: Read the transaction log (ldf) file. My first post ever :)
  - 5
    - How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005 Thanks for your response... I verified the spelling got rid of spaces...but result is the same It is interesting thing.. I have only two variables: One is set on a package level and another is on the Data Flow Task level... When I set one of them in ReadonlyVariables and another in ReadandWriteVariables it allows me to open VS for Applications. If I move both to the same location ( ReadonLy or ReadAnd Write with comma separation and no spaces ) it issues the message I described... I tried specifying the namespaces for the variables, but with no Luck... Not usre what to do... Any ideas will be greately appreciated... Thanks, Vladimir Tag: Read the transaction log (ldf) file. My first post ever :)
  - 6
    - Help with expression to display a per-week daterange value! Hello, Yes, sorry about that, I should have put the SUM()'s in my post. In order to get all the weeks, your SQL query will have to return them all, whether or not they have reject data. Then you can replace the NULL's with 0. One way to accomplish this i: 1. Create a table in your database (you can actually do this from your dataset, as shown below) that holds the possible values for any date using DatePart on the week (1 - 53). 2. Modify your SQL query to join this table and make sure all these records are returned (LEFT/RIGHT OUTER JOIN). 3. Use isnull() in your query to replace with 0. I don't know your query, but here's what I think your dataset should look like: Code Snippet declare @DatePartWeeks table (WeekNumber tinyint) declare @i as int set @i = 1 while (@i < 54) begin insert into @DatePartWeeks (WeekNumber) select @i set @i = @i + 1 end select dpw.WeekNumber, isnull( r.Rejections , 0) , isnull( r.Amount , 0) , r.Date from dbo.Rejects r right outer join @DatePartWeeks dpw on DatePart(ww, r.Date) = dpw.WeekNumber By doing this, you can change your table grouping to group on the WeekNumber instead of the DatePart calculation (since you've already done it in the query). And, of course, leave the SUM()'s in your group header/footer. Hope this helps. Jarret Tag: Read the transaction log (ldf) file. My first post ever :)
  - 7
    - Trigger programming SQL 2005 vs SQL 2000 @hunchback Thanks!! That worked! But why Is it a thing of new permissions @Arnie, Thanks also for your Feedback. In my case, the SQL Server Database is generated automatically by an intranet software product. By designing the UI, the Database ist automatically generated for all fields, master/detail pages, etc. So the only way to do some automatics is with triggers or do it in ASP. In my first works I used triggers, now, I only do this automatics in ASP. Doing some queries with user-defined parameters, I show this parameters as textfields in an ASP Page and save it to a SQL Server Table. This table has a trigger which takes this parameters out of the "inserted"-object, delete all records and fill the table with data from other tables by using a cursor. The intranet Software moves now to a new page where this table "xfindsalesliteratu" is shown in a datagrid. So it isn't possible to change the behavior of the intranet software, I have to do it in that way. The whole trigger looks like: CREATE trigger [dbo] . [Salesliterature] ON [dbo] . [xfindsalesliteratu] FOR INSERT , UPDATE AS declare @lid int declare @sapno varchar ( 255 ) declare @company varchar ( 255 ) declare @literaturetype varchar ( 255 ) declare @productrange varchar ( 255 ) declare @country varchar ( 255 ) declare @language varchar ( 255 ) declare @application varchar ( 255 ) declare @document int declare @newtcdesign int declare @remarks varchar ( 3000 ) declare @letztelid int declare @datumedit datetime declare @user int declare @p_sapno varchar ( 255 ) declare @p_company varchar ( 255 ) declare @p_literaturetype varchar ( 255 ) declare @p_productrange varchar ( 255 ) declare @p_country varchar ( 255 ) declare @p_language varchar ( 255 ) declare @p_application varchar ( 255 ) declare @p_STcompany varchar ( 255 ) declare @p_STliteraturetype varchar ( 255 ) declare @p_STproductrange varchar ( 255 ) declare @p_STcountry varchar ( 255 ) declare @p_STlanguage varchar ( 255 ) declare @p_STapplication varchar ( 255 ) declare @p_AktuellerUser varchar ( 255 ) declare @whereClause varchar ( 2000 ) SELECT @p_sapno = xsapno FROM inserted SELECT @p_company = xcompany FROM inserted SELECT @p_literaturetype = xliteraturetype FROM inserted SELECT @p_productrange = xproductrange FROM inserted SELECT @p_country = xcountry FROM inserted SELECT @p_language = xlanguage FROM inserted SELECT @p_application = xapplication FROM inserted SELECT @p_STcompany = xsearchtermcompany FROM inserted SELECT @p_STliteraturetype = xsearchtermliterat FROM inserted SELECT @p_STproductrange = xsearchtermproduct FROM inserted SELECT @p_STcountry = xsearchtermcountry FROM inserted SELECT @p_STlanguage = xsearchtermlanguag FROM inserted SELECT @p_STapplication = xsearchtermapplica FROM inserted SELECT @datumedit = dtedit FROM inserted SELECT @user = luserid FROM inserted SELECT @p_AktuellerUser = xaktuelleruser FROM inserted SET @whereClause = '' if ( LEN ( @p_sapno )> 0 ) BEGIN if ( LEN ( @whereClause )> 0 ) SET @whereClause = @whereclause + ' AND ' SET @whereClause = @whereClause + '(xsapnumber LIKE ''%' + @p_sapno + '%'')' END if ( LEN ( @p_company )> 0 ) BEGIN if ( LEN ( @whereClause )> 0 ) SET @whereClause = @whereclause + ' AND ' if ( LEN ( @p_STcompany )> 0 ) BEGIN SET @whereClause = @whereClause + '(xcompany ' + @p_STcompany + ')' END ELSE BEGIN SET @whereClause = @whereClause + '(xcompany = ''' + @p_company + ''')' END END if ( LEN ( @p_literaturetype )> 0 ) BEGIN if ( LEN ( @whereClause )> 0 ) SET @whereClause = @whereclause + ' AND ' if ( LEN ( @p_STliteraturetype )> 0 ) BEGIN SET @whereClause = @whereClause + '(xliteraturetype ' + @p_STliteraturetype + ')' END ELSE BEGIN SET @whereClause = @whereClause + '(xliteraturetype = ''' + @p_literaturetype + ''')' END END if ( LEN ( @p_productrange )> 0 ) BEGIN if ( LEN ( @whereClause )> 0 ) SET @whereClause = @whereclause + ' AND ' if ( LEN ( @p_STproductrange )> 0 ) BEGIN SET @whereClause = @whereClause + '(xproductrange3 ' + @p_STproductrange + ')' END ELSE BEGIN SET @whereClause = @whereClause + '(xproductrange3 LIKE ''%' + @p_productrange + '%'')' END END if ( LEN ( @p_country )> 0 ) BEGIN if ( LEN ( @whereClause )> 0 ) SET @whereClause = @whereclause + ' AND ' if ( LEN ( @p_STcountry )> 0 ) BEGIN SET @whereClause = @whereClause + '(xcountry ' + @p_STcountry + ')' END ELSE BEGIN SET @whereClause = @whereClause + '(xcountry = ''' + @p_country + ''')' END END if ( LEN ( @p_application )> 0 ) BEGIN if ( LEN ( @whereClause )> 0 ) SET @whereClause = @whereclause + ' AND ' if ( LEN ( @p_STapplication )> 0 ) BEGIN SET @whereClause = @whereClause + '(xapplication3 ' + @p_STapplication + ')' END ELSE BEGIN SET @whereClause = @whereClause + '(xapplication3 LIKE ''%' + @p_application + '%'')' END END if ( LEN ( @p_language )> 0 ) BEGIN if ( LEN ( @whereClause )> 0 ) SET @whereClause = @whereclause + ' AND ' if ( LEN ( @p_STlanguage )> 0 ) BEGIN SET @whereClause = @whereClause + '(xlanguage2 ' + @p_STlanguage + ')' END ELSE BEGIN SET @whereClause = @whereClause + '(xlanguage2 LIKE ''%' + @p_language + '%'')' END END DELETE FROM xfindsalesliteratu WHERE xaktuelleruser = @p_AktuellerUser exec ( 'declare LiteratureCursor Cursor global static read_only For Select lid, xsapnumber, xcompany, xliteraturetype, xproductrange3, xcountry, xlanguage2, xapplication3, xliteraturdocument, xnewtcdesign, xremarks FROM xsalesliterature WHERE ' + @whereClause + ' ORDER by lid OPEN LiteratureCursor' ) if CURSOR_STATUS ( 'global' , 'LiteratureCursor' ) = 1 BEGIN WHILE ( 0 = 0 ) BEGIN FETCH NEXT FROM LiteratureCursor INTO @lid , @sapno , @company , @literaturetype , @productrange , @country , @language , @application , @document , @newtcdesign , @remarks IF ( @@error != 0 or @@fetch_status != 0 ) Break IF EXISTS ( SELECT lid FROM xfindsalesliteratu ) BEGIN SELECT @letztelid = MAX ( lid )+ 1 FROM xfindsalesliteratu END ELSE BEGIN SET @letztelid = 1 END INSERT INTO xfindsalesliteratu ( lid , dtedit , luserid , xsapno , xcompany , xliteraturetype , xproductrange , xcountry , xlanguage , xapplication , xliteraturedocumen , xnewtcdesign , xremark , xaktuelleruser ) SELECT @letztelid , @datumedit , @user , @sapno , @company , @literaturetype , @productrange , @country , @language , @application , @document , @newtcdesign , @remarks , @p_AktuellerUser END END Close LiteratureCursor Deallocate LiteratureCursor Tag: Read the transaction log (ldf) file. My first post ever :)
  - 8
    - Problems with Roles and sp_helpRoleMember Can you specify what version of SQL Server you are using Thanks Laurentiu Tag: Read the transaction log (ldf) file. My first post ever :)
  - 9
    - Join Using a substring function You can use a Derived Column transform to do a substring. I would recommend that you use a Derived Column transform to get the stage data to match with your dimension table before doing the Lookup. If you absolutely have to do the transformation on the dimension table data, you can override the SQL generated by the Lookup by checking the enable memory restriction option. This will negatively impact performance though. Or you could use a Merge Join (getting your data from the dimension via an OLE DB Source, run it through a Derived Column transform, thenMerge Join it to the stage data. Tag: Read the transaction log (ldf) file. My first post ever :)
  - 10
    - What's wrong? Hello! I wasn't sure if this was needed. But here is the whole statement! DECLARE @xml NVARCHAR ( MAX ) DECLARE @body NVARCHAR ( MAX ) BEGIN SET @xml = CAST (( SELECT DISTINCT count (*) AS 'td' , '' , First_Name As 'td' , '' , ( Service_Date_Time ) As 'td' FROM [Pharm Test Local] . dbo . Active_Orders WHERE ( Service_Date_Time <= dateadd ( Month , - 36 , getdate ())) Group By Service_Date_Time , First_Name FOR XML PATH ( 'tr' ), ELEMENTS ) AS NVARCHAR ( MAX )) + CAST (( SELECT count (*) AS 'td' , '' , First_Name As 'td' , '' , ( Service_Date_Time ) As 'td' FROM [Pharm Test Local] . dbo . Archive_Orders WHERE ( Service_Date_Time <= dateadd ( Month , - 39 , getdate ())) Group By Service_Date_Time , First_Name FOR XML PATH ( 'tr' ), ELEMENTS ) AS NVARCHAR ( MAX )) SET @body = '<html><H1>Records that have expired.</H1><body bgcolor=White><table border = 2><tr><th># of Records</th> <th>DocType</th> <th>Scan Date</th></tr>' SET @body = @body + @xml + '</table></body></html>' IF @@ROWCOUNT = 0 EXEC msdb . dbo . sp_send_dbmail @recipients = N 'jrudolf@ikon.com' , @body = @body , @body_format = 'HTML' , @Subject = 'NO RECORDS TO DELETE' , @profile_name = 'Ikon' Else EXEC msdb . dbo . sp_send_dbmail @recipients = N 'jrudolf@ikon.com' , @body = @body , @body_format = 'HTML' , @Subject = 'PLEASE REVIEW RECORDS' , @profile_name = 'Ikon' END Thanks! Rudy Tag: Read the transaction log (ldf) file. My first post ever :)
  - 11
    - error 1155 message Can anyone help please, I'm trying to install post smile. www postsmile.com. I keep getting the error setup message. Unable to execute file code 1155 Shellexecute Ex failed. I haven't a clue what this means except it won't connect me to the site and I have paid for this and entered the code. I've altered my firewall to accept it in case it was this but still no luck.Is it a fault with the company or my computer Many thanks in advance. Tag: Read the transaction log (ldf) file. My first post ever :)
  - 12
    - Running job error in schedule If it works on the Query analyzer then it is running under your context which may be SA by default. When you are trying to schedule it via SQLAgent then make sure the agent is running with required privileges for this SP to function. Tag: Read the transaction log (ldf) file. My first post ever :)
  - 13
    - Image insertion to ss2005 from Windows Mobile Hi , I am trynig to insert an image from the Windows mobile to the SQL database. Is it possible to perform this using RDA After some search in this forum , I got an impression that the only way to do this by storing the image in a local database and then do a merge replication. I do not want to do the merge replcation just fo rthis reason. Is it possible in RDA Debugging shows only some part of the data is getting updated. While trying to retrieve the image in a webpage error is poping up. My code is : string strbytes = ( Convert .ToBase64String(bytes)).ToString(); DbObj.GetSubmitSql( "Update Odrs set SignedBy ='" + txtSign.Text + "', Signature = Convert(Image,'" + bytes + "') where OrderId=" + orderNo + "" ); Please help.... Tag: Read the transaction log (ldf) file. My first post ever :)
  - 14
    - error Ok.. Expected one.. Use the following query.. SET DATEFORMAT dmy Select .... Case When IsDate(AdditionalField5)=1 Then Convert(datetime, AdditionalField5,103) Else NULL END as 'ValDate' ... From .... Tag: Read the transaction log (ldf) file. My first post ever :)
  - 15
    - Second opinion on how to build this cube Hi, I think the way i understood your two tables, they were identical and the lookup was a rollup/grouping of the main table. If this is correct, you can create a measure which is a distinct count of customers and depending on how you slice it will give you the same answer as the rollup. Although the population thing has confused me. If above is correct and you slice it by the 10_year.., calendar and city you will get a distinct count of customers for that slice. Hope that helps Matt Tag: Read the transaction log (ldf) file. My first post ever :)
  - 16
    - Named Pipes Provider, error: 40 - Could not open a connection to SQL Server From the error message, your scenario is broken on connection stage and I would like to know if you have tried basic connectivity tests between the two mahcines you are working on. One simple way to verifty connectivity is to use command line tools, such as osql.exe. For example, osql -E -Stcp:servername\instancename. If it connects cross-machine successfully, please also verify that your connection string in your scenario is correct. Tag: Read the transaction log (ldf) file. My first post ever :)

J-A.G.

Hi!

The purpose is to se history of which user updated, inserted or deleted a row in the database.

Can't seem to find any publications from microsoft on how to parse and interpret the log file.

Any documentation on how the log file is structured
Is it possible to obtain this information through the system views

I don't want to use triggers.

Thanks

Re: Read the transaction log (ldf) file. My first post ever :)

Frank Kalis

Consider the use of a third-party application for this job. That is money that's well spent.

Re: Read the transaction log (ldf) file. My first post ever :)

J-A.G.

Thanks for the reply.

I know there exist som applications that can read log files, like Lumigent Log Explorer.

But it would be nice with an freeware version

Re: Read the transaction log (ldf) file. My first post ever :)

Manivannan.D.Sekaran

If you really want to learn, here the docuemnt on basic level.. I found few months back very unexpectedly... Nice one....

But this document is not sufficient to start programing with Tx Log files.. As Frank says you can use the 3rd party tools.. there are lot of products available on the market...

https://www.blackhat.com/presentations/bh-usa-07/Fowler/Presentation/bh-usa-07-fowler.pdf

Re: Read the transaction log (ldf) file. My first post ever :)

Frank Kalis

J-A.G. wrote:

I know there exist som applications that can read log files, like Lumigent Log Explorer.

But it would be nice with an freeware version

TANSTAAFL

But in order to learn you can always use something like the undocumented

DBCC LOG (Northwind, -1)

Re: Read the transaction log (ldf) file. My first post ever :)

Emanuel Peixoto

good frank!

This undocumented command works on sql2000

Re: Read the transaction log (ldf) file. My first post ever :)

Frank Kalis

Yes it does. But as with all undocumented features the use is at your own risk.

Re: Read the transaction log (ldf) file. My first post ever :)

Emanuel Peixoto

Tks!