Answer Questions

• Mike Yamashita SQL SERVER 2005 INSTED OF Trigger

  Hi. I set an INSTED OF INSERT trigger on a table, that deny the addition of rows in some conditions. My question is: When I run the insert command, I get the (X row(s) affected) message, even if X isn't the real number of added rows. I tried to set the @@ROWCOUNT function, but it turns out this isn't the way. Is there any way to change the affected rows count of a trigger / sp Thanks, Yaakov I think the @@row ...Show All

• NihalChand SSIS : Stored Packages error - MSDB

  Hi All I deployed a SSIS package using dtuil to the database successfully but when i go to 'Stored Packages" -> "MSDB" in an Intergration Services object explorer i get the following error TITLE: Object Explorer ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) ------------------------------ ADDITIONAL INFORMATION: Please check the version of the database which the SSIS service ...Show All

• Jack_Software Report from - Report to

  Hi, I have a report setup on reporting services which has several subscriptions attached. The report is run every business day, each hour (8am till 7pm), but the only problem I currently have, is with the report from and report to fields. Is there a proper way to set these up for the automatic distribution, so that the subscription that runs at 8am, will report data from the day before 7pm till 8am thanks! Lionell ...Show All

• awm129 Sql Server Begin Transaccion-Commit Transaccion problem

  Hi, i have this problem when i execute a job with a Begin Transaccion-Commit Transaccion sentence: "Executed as user: comfama\sqlservice. The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. [SQLSTATE 42000] (Error 7391) [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a]. [SQLSTATE 01000] ...Show All

• Xeon_boy Error 7391 in Linked Server

  Hi, I was making a linked server connection between SQL Server 2000 and Oracle 8.1.5 (both running on Windows 2000 Server), and I was creating an insert trigger in one of the SQL Server table to insert the same value to the Oracle table. But when I try to make an insert to the table, the following error occurred : Server: Msg 7391, Level 16, State 1, Procedure <triggername>, Line xx The operation could not be performed because the O ...Show All

• RodRogue Transferring data from AS400 - Please Help!

  I am attempting to transfer a table from an AS400 to SQL Server 2005 through SSIS. I am using the IBM DB2 UDB ISeries IBMDASQL OLEDB Provider as the source connector. I have tried to set up the source connector using the Table or View option but it says that No Tables Could Be Loaded. I can specify an SQL command and it shows the columns and appears to set up correctly except for showing a warning indicating that it cannot retrieve the column co ...Show All

• Delucia File Drops

  Is there a way to have SSIS monitor a folder for file drops I have been unable to determine which object/task to use for this. We need the ability to have it monitor for files being dumped by other systems, pick those up and then process them. Thanks for your assistance. - DeKlown Hi Jamie, I simply put the WMI Event Watcher Task in a For Loop Container and keep the Eval Expression to return True always ...Show All

• marcoow Using HTTP Post to secure parameter values?

  It is mentioned in "MS SQL Server 20005 Reporting Services" (good book by the way) that you can get around URL access limitations by employing the HTTP Post method. I have employed the HTTP Post example from the book and parameter values are still exposed in the URL. Am I missing something I have searched the internet trying to get a definitive answer to this issue and came across this blog ( http://blogs.msdn.com/tudortr/ ) entry w ...Show All

• Kenn Roland Row and Cell Security

    I am trying to implement row-security in SQL 2005 but i make a query to make a view CREATE VIEW vwVisibleLabels AS SELECT     ID, Label.ToString() FROM       tblUniqueLabel WITH (NOLOCK) WHERE ID IN --Classification (SELECT ID   FROM tblUniqueLabelMarking WITH (NOLOCK)    WHERE CategoryID = 1 AND IS_MEMBER(MarkingRoleName) = 1) AND --Compartments 1 = ALL(SELECT&nb ...Show All

• gabba Slow Startup from Idle

  Is it possible to stop the server from going to sleep when it is idle to improve responsiveness to new connections The server being idle isn't an error, it's just a state of the server. It's not clear what problem you're trying to solve here, could you elaborate Mike Is it possible to prevent the server from going idle (given that i'm not using user instances) N ...Show All

• Richard Polunsky Package Execution with SQL Server Agent or DTEXEC

  Hello, I want execute package with SQL Server Agent. I create a job and I try all the solutions : my job doesn't want to work. I success to launch the package but the execution failed. I try the same job launching from the server : it doesn't work either. So, I copy the command line (/FILE, /DTS or /SQL) and with DTEXEC utility it works when this command is executed on the server (on a client computer, the problem "the product l ...Show All

• Rogerio Lima Connecting SQL Server Express.......uuhhhhh....

  following is the error that I get: "An Error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server dows not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) " I have following fields that I am supposed to fill: 1) Data Source : Defauld value "Microsof ...Show All

• DanTi SQL DTS

  Background..... I have Front End VB6, and Back End Access... Access is mainly a Data Dump...a bunch of tables and data...NO queries, forms etc in Access...just Data and indexes My Question is.... Is the DTS Import Feature supposed to convert Access(including Indexes, Primary Indexs) into SQL Server B/c as far as i can it is doesnt do that If so where in SQL Server should I be looking b/c i must be blind. Second, i am getting this error ...Show All

• Herthoren Can Alter (current) Database?

  I have a *.sql script that creates database tables, and I need to modify the database to enable the service broker. In addition, the actual name of the database is not known in advance - it is set per instance of the application. I know I need to do: ALTER DATABASE dbname SET ENABLE_BROKER But I must avoid including the name of the database in the script. I did wonder if this would work: DECLARE @DB varchar(50) SELECT @DB ...Show All

• Peter Gvozdjak Install Developer Edition & Express?

  Hi: I have installed SQL 2005 Developer Edition and VS 2005. Do I need to also install SQL 2005 Express edition too My version of VS2005 is proffesional. I cannot seem to find SQL 2005 Developer Edition in the Server Explorer of VS2005. So I am wondering if I need to install SQL 2005 Express. Before I had SQL 2000 and MSDE installed with VS2003 and there was no problem. Thanks no need to install express. Thanks Blair. I will ...Show All