SQL Server 2005 and DTC enabling on 2k Server

SQL Server Database Engine

Index ‹ SQL Server

- Previous
  - 1
    - Comparing Rows in a table In our GPS Table we have an ID column for each entry. What we need to do is compare current row time by next row time. For example in you example above we would compare Row 1 with Row 2 if there is a gap of 15 mins in time we record that. Else we move to row 2 and compare it with row 3 and see if there is a gap of 15 minutes. We need to do this for our entire database table and record each time there is gap of 15 mins or greater between 2 entries in the table. Our goal is to split the table into a new trips table. Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 2
    - Refresh a windows form without closing it Can you show me the code for Form1 as well I think that is where we need to do the updating. If I understand your question correctly, you edit in Form2 and need it to update into Form1 without having to close and re-open Form1. One other item that is not really a huge thing but you may want to change the ClientBindingNavigatorSaveItem_Click to the following: Private Sub ClientBindingNavigatorSaveItem_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ClientBindingNavigatorSaveItem.Click Try Me .Validate() Me .ClientBindingSource.EndEdit() Me .ClientTableAdapter.Update( Me .ProjectManagmentDataSet1.Client) Me .SHIPSBindingSource.EndEdit() Me .SHIPSTableAdapter.Update( Me .ProjectManagmentDataSet1.SHIPS) Catch ex as Exception MsgBox("Update Failed: " & ex.ToString) End Try End Sub This will pop up a message box with an explanation as to why the database was not able to be updated if there is a problem updating the data. Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 3
    - Reporting error Hi, How i can hide the "error: Subreport could not be shown" message when record set returns null. In debug window actual error is : [rsRuntimeErrorInExpression] The Value expression for the textbox ‘textbox6’ contains an error: The query returned no rows for the data set. The expression therefore evaluates to null. Many thanks soha; Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 4
    - restoring a sql 2000 db in sql 2005 express db with sql server management studio express As I said in the subject I've a problem trying to restore a backup of a previous db created in sql 2000 server When I try to do it I recive the following message: ____________________________________________________________________________________ System.Data.SqlClient.SqlError: Il set di backup include il backup di un database diverso dal database 'musica2007' esistente. (Microsoft.SqlServer.Express.Smo) ------------------------------ For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476 ------------------------------ Program Location: in Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQueryWithMessage(StringCollection queries, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages) in Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries) in Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv) ____________________________________________________________________________________ What should I do What's the probem I've already tried to look for the solution in other messages but I didn't find anything..... Thanks for help,,, by Luke Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 5
    - Strange exception - Batch update Also, you can try our CTP1 release of the 1.2 version to see if it solves the issue. http://msdn2.microsoft.com/en-us/data/aa937724.aspx Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 6
    - SQL Server 2005 Express edition: SQL Server service failed to start during install. In the last step of installing the SQL Server 2005 Express edition I get the following error: Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Jun 21 19:38:35 2007 Service MSSQL$SQLEXPRESS with parameters '-d"c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data\master.mdf" -l"c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data\mastlog.ldf" -m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 21 19:38:35 2007 Service failed unexpectedly (1814) Error Code: 0x80070716 (1814) Windows Error Text: The specified resource name cannot be found in the image file. Source File Name: sqlsetuplib\service.cpp Compiler Timestamp: Wed Jun 14 16:29:04 2006 Function Name: sqls ervice tart Source Line Number: 301 ---- Context ----------------------------------------------- Do_sqlScript SqlScriptHlpr Start service MSSQL$SQLEXPRESS Error Code: 1814 MSI (s) (80!08) [19:39:58:265]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1814) The specified resource name cannot be found in the image file. . Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1814) The specified resource name cannot be found in the image file. . <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Jun 21 19:39:58 2007 Service MSSQL$SQLEXPRESS with parameters '-d"c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data\master.mdf" -l"c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data\mastlog.ldf" -m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 21 19:39:58 2007 Service failed unexpectedly (1814) Error Code: 0x80070716 (1814) Windows Error Text: The specified resource name cannot be found in the image file. Source File Name: sqlsetuplib\service.cpp Compiler Timestamp: Wed Jun 14 16:29:04 2006 Function Name: sqls ervice tart Source Line Number: 301 Any idea how I can fix this Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 7
    - Memory Error on AS Backup Getting the following error on Analysis Services backups (using version 9.00.3159.00): Memory error: Allocation failure : Not enough storage is available to process this command. Have read some of the postings on error relating to Procesing and Deployment, but not a Backup. Backups with this error have occurred after upgrading to the noted version. This has occurred on 5 and 10 gig databases on different servers, where the destination drive (not C had plenty of space. Any ideas Thanks! Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 8
    - Error: fcb::close-flush: Operating system error 21(The device is not ready.) encountered We are using sql server 2005 Enterprise Edition with service pack1 I got the following error messages in the SQL log The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x00000000090000 in file '....mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. fcb::close-flush: Operating system error 21(The device is not ready.) encountered. I got these errors for about 2 hrs and after that I see these messages in the sql log Starting up database ' ' 1 transactions rolled forward in database '' (). This is an informational message only. No user action is required. 0 transactions rolled back in database ' ' (). This is an informational message only. No user action is required. Recovery is writing a checkpoint in database ' ' ( ). This is an informational message only. No user action is required. CHECKDB for database '' finished without errors on (local time). This is an informational message only; no user action is required. Can anyone please help me in troubleshooting this issue. Why this migh have happened. any help would be appreciated. Thanks Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 9
    - Call Web Service From Script Task From the Visual Studio command prompt. Or you can start a new VB or C# project, and add a web reference. Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 10
    - Invalid character value for cast specification It is certainly possible to transfer data including NULL values between two tables. Have you compared the data types for the offending columns Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 11
    - Change the schema of a mirrored database Also remember; a Principal database can only use the Full Recovery model which means all operations are fully logged. Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 12
    - SPLIT AN ARRAY! PedroCGD wrote: Jean, But I need is to extract each field in a while, and insert each extracted value in one table. The example you gave me is not too long for my case Thanks!! I believe that what Jens posted will work just fine. Did you read the bottom part of that where he actually issues the SQL statement that calls the function In there he passes in the string to be split and it goes from there. The key is in that last SQL statement and how you make it work for your situation. The function created will work though. Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 13
    - Performance Problems One of the nifty features of SSMS. WesleyB Visit my SQL Server weblog @ http://dis4ea.blogspot.com Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 14
    - Query based Textbox Got the following error: The Value expression used in textbox ‘Client’ returned a data type that is not valid. Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 15
    - OPENROWSET Error I am trying to execute the following ad-hoc query (I have already configured the remote server to allow ad-hoc queries): --EXECUTE AS USER = suser_name() SELECT c.* INTO #MyTempTable FROM OPENROWSET('SQLNCLI', 'Server=MyRemoteServer;Trusted_Connection=yes;', 'select * from mydb..mytable (nolock) where PurchaseOrderID in (''19509114'', ''24075854'')) AS c; I receive the following error message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. I have admin privileges on the remote box-how can I get this to execute in the context of my account rather than this NT AUTHORITY\ANONYMOUS LOGON account Thanks, -Dave Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 16
    - Reporting services configuration NO initialization I am installing sql server 2005 reporting services on server running sql server 2005. I get to the reporting services configuration page and configure... report server virtual directory report manager virtual directory windows service identity web service identity database setup encryption keys when I get to Initialization the button is grey and inactive so I can't initialize reporting services, Do I need to restart server Tag: SQL Server 2005 and DTC enabling on 2k Server
- Next
  - 1
    - recursive calculated measure I am trying to write a calculated member that is an expression of the following series: A(t) = A(t-1)*(1+R1) + a(t)*(1+R2) where A(t) represents the aggregate value of the measure and a(t) represents the value observed during the period t. R1, R2 and a(t) are all calculated members themselves that are basically the first level of calculation above my facts. At any point along my time dimension t, I will be running the calculation for either 3 months or 12 months. The code for my calculated member is as follows but it simply runs away and never completes: [Measures].[BigA] AS iif (([Measures].[BigA],[Dim Time].[Time]. currentmember . prevmember )= null ,[measures].[littlea],([Measures].[BigA][Dim Time].[Time]. currentmember . prevmember )*(1+[Measures].[R1])) + [measures].[littlea]*(1+[Measures].[R2]) Any suggestions Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 2
    - DataPort Wizard from PrimeWorks Hi, Just to say that I was using the Data Port Wizard to convert MDB to SDF and back, and it has worked perfectly! I highly recommend it to others that have the same need. Just make sure to be using SQL CE 3.1 Try a look at http://www.primeworks-mobile.com/ it's worth a visit! Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 3
    - searching for a word in a text file and retuning it using script taks in ssis does any one how to search for a word in a text file and return it back using the script task in ssis the file may contain data like this POSITION SMSMSS20051230000 S ,,751600 ,,20051110,,20051230,20051230 S ,,751600 ,,20051110,,20051230,20051230 S ,,751600 ,,20051110,,20051230,20051230 S ,,751600 ,,20051110,,20051230,20051230 S ,,751600 ,,20051110,,20051230,20051230 what i am looking for is to be able to parse and get the date which is present in the first line "POSITION SMSMSS20051230000" as "20051230" and then return that as a variable .. Thanks for any help in advance smathew Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 4
    - Is it possible to restore from a database backup without a transaction log backup? Ekrem Onsoy wrote: dvang wrote: I was actually attempting to do it via the SSMS by right-clicking the database, then clicking on restore, then pointing to the .bak file, then execute. I get an error when i do it this way. Any insights If it's a FULL backup, then go to Restore Database... (You can see if it's a FULL or not from the Type column in "Select the backup sets in restore" list) Ensure that in the Restore Database window, in the Options pane Recovery State "RESTORE WITH RECOVERY" is selected This is what i get when i do it via smss, it's looking for the tail log or something Restore failed for Server 'DK\VANG'. System.Data.SqlClient.SqlError: The tail of the log for the database "DK01" has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log. (Microsoft.SqlServer.Smo) I forgot to mention that the database that i'm trying to restore back to has been changed (tables have been altered). the backup file was a backup of the database when it hadn't been altered yet. Could this be an issue I'm in a sense trying to restore an old backup to a newer updated database of the same. Even if this will not work, what about just restoring it to a whole new database (create a database from a restore backup ). I'll read up some more. Any knowledge insights is greatly appreciated! Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 5
    - Query to get rows which match with all given values Hi, May be you can try something like this: SELECT U .* FROM tblUsers As U JOIN ( SELECT FKIDUser FROM tblScores WHERE Score = 2 UNION SELECT FKIDUser FROM tblScores WHERE Score = 4 UNION SELECT FKIDUser FROM tblScores WHERE Score = 6 ) AS T ON U . UserID = T . FKIDUser Thanks & Regards, Kiran.Y Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 6
    - SQL server 2005 snapshort agent problem I have a SQL server 2005, and created a replication function. when I run the snapshort agent, I found the opration will run the sys.sp_MSsetup_partition_groups, but need a long time, and can't stop it, I don't know what is the problem about the snapshort agent, and sys.sp_MSsetup_partition_groups is running for what Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 7
    - Unable to connect to sqlserver 2000 from Sqlserver2005 Hi, iam having vs2005 installed on my machine and i also installed sqlserver2005 dev edition on my machine...Unable to connect to Sqlserver 2000 which is installed remotely ....Sqlserver2000 is dev edition.i cudnot find Sqlserver2000 instance when i try to search for Network database engine name ....... I feel to know how to enable remote connection on Sqlserver 2000.So tht i can access this sqlserver2000 from another machine Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 8
    - processing cube not pumping data You seem to have checked everything that I could see as causes for the problem. 10 M fact rows is not that much that will create problems for a standard server. It is also very hard to see why the named query will not execute without a filter clause. I have searched for file limits of the SSAS2005 data files but I have not found anything this far. What hardware are you using(32bit/64bit, no of CPU:s, RAM) . Are you using the standard or enterprise version of SSAS2005 SP1 Why are you not able to create a view of the three fact tables With that large data set a named query is not the best choice, for performance reasons. Any messages in the eventlog when you process without the filter clause Have you also started a trace with SQL server profiler when you process the cube Regards Thomas Ivarsson Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 9
    - Trouble Installing Reporting Add-In for Microsoft Visual Web Developer 2005 Express Hi Folks I've downloaded & installed Visual Web developer Express and SQL Server Express and now I'm trying to install the Reporting Add-In available here: http://msdn.microsoft.com/vstudio/express/downloads/default.aspx It downloads just fine and, just as the installation progress bar is almost done and the status text says 'Registering Product', I get the following error message: "There is a problem with this windows installer package. A program run as part of the setup did not finish as expected. Contact your support personell or package vendor" Running VWD shows the ReportViewer control now appears in the 'data' group. I can add it to a form, but I cannot create a new report, as clicking on 'Design a new report' under the ReportView Tasks popup menu does nothing. Any ideas, please Thanks Andrew Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 10
    - xquery query path without elements The Demographics xml data type column in AdventureWorks. Sales . Store contains the row sample below. How would I write the path for Demographics.query() to retun all rows with AnnualSales >=300000 I'm using variations of this statement but can't find an example of a path without elements. SELECT demographics . query ( 'declare namespace AWMI="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey"; / ' ) as Result FROM Sales . Store < StoreSurvey xmlns = " http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey " > < AnnualSales > 300000 </ AnnualSales > < AnnualRevenue > 30000 </ AnnualRevenue > < BankName > International Bank </ BankName > < BusinessType > BM </ BusinessType > < YearOpened > 1970 </ YearOpened > < Specialty > Road </ Specialty > < SquareFeet > 7000 </ SquareFeet > < Brands > AW </ Brands > < Internet > T1 </ Internet > < NumberEmployees > 2 </ NumberEmployees > </ StoreSurvey > Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 11
    - Hotfix for Bug # 473675 (SQL Server could not spawn process_loginread thread) Hi, I get " SQL Server could not spawn process_loginread thread." errors. This is related to a bug in SQL 2000 and there is a hotfix for SP3a. I am running SQL2000 with SP4. I checked the fix list of SP4 & this bug is not fixed in this SP4. Can I apply the hotfix to resolve this problem on my server tia. Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 12
    - EXEC in WHERE clause I wanted to have something like SELECT * FROM refs1 WHERE (EXEC ref_id) = this.id Should I turn the SP into a function Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 13
    - Linkserver connection fails between SqlServer 2005 and Oracle 10g Hi, Jay87, try to use the sp_setnetname stotred procedure to link the name of your linked server to the correct name of your oracle server machine sp_setnetname @server = ' server ', @netname = ' network_name ' Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 14
    - OUTPUT - help with please @SQL is my stored procedure name @Param_List is the list of enumerated parameters SET @SQL = @SQL + IsNull ( @Param_List , '' ); EXECUTE sp_executesql @SQL ; Worked like a charm. Thanks! Sandy Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 15
    - problem with Stored procedure hi everyone... Iam new with stored procedure in Sql 2005 so iam facing a problem which i need to get the result of query to store in an sql output parameter here is my SP : ALTER PROCEDURE [dbo].[CheckUser] ( @Id nvarchar(50) , @Pass nvarchar(50) , @Exist int output , @Type char(1) output ) AS BEGIN SET NOCOUNT ON; -- Insert statements for procedure here declare @tt int declare @char char select @tt=count(*) from Users where Id=@Id and Password=@Pass select @char=users.Type from users where Id=@Id and password=@Pass set @Type=@char set @Exist=@tt END so i would to retrieve the results of the 2 queries & store them in @Exist & @Type.. how can i do that Tag: SQL Server 2005 and DTC enabling on 2k Server
  - 16
    - Creating an Windows Rdl on the fly using .net programming You are welcome and I hope that the Report Build is what you are looking for. Tag: SQL Server 2005 and DTC enabling on 2k Server

Brad Moss

I am using SQLServer 2005 and .NET when I use the following statements:

using (TransactionScope objTransaccion = new TransactionScope(TransactionScopeOption.Required))
...
objTransaccion.Complete();

I get the following error:

System.Transactions.TransactionManagerCommunicationException:
Network access for Distributed Transaction Manager (MSDTC) has been disabled.
Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool. (Exception from HRESULT: 0x8004D024)

I am trying to enable the DTC on Windows 2000 Server but the references seem to be to Windows 2003 Server. Any idea on how to do it on 2k Server

TIA, Brad.-

Re: SQL Server 2005 and DTC enabling on 2k Server

oj

You need to turn on msdtc service on the target server. Use Service Control Mgr to do so.

Re: SQL Server 2005 and DTC enabling on 2k Server

ephillipe

I change the option on my 2003 Server but error persist.
Please, you can help-me

Re: SQL Server 2005 and DTC enabling on 2k Server

ssveys

I had almost the same problem, I found very good msdn article for troubleshooting problems with MSDTS. This will help you to identify and possible to fix a problem you have.

link: http://msdn2.microsoft.com/en-us/library/aa561924.aspx