Answer Questions

• mperson007 Problem generating error file using BULK INSERT or BCP thru xp_cmdshell.

  BCP thru xp_cmdshell from stored procedure: EXEC sp_configure 'show advanced options', 1; RECONFIGURE EXEC sp_configure 'xp_cmdshell', 1; RECONFIGURE EXEC xp_cmdshell ' bcp database.dbo.table in c:\scheduled.csv -S SERVER\SQLEXPRESS -T -t, -r\n -c -e "error.txt"'; This is returning the following error code. I even tried placing the command in a seperate command file and calling that with no success. If ...Show All

• Ravenet Is there merge monitor sample in vb.net?

  Hello,    We are a vb.net shop and while some of us know a little C# it's not enough. Is there a sample solution for the monitoring of replication in vb.net I know about the sales one but it's in c#. Thanks. Yunjing,    Thanks for the response. Unfortunetly I am rather new to raiseevents. Is there a way someone could convert this to vb.net so I can try and understand it I am basica ...Show All

• nadir SSIS: error while trying to get set the table list

  i have a SSIS package on a server that transfers 4 tables from one database to another. The pakage runs fine with an admin account who is the creator of the package. The package was created and imported to the server. A non admin user, is able to connect to SSIS and browse the packages but when he runs the pakage, he gets the following error: Error: An error occured while trying to get set the table list to transfer. "An exception ...Show All

• Anonymous2452452345 Will package work on different CTP version?

  Hi There I have created a package in integration services using the June CTP (latest one), i was asked to deploy it on a sql server 2005 instance. On further investigation i realised that the 2005 installation was from the first CTP prior to the one i used to create the package. In configuration manager there is no SSIS it is called DTS server. My question is will my package work 100% if i deploy it to the earlier CTP version of sql server Than ...Show All

• MS82 replace first few characters

  how do i replace "Building" with bld i will getting the data like this: Buildling 100 Buildling 200 Buildling 300 Buildling 400 Buildling 500 i want like this: Bld 100 Bld 200 Bld 300 Bld 400 Bld 500 in other words, where ever building replace with BLD i'm using SRS 2000 thanks a lot Hi, You can do this either in the query or in the report. In the query you can ...Show All

• floatping How can I get this function be working?

  How can I get this function be working CREATE FUNCTION MyFunc ( @MyDate as datetime, @MyTableName varchar(50), ) RETURNS TABLE AS RETURN SELECT * FROM @MyTableName Where myDate=@MyDate You can't -- passing a table name dynamically would require dynamic SQL, and dynamic SQL is not supported in UDFs...   Why do you want to pass a table name dynamically, ...Show All

• Futzy mysql limit equivalent

  Hi, I need the equivalent for below mysql query : select *from test limit 5, 20 I know that the below is possible in SQL Server : select top 20 * from test where column1 not in (select top 5 column1 from test). But my problem is I want a generic solution wherein I will not be aware of the columns available within the table. i.e I need a equivalent query without using any of the column names Please advice That's not exactly the same.  ...Show All

• zchuang Inserting large amounts of data

  Hello all, My apologies...re-posting from "SQL Data Engine" forum... I am trying to insert large amounts of data into a table using C#.NET. I create a parameterized query, and within a loop, I set each parameter's value and use ExecuteNonQuery to populate the data. Using .NET, I have only been able to achieve 1500 records per second. Using DTS, I can achieve 975,000 records in a little over a minute. I am using SqlCommand and giv ...Show All

• AngieF Microsoft SQL Server Setup Support Files (English) -- Installation failed

  I'm trying in vain to upgrade sql server 2000 to 2005 with great headache and pain. I (finally) have removed all Beta, and other incompatible version of .NET, Visual Studio and any other offending components, and made it to the first page of the install shield. The .NET 2.0 components installed fine - but I get a fatal error trying to install the SQL Server Set Support Files. I do have a log file - and have tired searching on the vari ...Show All

• NetworkPro Export To MS Word

  I desperatley need to export reports to MS Word - can anyone tell me a way around this please thanks Now there is. Aspose.Words for Reporting Services, for more info see http://www.aspose.com/Products/Aspose.WordsRS/ . There is not native export to Word for Reporting Services. I am not entirely familiar with the following product, but they do allow Word and Reporting Services to work togethe ...Show All

• lakman What do you miss on SSIS?

  Maybe a silly thing but can you imagine that the tasks showed Heigh,Left, Top location properties as whether they were VB's control thanks Jamie. Have Done Or a snap-to-grid... :) Request it or you won't get it. http://lab.msdn.microsoft.com/productfeedback/default.aspx [Good idea by the way] -Jamie   ...Show All

• de Oracle Notiification Services Tutorial

  Can any one provide me with Tutorials for beginners http://msdn2.microsoft.com/en-us/library/ms172483.aspx Hope, it helps Yes, my book is designed to get the reader up to speed very quickly on SSNS. It's written for v2.0, but the same concepts, etc apply. I'm updating it for 2005, but I don't have a release date on that yet. I've blogged about the differences in v2.0 and 2005 here. http://sqlns.blogspot.com/2005/10/whats- ...Show All

• Daniel S Hidden objects causes additional pages in pdf

  I have some report parameters which show or hide additional columns in a table or one of two possible charts of the data (line or bars on exact the same position). the report design is to fit fully to one A4 Page. In the web the report looks OK (there a scrowl bars - but the do not disturb really), but in PDF export the report prints additional empty pages (only header and footer). It seams the hidden objects count towards the page width and hig ...Show All

• John van Kaam Rendering inconsistencies

  I have a group header which I want to hide from displaying, but still need the "Include Group Header" checkbox to be checked. So in VS, I set the row height to 0.07937cm (the lowest value it will let me enter) and set every cell in the group to Font =Verdana 1pt , CanGrow =False, LineHeight = 1pt, Padding = 0pt. I also set a background colour so I can see how this is rendering. In Preview the row is barely visible, as well as in ...Show All

• aJoe SQL Server 2005 Push

  Can someone point me to any documentation, articles, examples, etc regarding the best way to push data and/or notifications to a remote client machine that is running a win forms app from SQL Server 2005 Sorry, I mean ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dataacc9/html/2f906fff-5ed9-4527-9fd3-9c0d27c3dff7.htm SQL Server 2005 BOL > SQL Server Programming Reference > SQL Server Programming reference > SQL Native Client Progr ...Show All