Tuesday, July 9, 2013

[SQL Server 2008 issues] Know the Action Doer in Database

[SQL Server 2008 issues] Know the Action Doer in Database

Know the Action Doer in Database

Posted: 08 Jul 2013 03:01 PM PDT

Dear,In my database 'myDB', there are three logins as A, B, C. All are "sysadmin". And there is no restriction to access the database objects.Say, A has done some modifications in a table without informing B and C. So how is the system to know which login or user has done the such modifications?I am using SQL SERVER 2008 R2.Please help me to know this.Regards,Akbar

What Backup Solution Do You Use?

Posted: 08 Jul 2013 05:55 AM PDT

It has been a while since I did this research so I have been re-researching the available SQL Server backup solutions and I was just wondering what the SSC community uses for for their backup/recovery needs. Gotta make a proposal soon so I'm looking everywhere. So tell me, if you are using something other than the native SQL Server backup solution, let me know what it is and why. I'm also interested in any opinions on the different products.I look forward to hearing from you!Thanks!

ERD Normalization and DeNormalization

Posted: 08 Jul 2013 06:44 PM PDT

I am developing a very big project with a huge data to be store in database.I have more than 10 categories.I want to get data from online websites on hourly basis and save them in my database.For simplicity lets discuss only one category "Properties" with few columnsHere is tableCREATE TABLE [dbo].[properties]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [title] [nchar](10) NOT NULL, [description] [ntext] NULL, [property_type] [int] NOT NULL, [beds] [int] NOT NULL, [price][bigint] NOT NULL, [website_id] [int] NOT NULL, CONSTRAINT [PK_properties] PRIMARY KEY CLUSTERED ( [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]INSERT INTO [test].[dbo].[properties] ([title] ,[description] ,[property_type] ,[beds] ,[price] ,[website_id]) SELECT 'title1','description of my property',2,5,50000000,2 UNION ALLSELECT 'title2','description of my property',1,1,10000000,1 UNION ALLSELECT 'title3','description of my property',1,3,10000000,3 SET IDENTITY_INSERT properties OFFSELECT * from propertiesIn above data we can see there is website_id(ids of websites).Its values are 1=website1,2=website2 and 3=website3Now if i search beds=1 and price=10000000,it will show me last two records(mean website 1 and website3 has your result)Is above approach is good OR Should i created different tables for each website and then make search?For example i do like three tables for property_website1,property_website2 and property_website3?

calculate working hours between 1 year ?

Posted: 08 Jul 2013 05:32 PM PDT

I have limited table like :FUL NAME DATEali sever 01-01-2013 12:50ali sever 01-01-2013 18:30 ali sever 01-01-2013 15:30ali sever 01-01-2013 08:30pinar gezer 01-01-2013 09:20pinar gezer 01-01-2013 17:50pinar gezer 01-01-2013 12:50. .. .. .Our job is starting 09:00 and finish 18:00.There are about 50 users and every user have lots of login and logout time in same day.I want to calculate total working hour but ıf users came before 09:00 we will set login time defult 09:00. and logout time will be max hour in same day.for example you can see want I want in example FUL NAME login time logout time total work timeali sever 01-01-2013 09:00 01-01-2013 18:30 9.5 hours. . .. . .. . .------------------------------------------------------------------- every total time

attach all dbs in a folder

Posted: 08 Jul 2013 06:01 AM PDT

I had to reinstall SQL server 2008 back on a server and have about 30 db's in a directory that need reattaching. Does anyone have a routine or script that will go to a specific folder and reattach all db's in that folder?

How to import non-delimited text file

Posted: 03 Jul 2013 05:07 AM PDT

Hi, all. I (will) have a non-delimited text file containing 35 lines each for over 5000 records. Below is an example of lines 1-5 and 30-35 of one record. I need two of the 35 values (SubnetMask and SubnetDescription) for each of the 5000+ records in this long, continuous file. Just looking for high-level ideas on the best way to handle this. All my other processes are in SSIS, so will ultimately integrate this import/parse solution in the flow. Any thoughts appreciated.[font="Courier New"]SubnetAddress=10.16.224.128SubnetName=FOS-Salzburg Kasernenstraase #823 VPNSubnetMask=[b]255.255.255.128[/b]NetworkAddress=10.0.0.0LocationID=895...SubnetDescription=[b]CHINA-BEIJING-C025 F2 XIANGJIANG CNVASX1706[/b]DHCPOptionTemplate=DHCPPolicyTemplate=PrimaryInterface=NoAllowDHCPClientsModifyDynamicObjectResourceRecords=Same As in Global Policies[/font]

querying specific rows by list

Posted: 08 Jul 2013 08:15 AM PDT

Hi, i have a program that returns a list of sites with siteIDs in excell/csv format. For each site id there is a record in my database table.What is the best way to query my table to only return these sites and make it into a view. Im guessing a select statement where SiteID = x1,x2,x3,x4,... is not the most efficient fastest way. Please help. Thanks!-Nick

Another Case Statement ???

Posted: 08 Jul 2013 06:02 AM PDT

HiTrying to figure out this case statementif the Dischargedate > enddt or dischargedate is null I want enddtelseI want dischargedateThanksJoecase when CONVERT(varchar(8), DischargeDate, 112) > CONVERT(varchar(8), enddt, 112) then CONVERT(varchar(8),enddt, 112)whenNULL(CONVERT(varchar(8), DischargeDate, 112)) then CONVERT(varchar(8),enddt, 112)elseCONVERT(varchar(8), DischargeDate, 112)end as DD

log differences

Posted: 08 Jul 2013 01:59 AM PDT

what is the difference between general log file and the log file in replication ?

Defecting a target server

Posted: 07 Jul 2013 11:10 PM PDT

HiWe use a Central Management Server to target multiple servers with various jobs. I have created a multi server job, and selected the required target servers from the 'target servers' section.The job has only been 'picked up' and listed in one server out of 20 ie when i look in the sql server agents\jobs folder.I remember we had a similar issue a while back whereby disabling a job on the CMS didnt disable the job on the target server and we had to defect/re-enlist it.Can anybody advise on why the jobs are not appearing on the target servers and do i have to do the 'defect - renlist' method again. Is there anything else i need to check to stop this happening ?

Can a computed column reference its own row?

Posted: 08 Jul 2013 07:20 AM PDT

I don't think so simply because the data doesn't exist but I thought I would check.Here is a sample of what I'm trying to do:[code="sql"]CREATE TABLE [dbo].[x]( [PNmCd] [varchar](50) NOT NULL, [StrtLY] [date] NULL, [StrtTY] [date] NULL)[/code][code="sql"]ALTER TABLE xADD DysBf as (datediff(dd, [StrtTy], getdate()))[/code][code="sql"]ALTER TABLE xADD CalcDt AS (dateadd(dd,-[DysBf], [StrtLY]))[/code]I was allowed to create the first computed column ([DysBf]) but I received this when trying to create the next one:[quote]Computed column 'DysBf' in table 'x' is not allowed to be used in another computed-column definition.[/quote]Basically, I would like to put a date in StrtLY and StrtTY. On that same row, I need the column DysBf to subtract the number of days before StrtTY. Then, I need to add the result of that calculation to StrtLY to populate the column CalcDt.So a sample output would look like this (for today, which is 7/8/2013):[code="plain"]PNmCd StrtLY StrtTY DysBf CalcDtOR 2012-07-10 2013-07-12 4 2013-07-06[/code]I guess the question is if my method isn't possible, what is the best way to accomplish this?

Case statement?

Posted: 08 Jul 2013 05:03 AM PDT

I have a header table and a reporting table (In Header table)If the product code selected is "health" then In reporting table ID should populate as H1 ( In header table) If the product code is "Dental" then in reporting table ID should populate as D2If the next time its Dental again then reporting should show D3If Health then in reporting - H4.How should I implement this using Case statement? Is there a better way?

SSIS SQL Command parameter issue

Posted: 18 Aug 2010 09:09 AM PDT

Hi I have inherited an ETL from someone with far better SQL skills than I and I need to add a parameter to an existing query. I have done this on numerous others without issue but it would seem that due to the structure of the query SSIS won't recognise the inclusion of the parameter so won't let me alter the code.Basically the error is parameters cannot be extracted when I add WHERE Datemodified > ? to the end of the below SQL and click the parameters button.Some hard coding in here, don't be concerned this is a legacy thing..Any help / advice appreciated, thankyouWITH TaskSubType (TaskTypeID, TaskSubTypeID, TaskSubTypeName)AS ( SELECT CASE TaskListName_ID WHEN 1 THEN 1 WHEN 2 THEN 2 WHEN 3 THEN 3 WHEN 4 THEN 4 ELSE NULL END, TaskListInt, TaskListShortDesc FROM [dbo].[TaskListValue] TV WHERE TaskListName_ID IN (1, 2, 3, 4)),TaskPriority (TaskTypeID, TaskPriorityID, TaskPriorityName)AS ( SELECT CASE TaskListName_ID WHEN 11 THEN 1 WHEN 14 THEN 2 WHEN 15 THEN 3 WHEN 16 THEN 4 ELSE NULL END, TaskListInt, TaskListShortDesc FROM [dbo].[TaskListValue] TV WHERE TaskListName_ID IN (11, 14, 15, 16)),TaskStatus (TaskTypeID, TaskStatusID, TaskStatusName)AS ( SELECT CASE TaskListName_ID WHEN 5 THEN 1 WHEN 6 THEN 2 WHEN 7 THEN 3 WHEN 8 THEN 4 ELSE NULL END, TaskListInt, TaskListShortDesc FROM [dbo].[TaskListValue] TV WHERE TaskListName_ID IN (5, 6, 7, 8)),TaskReason (TaskTypeID, TaskReasonID, TaskReasonName)AS( SELECT CASE TaskListName_ID WHEN 12 THEN 2 WHEN 10 THEN 3 WHEN 13 THEN 4 ELSE NULL END, TaskListInt, TaskListShortDesc FROM [dbo].[TaskListValue] TV WHERE TaskListName_ID IN (10, 12, 13))SELECT T.[ID] AS TaskHeaderID, T.[TaskName] AS Name, T.[Account_ID] AS CustomerID, T.[TaskType_ID] AS TaskTypeKey, TT.[TaskTypeName] AS TaskTypeValue, T.[TaskSubType_ID] AS TaskSubTypeKey, TS.[TaskSubTypeName] AS TaskSubTypeValue, T.StartDate, T.EndDate, T.DueDate, T.CompletedDate AS CompleteDate, T.AssignedToRole_ID AS AssignToRole, T.AssignedToRep_ID AS AssignTo, T.CompletedByRep_ID AS CompleteBy, T.CreatedByRep_ID AS CreatedBy, T.[PriorityID] AS PriorityKey, TP.[TaskPriorityName] AS PriorityValue, T.[TaskStatus_ID] AS TaskStatusKey, TU.[TaskStatusName] AS TaskStatusValue, T.[TaskReason_ID] AS StatusReasonKey, TR.[TaskReasonName] AS StatusReasonValue, T.[Category_ID] AS ProductCategoryID, PC.[CategoryName] AS ProductCategoryName, T.[Brand_ID] AS ProductBrandID, PB.[BrandName] AS ProductBrandName, T.[TargetType] AS TargetTypeKey, V.[ListShortDesc] AS TargetTypeValue, T.[Target] AS TargetValue, T.[Score] AS ScoreValue, substring(T.[TaskDesc], 1, 2000) AS Description, T.[TaskNote] AS TaskNote, isnull(T.[IsActive], 0) AS IsActive FROM [dbo].[Task] T INNER JOIN [dbo].[TaskType] TT ON T.[TaskType_ID] = TT.[ID] INNER JOIN [TaskSubType] TS ON T.[TaskType_ID] = TS.[TaskTypeID] AND T.[TaskSubType_ID] = TS.[TaskSubTypeID] INNER JOIN [TaskStatus] TU ON T.[TaskType_ID] = TU.[TaskTypeID] AND T.[TaskStatus_ID] = TU.[TaskStatusID] LEFT JOIN [TaskPriority] TP ON T.[TaskType_ID] = TP.[TaskTypeID] AND T.[PriorityID] = TP.[TaskPriorityID] LEFT JOIN [TaskReason] TR ON T.[TaskType_ID] = TR.[TaskTypeID] AND T.[TaskReason_ID] = TR.[TaskReasonID] LEFT JOIN [dbo].[ProductCategory] PC ON T.[Category_ID] = PC.[ID] LEFT JOIN [dbo].[ProductBrand] PB ON T.[Brand_ID] = PB.[ID] LEFT JOIN [dbo].[ListValue] V ON V.[ListName_ID] = 67 AND T.[TargetType] = V.[ListLookupID];

Error with Linked Server and Dynamic SQL

Posted: 08 Jul 2013 01:43 AM PDT

I am attempting to execute the following code via SQL agent job.USE [dataASH]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROC [dbo].[usp_CaptureStatusData] ( @RunFeat TINYINT = 0, @ELSonly TINYINT = 0 ) ASDECLARE @LSname SYSNAME ,@SQL NVARCHAR(3000) ,@curflag TINYINT ,@ErrString VARCHAR(200) ,@Trans INT ,@ret INT --InitializationSELECT @curflag = 0--ProcessingSET @Trans = 0SET @Trans = @@TRANCOUNTIF @Trans = 0 BEGIN TRAN DECLARE ls_cursor INSENSITIVE CURSOR FOR SELECT a.Name FROM Sys.servers a (NOLOCK) WHERE 1=1 AND a.is_linked = 1 AND a.server_id <> 0 ORDER BY a.Name OPEN ls_cursor FETCH NEXT FROM ls_cursor INTO @LSname SELECT @curflag = 1 WHILE @@FETCH_STATUS = 0 BEGIN ---Loading Status Data SELECT @SQL = 'DECLARE @ret INT, @pdate DATETIME SELECT @pdate = getdate() EXEC @ret = ' + @LSname + '.DataAdmin.dbo.usp_ASHDbStatus @pdate IF @@ERROR <> 0 RAISERROR(''Inner Error'', 16, 1)' --PRINT @SQL EXEC (@SQL) IF (@@ERROR <> 0) OR (@ret <> 0) BEGIN SELECT @ErrString = 'Error loading ' + @LSname + ' db status.' GOTO ERREXIT END FETCH NEXT FROM ls_cursor INTO @LSname END CLOSE ls_cursor DEALLOCATE ls_cursor SELECT @curflag = 0 IF @Trans = 0 AND @@TRANCOUNT > 0 COMMIT TRAN RETURN (0) ERREXIT: IF @curflag = 1 BEGIN CLOSE ls_cursor DEALLOCATE ls_cursor END IF @Trans = 0 AND @@TRANCOUNT > 0 ROLLBACK TRAN RAISERROR ('%s', 16, 1, @ErrString) RETURN(1)This is a code rewrite that uses Dynamic SQL (as you can see :) so that we dont have duplicate code thru out the SP. Below is the error message I am getting:Executed as user: ASH\ASHSQLserv. The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "LS01" was unable to begin a distributed transaction. [SQLSTATE 42000] (Error 7391) OLE DB provider "SQLNCLI10" for linked server "LS01" returned message "The transaction manager has disabled its support for remote/network transactions.". [SQLSTATE 01000] (Error 7412). The step failed.If I un-comment out the PRINT, I copy that result to a new Query Window and it executes successfully. I can run a SELECT statement across the Linked Server, so I dont think it is a problem with MSDTC. I did check all of the MSDTC settings though and everything appears to be started and in good order.Below is what I get with my PRINT statement un-commented out:DECLARE @ret INT, @pdate DATETIMESELECT @pdate = getdate()EXEC @ret = LS01.DataAdmin.dbo.usp_ASHDbStatus @pdateIF @@ERROR <> 0RAISERROR('Inner Code Block Error', 16, 1)How can I get the above SPROC to loop over over the Linked Servers and execute the SQL dynamically?Any and all help will be greatly appreciated.Thanks in Advance!

Inserting Results from SPROC into table

Posted: 28 Jun 2013 12:55 AM PDT

I was able to finally develop this SPROC that runs fine and returns the results but i would like to add an INSERT INTO clause that will load the values into a table that i could use for additional querying and joins.Thoughts?DECLARE @Start_Date DATETIME = NULLDECLARE @Part_Type_MP VARCHAR(1000) = ''SET @Part_Type_MP = ',' + @Part_Type_MP + ','SET @Start_Date = ISNULL(@Start_Date, DATEADD(yy, 50, GETDATE()))SET @Start_Date = dateadd(ms,-3,dateadd(day,1,DATEADD(dd, DATEDIFF(dd,0,@Start_Date), 0)))DECLARE @sqlQuery NVARCHAR(MAX),@finalQuery NVARCHAR(MAX),@q CHAR(1)=''''SET @sqlQuery = N'SELECT ' + 'PLK.Part_no, ' +'PLK.line_item_key, ' + 'PLK.unit_price ' +'FROM ' +'(SELECT p.part_no, pli.unit_price, MAX(PLI.Line_Item_Key) AS [Line_Item_Key] ' + 'FROM Purchasing_v_Line_Item_e AS PLI ' + 'JOIN Part_v_Part_e AS P ' + 'ON p.plexus_customer_no = pli.plexus_customer_no ' + 'AND p.part_key = pli.part_key ' + 'WHERE pli.add_date <= ' + @q + @q + CONVERT(VARCHAR(30), @Start_Date,120)+ @q + @q + ' AND (' + @q + @q + @Part_Type_MP + @q + @q + ' = '''',,'''' OR (CHARINDEX('''','''' + CAST(P.Part_Type as VARCHAR(50)) + '''','''', ' + @q + @q + @Part_Type_MP + @q + @q + ') >0))' + 'GROUP by p.part_no, pli.unit_price ' + ') AS PLK'-- SET @finalQuery = N'INSERT INTO dbo.tblActualPrice ' + CHAR(10)SET @finalQuery = N'SELECT ' +'part_no AS Part, ' +'unit_price AS ActualCost ' +'FROM OPENQUERY (PLEXREPORTSERVER, ''' + @SQLQuery + ''')'EXEC (@finalQuery)

SQL job is not writing on remote text flle

Posted: 08 Jul 2013 05:29 AM PDT

Alert Me | Edit | Delete | Change Type0I am trying to crate a job, that writes the result set on text file and export to location like "\\abc\xyz.txt"job succeeds but i cant see any thing written on the file and i have given the same path in the job path option.

Suggestions about ERD needed

Posted: 08 Jul 2013 12:30 AM PDT

Hi All,I am developing a very big project.I have one question about ERD.I know Normalization is good for big projects BUT I read an article saying that while you are searching in too many tables,Joining them and then find a pattern in it,It will take too much time,so more normalization is not good.My description is here"I have Four categories like Properties,Autos,Electronics and jobs. For each categories i have a crawler which gets information from 4 online websites and save in my database.Then i have a website where users can use/search in these informations like any other classified website."Now i have tables for type,categories and sub categories.For details of each category should i created different table for each website or i should save data in one table?For exampleFor Properties i am getting data from www.site1.com,www.site2.com,www.site3.com.Now which one will be better either to save in one Properties table for different tables for each likeProperties = site1+site2+site3OR Properties_site1 = site1Properties_site2 = site2 and so on...Which one will be better to get info and make search in it...

Can I change a column from smallint to float?

Posted: 04 Jul 2013 09:53 AM PDT

I've got a column, in 1 table, that's a smallint. Then I've got another table with the same column name (it's meant to be the same thing) but it is a float. I'd really like to change the data type in the first table to a float, too, but am concerned that I might loose data. May I just change the data type from smallint to float, and will SQL Server 2008 R2 keep my data?

Alter Stored Procedure with errors

Posted: 08 Jul 2013 03:38 AM PDT

So here is my problem. We have a development Database that has tables that are in the middle of some long term changes that won't be done for at least a quarter if not longer. I have a Stored Procedure that needs to be changed "NOW" but this stored procedure uses the altered tables so I cannot alter the change the should go out now that uses the correct production table columns. Is there anyway I can convince the database to ignore the fact that these columns don't exist/have altered names in the database and Alter the stored procedure anyway?

Depending on CurrentStatus will determin where to pull the values from

Posted: 08 Jul 2013 03:02 AM PDT

Hello,I have a column called OrderStatus (int) which belongs to a table called ProspectOrderIf this OrderStatus is 1 then i need to return CreatedDate, CreatedByIf this OrderStatus is 2 then I need to Return CancelledBy, CancelledDateIf this OrderStatus is 3 then i need to return GPAddedBy, GPAddedDate, Im struggling on how i can accomplish this, below is my main select statement which is working correctly,[code="sql"]Select po.OrderID, u.Firstname+ ' ' +u.Surname as CreatedBy, CONVERT(VARCHAR(10), po.CreatedDate, 105) as CreatedDate, po.OrderGuid, pls.ProspectLeadStatusDescription as CurrentStatus from ProspectOrder pojoin UserAccount u on po.Createdby = u.shortabbrjoin ProspectLeadStatus pls on @CurrentStatus = pls.ProspectLeadStatusIDwhere po.ProspectID = 42163[/code]Below is what SQL example of what im trying to achieve depending on the OrderStatus[code="sql"]Declare @CurrentStatus int = (Select OrderStatus from ProspectOrder where ProspectID = @ProspectID)if(@CurrentStatus = 1) -- Confirmed Order begin Select p.CreatedDate as LastStatusUpdatedDate, u.Firstname + ' ' + u.Surname as LastUpdatedBy from ProspectOrder p join UserAccount u on p.Createdby = u.ShortAbbr where p.ProspectID = @ProspectID endelse if(@CurrentStatus = 2) -- Cancelled Order begin Select p.CancelledDate as LastStatusUpdatedDate, u.Firstname + ' ' + u.Surname as LastUpdatedBy from ProspectOrder p join UserAccount u on p.CancelledBy = u.ShortAbbr where p.ProspectID = @ProspectID endelse -- Sale Order begin Select p.GpAddedDate as LastStatusUpdatedDate, u.Firstname + ' ' + u.Surname as LastUpdatedBy from ProspectOrder p join UserAccount u on p.Createdby = u.ShortAbbr where p.ProspectID = @ProspectID end[/code]So depending on what the OrderStatus is will determin what two extra columns i include in my main select if that makes sense? Im sure this is quite straight forward for an expert but im struggling with it :( any help would be highly appreciated.

prerequisites

Posted: 08 Jul 2013 01:40 AM PDT

what are the prerequisites to configure replicatin in sql 2008 /

syntax of building a hyperlink

Posted: 08 Jul 2013 12:50 AM PDT

Thanks in advance for any help... I am trying to build a query that will have as one of its resulting columns a hyperlink built from a site name + directory + filename + extension... I've got a start but I'm sure the syntax and punctuation are far off... any ideas? Thanks!Select A.tp_LeafName as Filename, ([http://mysite.com] + A.tp_DrName + A.FileName + D.Extension) as Hyperlink, D.UIVersionString, A.tp_drName as Path, D.Extension as ExtFrom

Delete Table Variable

Posted: 08 Jul 2013 12:22 AM PDT

I am using TableVariable inside Cursor ,So it is not returing the results for all values provided .Its returing only for 1st value to it and then it keep on executing .-How to delete all data from Table Variable.

Export data into Existing Excel File

Posted: 08 Jul 2013 12:55 AM PDT

I am returing data into TableVariables using Cursors .So I am having data for Each date of month .I want this data to be exported to existing EXCEL and new tab for Each Date of month.Can anyone help me out with this.

How to solve

Posted: 07 Jul 2013 11:45 PM PDT

Hello,declare @date1 datetimedeclare @date2 datetimeset @date1='2013-08-01'set @date2='2013-08-07'now I want the output between @date1 and @date2, how can I do that?

Sleeping SPID

Posted: 07 Jul 2013 11:03 PM PDT

Hello everyone,I have stuck in a situation where I am seeing more than 15K sleeping SPID, I know this is because of a flaw in application which is connecting with SQL (SQL server 2008).my question is "do these sleeping SPID's hold a connection and consume Server resources"Thanks

table creation on one table referenced by many tables

Posted: 02 Jul 2013 07:15 AM PDT

hiHere a requirement that I am trying to implementOne table Address is used by many tables. like member, provider and sales representative.While creating Sales Order, User would entry information for member, provider and sales representative.and address for each entitymember, provider, sales representative tables has reference to sales order tableWhich is best way to create tables1. member, provider and sales representative have FK to Address table2. Address table has 3 columns for member, provider and sales representative.3. Instead of address table, add columns to each tablemember, provider and sales representative to address is one-one.

creating new ldf file

Posted: 07 Jul 2013 09:41 PM PDT

there is one ldf file for our database. if we create one more ldf for the same database. then both of these ldfs are shared for transactions or after filling one ldf next one will comes in place.

MSDTC errors - SQL server stopped responding to any request

Posted: 07 Jul 2013 10:20 PM PDT

HiRather a strange issue with multiple SQL server instances - SQL server abruptly not responding to client applications for a brief period (5-15 minutes), but it's started responding as soon as these errors raised on SQL error log. SQL version: 2008 R2 enterprise RTMOS version: Windows server 2008 R2 Enterprise, Service pack1Client applications (IIS7) displayed with error [b]8004e024 [/b]- COM+ unable to create the instance when this issue occurring. [b]MessageError: 8510, Severity: 20, State: 1.MessageEnlist operation failed: 0x8004d00e(failed to retrieve text for this error. Reason: 15100). SQL Server could not register with Microsoft Distributed Transaction Coordinator (MS DTC) as a resource manager for this transaction. The transaction may have been stopped by the client or the resource manager.[/b][b]MessageError: 8509, Severity: 16, State: 1.MessageImport of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: 0x8004d00e(failed to retrieve text for this error. Reason: 15105).[/b]Any idea what's causing this issue? Any help on this highly appreciated. ThanksPS
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog