Answer Questions

• BarryDay Queue not disabling

  HI There My activated proc is rolling back the transaction and putting the message abck on the queue infinately Normally it disabled the queue after a few rollbacks, i can see in the sql log that it just keeps rolling back and re-activating thousands of times. It only stops when i disable activation on the queue. WHy is the queue not disabling Thanx Sorry that comment was on the wrong post, yes i check sys.service_queues to make sure it is enabled. ANd i check the sql log and can see the activated sp activating and rolling abck thousands of times until i disable actiavtion. I find it very strange it always used to disable becuase of the poison message, but no longer not sure why, i would ...Show All

• Ineedhelp123 Nested Transactions

  Can anyone verify for me whether SQL Server CE 2.0 does or does not support nested Transactions when using the SQLServerCe Data Provider The SQL Server CE Books Online documentation definitely states that SQL Server CE supports nested Transactions, but the example provided uses ADOCE Data Provider. The error message that I get when trying to begin a new Transaction with an existing Transaction still uncommitted on the same SqlCeConnection is "SQL Server CE does not support parallel transactions". Is it not possible to nest Transactions with SQLServerCE Data Provider SQL Server CE doesn't support nested transactions. Meaning you can't start a transaction B inside transaction A. Can you please p ...Show All

• cssjm What is the type of object returned by AquireConnection

  Hi, I cannot seem to find the documentation on what is returned when you call ConnectionManager. For example in the code below I'm using an FTP Connection Manager. The cn variable is a System.__ComObject and I cannot see how to determine what com type it actually is, nor can I find any API documentation which describes the types each connection manager "manages". The reason I'm trying to do this is I want to create a script which enumerates the directoy listing of an FTP site, I've got it working using varaibles but I'm trying to see if it's possible to use the connection manager instead. Dim cmgr As Microsoft.SqlServer.Dts.Runtime.ConnectionManager = Dts.Connections( "FTP Connection Manager" ) Dim cn ...Show All

• Nordsee SQL server Logs in SQL Server Enterprise manager Problem

  Hello, In my SQl Server enterprise manager My log files show there are no items this has to not be correct, I am an administrator and I should see the logs files. How can i get this fixed Tdar Anyone have any Idea Is there a way to rebuild the Management Log files, I had to assume they got corrupted or compromised and I need to get them back to see what is going on with the health of the SQl Server, Are there log files a File like windows event logs, and just can be deleted or is this some system table that may need some cleaning Please help, Tdar ...Show All

• Steve Jackson Delete/truncate table ignoring contraints

  Is there any easy way to truncate a table which has a foreign key restraint I want to override the default behavior which is to not allow truncate of parent tables. I want to be able to temperarily remove the contraint so I can truncate the temple, how do you do this   your original question was different  :) Thanks.   No. There is no way to control/alter the behavior of truncate table. If you need to use it you have to drop the FK constraints even if the table is empty. If you want to reset identity value you can use DBCC CHECKIDENT. See Books Online for more details. Your original question was different. O.K. So... that isn't easily done. Is there any easy way to simply copy the sche ...Show All

• M.Yaseen Where do I put my SQL Update Statment

  OK I have my SSIS Dataflow behaving the way it should but how does one map to a table that needs an updatde to a table. In this case it is an Oracle Table so the SQl would liik like this... UPDATE PPS_PRINCIPALS SET NAME = @Variable2 WHERE (PRINCIPAL_ID = @Variable1) Sorry about that, I meant the OLE DB Command. Thats what i'd normally use to run a SQL command in the data flow task. I haven't tried it with Oracle though. hi Peter, I think you are looking for the SQL Command task in the data flow task components. Set the SQLcommand to you're required query. Cheers, Grant Put I can't access the SQL Command in the Data Flow Task ...Show All

• Spenceee Copy Table and Data from one database to another

  I am working on a migration project. Doing the standard processing, taking source data in a staging database, where I then create the new target tables, transform the source data into the new target table structure, and load the data. However, having created the new target tables in my staging database, I cannot accurately migrate these tables into the new database. An example table. The following is the script created by SQL Management Studio if I right click and script the table as CREATE. CREATE TABLE [dbo].[tbPRO_Package]( [PRO_PackageID] [int] IDENTITY(1,1) NOT NULL, [CreatedDate] [datetime] NOT NULL CONSTRAINT [DF_tbPRO_Package_CreatedDate] DEFAULT (getdate()), [CreatedBy] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS ...Show All

• ChSchmidt Localization of Report Manager to Portuguese

  Hello to all! I want to translate de interface of the Report Manager to Portuguese. I'm develop a class that implements Microsoft.Reporting.WebForms. IReportViewerMessages The class is in a file called "ReportViewerMessages.cs". The structure is like this, the project is called "PortugueseReportManager", there is a namespace named "PortugueseReportManager" and the name of the class is "ReportViewerMessages". So far so good, but when I change de web.config file in the report manager folder I'm getting over and over this error message when I try to see a report: The type PortugueseReportManager.ReportViewerMessages, PortugueseReportManager, Version=1.612.19.1, Culture=neutral, PublicKeyToken= ...Show All

• Randy Astle If Else problem

  I am trying to implement the correction for daylight savings hence I have the code as IF DATEPART(yy,GetDATE())>= 2007 {SET @i=...................... new code } [ELSE { SET... old code }] This gives me teh error as [Microsoft][ODBC SQL Server Driver]Syntax error or access violation What is going wrong here thanks kiran Hello Kiran, I think you need to have something like this: IF DATEPART(yy,GetDATE())>= 2007 BEGIN ... New Code ... END ELSE BEGIN ... Old Code ... END Hope this helps. Jarret Try running your query in Query Analyzer or Management Studio before using it in Reporting Services. You will get more ...Show All

• Doug 123 witness not working

  We are trying to set up database mirroring. The mirroring works for the principal and mirrored databases (set up via Management Studio), but when we try to set up the witness database, we are getting the error message “The ALTER DATABASE command could not be sent to the remote server instance 'TCP://… (Error: 1456)”. The same occurs if I try to do “ALTER DATABASE xxx SET WITNESS =” in TSQL. We are using the Standard edition for all three. We have tried using several different servers for the witness. All same user, same domain. Any suggestions Thanks. Do you get the solution at the end. I have the same problem. Please let me know. Thanks. We are using management studio, so are not ...Show All

• Terence Lee SQL Server Management Studio remote server agent status

  I have seen posts related to this, but no solution for my situation. On a new Windows Server 2003 system running SQL2005 SP1 (9.0.2153), remote DBAs do not have a service status indicator in the object explorer in ssms. If the DBA logs on to the server locally using the same domain ID the appropriate green arrow/play sign indicator is displayed as expected. The DBAs are members of a domain group that is a member of Remote Desktop Users and a local SQL DBAs group. The SQL DBAs group has been added as a SQL login and assigned the sysadmin role. All sql administration functions appear to work otherwise. Using subinacl to grant the SQL DBAs group access to query service state on the MSSQLSERVER and SQLSERVERAGENT services did result i ...Show All

• Khookie Install SQL SERVER 2005

    Hi All... For the last one week I am trying to install SQL Server 2005, but couldn't succeed uptil know. For installing it in the proper way first i downloaded and installed the Windows Installer 3.1, then I installed the .net Framework 2.0 from the SQL server 2005's CD. Then tried to install SQL CLIENT and SQL SERVER 2005. SQL CLIENT installed properly but not the sql server. There were two warning messages i.e. windows is not compatible and the hardware also. I use windows xp professional sp 2. I will appreciate for your precious reply Hi JENS ... Thanks for your valuable reply ...   Hi JENS ... & TVN .. Thanks for your valuable replies .. Which edition did you try to install, a ...Show All

• Beyond Blue read data from log

  hi all how i can read all the querys that send to the server exmple insert , update statement need all this statement at the end of the day how can i do that by sqlserver thanks alot Thanks very much friends SQL Server Profiler would be one way. TSQL events. If you are satisifed please mark an answer. Thanks, D Start up SQL Server Profiler. Create a new trace. Specify the desired events. Run the trace. You can collect the events into either a flat-file or a table (useful for issues additonal queries against it for integoration purposes). ...Show All

• erikkl2000 Where can I get a C# CLI Assembly template to create a new project with?

  Does anyone know where I can download a C# CLI Assembly template In VS 2005 there are no defaults to create a C# SQL Assembly like the sample HelloWorld. Rather than modifying the Hello World, I'd like to get an original template for creating a new project just like the templates to create a new Windows project. Thanks, Chris Open the New Project Dialog and under C# select Database - SQL Server Project. Too bad that the icon in the dialog and the ones shown in the solution explorer don't match, otherwise I would have found this a lot quicker. The icon in the solution explorer for the Hello World assembly is matches the C# Windows Application. Perhaps this bug can be past on to MS fo that ...Show All

• Slyke SSIS: Oracle import works, but not when scheduled

  Hi, I am running SQL Server 2005 and have built a simple SSIS package to import data from an oracle database to my SQL Server 2005 database. When I run it in SSIS, it works and it imports just fine. When I schedule it, it gives me problems. Help! It might be a problem with Oracle Provider client I installed. Is there a client version I can download and install the one I downloaded from oracle doesn't work. I bet i did something wrong though. Here is my version: Microsoft SQL Server Management Studio 9.00.2047.00 Microsoft Analysis Services Client Tools 2005.090.2047.00 Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447) Microsoft MSXML 2.6 3.0 4.0 6.0 Microsoft Internet Explorer 6.0.3 ...Show All