Answer Questions

• Larra Printing Selection Criteria

  Hi, I'm a newbie to SSRS. I'm just wondering how you could print selection criteria (parameters) when you are actually exporting So far I would think you probably need some kind of control (rectangle) to do that. Or should you write some code to actually do that Also, regarding integration with Analysis Serives, is there a web front end for cubes and dimensions Does report builder supports that Thank you very much for you help. Jo ...Show All

• Matthew Mitrik MSFT SSIS Error with SQL Server Destination.

  I am getting this error with a package that runs correctly on my local box (hyperthreading P4) and does not run on the server (Dual AMD 64bit). [SQL Server Destination [15909]] Error: The thread for the SSIS Bulk Insert task failed initialization. [DTS.Pipeline] Error: component "SQL Server Destination" (15909) failed the pre-execute phase and returned error code 0xC020203B. Can anyone tell me what I might do to troubleshoot this ...Show All

• Bordak Help Troubleshoot "Could not find Type in assembly"

  I am attempting to create a CLR Procedure.  I was able to create the assembly, but I am unable to create a procedure on the assembly.  This is the error I receive: Msg 6505, Level 16, State 1, Procedure DINEServiceProc, Line 2 Could not find Type 'DINEServiceProc' in assembly 'DINEService' Here is the VB code to create the class: <code> Imports System Imports System.Data Imports System.Data.Sql ...Show All

• Lavaor Stored Proc Input Parameter Limited?

  Hi all, I am trying to create a stored proc that will take in a long string, but the stored proc does not allow me to take in more than 50 characters at a time. Is there a way to take away the limit Please help me out, thanks in advance. Daren Can you post the code you're using to verify   You should be able to accept up to 2 billion characters with either TEXT or VA ...Show All

• hangkous can't modify stored proc which is in a publication

  Hi SQL 2005 sp1 - merge replication - HTTPS. We have 2 publications for the database - one which has subscription.SyncType = SubscriptionSyncType.Automatic and another with SyncType = SubscriptionSyncType.None. The first publication is there so we can add new stored procs etc, the second contains the initial schema and the data. When we try to modify a proc which is in the publication with SyncType = Automatic, the query never ...Show All

• Tamsenuk Querying a really badly designed table

  I am working on an application with a number of tables (which I can't change) that have data of the form a1, b1, c1... a2, b2, c2...a3, b3, c3... The tables contain 5 to 10 sets of data in each row. I want to create a stored procedure to return a cursor with a row for each set of data for a row of the table. I know I can use unions: select a1 as a, b1 as b , c1 as c... from sometable where pk=@pk union select a2, b2, c2... from ...Show All

• Donna M-T Procedure call from 2000 to 2005

  Hi is it posible to make a procedure call from an SQL Server 2000 instance to a SQL Server 2005 instance. I believe this is posible by registering the 2005 instance as a linked server with 2000 but so far have had no luck with this Thanks If SQL2005 Server Name is LPXP561 the code is as given below EXECUTE sp_addlinkedserver @SERVER='MyLinkedServer' , @Provider='SQLoledb', @srvproduct='', @DATASRC= ...Show All

• Raghs_RMK CLR trigger in another schema

  Hi, I'm trying to write a clr trigger. I have created Myschema schema under schemas folder and Table1 under this schema (i.e.: Myschema.Table1).  I created a clr trigger and tagged it with the Sqltrigger attribute as shown here: [ SqlTrigger (Name = "Trigger1" , Target = " Myschema.Table1 " , Event = "FOR INSERT" )]  When I try to deploy my assembly from VS 2005 I got the following error: Cannot f ...Show All

• Yenan MSDE connection difference between .NET 2003 and 2005

  i have two programs  that connects to remote servers MSDE that has XP firewall on it. One of them is written with .Net 2003 other is with .Net 2005. the one with 2005 doesnot connect although the one written with 2003 can connect. But when i close firewall both of them can connect. MSDE uses port 1433 and i defined this port as an exception on firewall. What is the difference between this connections. Can anyone help me ...Show All

• Smaldust Convert Binary to Ascii

  Hi Guys, I've got a question about how to convert binary to ascii. I'm using sql server 2k and reporting services. In the database i have a field with binary code in it and i want to convert it to plain text (ascii). Can anybody help me with a script,code, function, whatever.... Many thanx in advance. Gabs Tks a lot.... This was a solution for a big problem.... Tks Pedro No prob ...Show All

• FA65 FoxPro OLEDB Driver - pass parameters

  Hi, Does anyone know if the VisualFoxPro 9.0 OLEDB driver supports parameters Trying to pass parameterised queries from SSIS results in the error reported below, which implies it does support parameters, but that SSIS is not calling the driver properly somehow. Regards, Richard ----------------------------------------------- Error MsgBox: TITLE: Microsoft Visual Studio ------------------------------ Parameters cannot be ...Show All

• Brian Cordell dbms_lob conversion

  hi, am interested in porting some of my oracle quries to sqlserver. Here is a sample oracle procedure: create procedure sp1(ac_clob clob) as n number; position number; begin position := 4; n := dbms_lob.instr(ac_clob,'test', position); --returns the location of the substring n: = dbms_lob.getlength(ac_clob); --returns the length of the clob object end; As the clob object comes as a parameter let me know if it can be converted in sql server. A ...Show All

• trilk Problems with the VS2005 IDE

  I have installed VS2005 MSDN-final, SQL2005, SQL2005 EXPRESS The problems I have are two 1. I can't add a new sql Database to my windows project due to an error about not being able to start a user instance 2. After I create a new database in SQLExpress, then the datasources window doesnot show the datasource I have created when if form designer view Any suggestions please SQLExpress instances must be referen ...Show All

• Chuck Soha SQL Server 2005 fails to install!

  I have repeatedly tried to install SQL Server 2005 Beta for some reason it keeps exiting with a datastore error. I will have to mention that i had previously installed the SQL Server 2005 successfully on the same machine except i had far too little space on C and had plenty on D so in order to move the installation to D i uninstalled and I am now trying to install it on D. Any help is much appreciated. The error I keep getting is datastore ...Show All

• JRClark Data Reader Source cannot be configured

  Hi, I am using a Ado Connection Manager to connect to a M S Access source. But when I use this connection Manager in Data Reader Source, I am Not able to Configure Data reader Source. It gives exception "Cannot Acquire Managed Connection From Run Time Connection Manager". Can anyone help on this. Thanks Dharmbir I have new Integration Services Project in Microsoft Visual St ...Show All