Answer Questions

• einstine98 Can we use Java Script coding into the custom code of SQL Reporting services?

  Is Custom code of Sql Reporting services will only support VB Coding Can't we use Java Script coding into the custom code of SQL Reporting services You are correct. VB only. Thanks For your Reply... ...Show All

• gsl3 ReportViewer Height

  Hello, I try to embed my Reports of Reporting Services to ASP .NET Application. I use ReportViewer component of Visual Studio 2005. When I try to set Height property to 100% there is no report content shown. I tried to set SizeToReportContent property but there wasn't success. At the same time when I set Height to any particular value e.g. 400px, everything is OK. But of cousre I can't know particular height for every reports. Did you have any such problems Can you help me Thank you, Xhtml does not treat percentage height the same way as traditional html. Take a look at www.gotreportviewer.com , FAQ #14. Thaks dude you information is very useful Would it ...Show All

• Ed Hazell pass large xmlstring to sql server 2000 stored procedure

  Hi, Can I use DBType.XML in .net 2.0 to pass xml string to a stored procedure in sql server 2000 It's just that I know sql 2000 does not have xml type. If this is true then how is it possible to pass very large xml string to a stored procedure parameter Remember that the xml strings may be more than 10000 characters. At present, using .net 2.0, I am passing xml string using DbType.AnsiString with length of 50,000 and the stored procedure parameters that accepts the xmlstring is of type text. I tried using DbType.XML in .net 2.0 but noticed that sql 2000 does not accept it. Do you also know the max length of AnsiString Your thoughts please Thanks you Hi, Is there a specific reason why you need to p ...Show All

• Molon Labe How to use multiple configuration files?

  Hi everyone, How to change dynamically the connection properties for a DTSX Imagine that you launch a SSIS and under a several rules the same connection is reused with four or five different databases. I know that I can attach a configuration file or more than one but how to tell to SSIS which use in every moment Thanks in advance and regards, enric vives wrote: Hi everyone, How to change dynamically the connection properties for a DTSX Imagine that you launch a SSIS and under a several rules the same connection is reused with four or five different databases. I know that I can attach a configuration file or more than one but how to tell to SSIS which use ...Show All

• xyzt Need all the list of all possible messges that can be logged in SQL server error log

  I have got all the sql server messages from sys.messages table, out of them some of them are logged in event viewer(could be distinguished using the column is_event_logged in sysmessages) and some of them are logged in sql server error log and some of them might be logged some where else.Now, I want to know all the locations(files) where these messages gets logged and also what are those specific messages like sql server error log contains some messages(\Microsoft SQL Server\MSSQL.2\MSSQL\LOG) and event viewer contains some messages and so on... I will be really thankful if some one can provide the information on this. ...Show All

• kevdmiller5150 Return Code RC in Query Analyzer

  Hi, I've created a stored procedure which inserts values into a table and upon successful execution the RC column gets returned along with the Identity value (I'm using SELECT SCOPE_IDENTITY()), but I don't want the RC column, I only want to get the Id number of the current row. I'm doing this using the Query Analyzer. Is there a way to suppress the RC column I have run the same query on different servers and the RC col doesn't show up. I only want the ID value to put into an ASP.NET page. While testing different query methods from ASP.NET (Output parameter, Return_Value, etc) did I set a flag within SQL Server Sincerely, Fred Still not working. I'm getting @RETURN_VALUE where I expe ...Show All

• windthorstking date parmeter converts into drop down

  I am working in SSRS 2005. I have three parameters on the reports Parmeter 1 is Date filter which is drop down and values are MTD,QTD,YTD... 2nd and 3rd parameters are fromdate and todate which are datetime parameters. When user select let's say MTD from parameter1 then i have Stored procedure which populate the fromdate paramter with 1st date of the month and, todate populate the todays's date. The problem i am facing is the moment these date parameters get populated it converts into drop down. i want these date parameters should be still datetime so user can select the date. The value i am passing to these parameters are datetime type( Now() ) .Still the date parameters controls are showing as dropdown. I don't know how to hand ...Show All

• FlashFan sql services

  hello Every one, I work for mcafee and we have alot to do with data bases and their manipulation. I need to learn to work my way around the query analyzer and manager. Any good docs or web sites about thank you all Ali Katouzian alcat1975@hotmail .com Can you be a little more specific I don't understand what you are asking for. This software is called SQL Server Agent and included in MSSQL. I believe you will be creating scripts to run as batch jobs to be a part of your solutions delivery. You need to know how to create TSQL scripts and use osql to execute them in batch files. HI I am looking to learn about the software and be able to run scripts and be able to de ...Show All

• Stéphane Beauchemin Debug is greyed out?

  I know there's a trick to this, that I can't figure out. Have an SSIS package that I developed and deployed/saved( ) to a file on the SSIS server. Now I need to change the data flows. Did that, no issues, lets me resave the file, but I can't debug or execute the package so I can test what I did is right Why is the debug drop down box greyed out There's gotta be something I'm missing here. THanks, Lezza Was there a published resolution to this I'm now encountering a similar situation. Right clicking in the Data Dlow design space used to popup a menu with 'Execute Task' (or something). I can't remember exactly what it was as the damn thing doesn't appear any more... I've b ...Show All

• Pramod_SN I can't connect to my local database.mdf file

  I have just upgraded to Microsoft SQL Server 2005 Express Edition with Advanced Services SP2. Now I can't connect to my local database.mdf file. When trying to open or doubleclick or expand my .mdf file the following message pops up: Generating user instances in SQL Server is disabled. Use sp_configure 'user instance enabled' to generate user instances. What is the solution for this problem Hi Andrea. I have entered your code in the query editor and saved it as SQLQuery5.sql. SQL server is restarted. I right clicked in the query editor and hit Execute and get the folloving error: Msg 233, Level 20, State 0, Line 0 A transport-level error has occurred when sending the request to the server. (provider: Share ...Show All

• Akinja-Earl Error in Copy Database Wizard execution

  I've been moving databases to 2005 and have always received useful error messages regarding failures using the Copy Database wizard... until the database I am working on now - below is the entire error message - not very useful huh - any ideas on where to look for the problem (substituted xxxx for servernames etc) Thanks, Chris Event Type: Error Event Source: SQLISPackage Event Category: None Event ID: 12550 Date: 1/17/2007 Time: 11:13:02 AM User: xxxxxxx Computer: xxxxxxx Description: Event Name: OnError Message: The requested objects failed to transfer. StackTrace: at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer() at Microsoft.SqlServer.Management.Smo.Transfer.TransferData() at Microsoft.SqlServer. ...Show All

• BushGates Pass value of report parameter from URL

  Hello I have an ASP.NET application where I can filter data from an SQL DB by certain criterias. Users are now also able to click on a link which redirects them directly to the SQL Server Reporting Services application. What I'd like to have is a possibility to pass an object (as string) from my ASP.NET app to the textbox of the search criteria from the Reporting Services app. Example: - ASP.NET appl.: The user selected a FileId=84 -> then he clicks on the hyperlink to the SQL RS - The SQL RS appl. opens and the textbox FileId is filled with "84" it of course isn't a problem to pass the FileId to the hyperlink the user clicks on, but is it possible that the SQL RS appl. can somehow read it from the URL and pass it to the textb ...Show All

• Justin_H How to put the data region in the center of each page?

  Hi, all experts here, Thank you very much for your kind attention. Would please anyone here give me any guidance and advices for how to put the data region like (a table report) in the center of each page Thanks a lot in advance for that. With best regards, Yours sincerely, Hiya, Would please any experts here give me any guidance and advices for that Really need help. Thank you very much. With best regards, Yours sincerely, ...Show All

• NehaVSTS Run child package independently [FOUND IT]

  Hi there I have a parent package which execute a child package. But when the child package is run from the parent not all of the tools inside is executed. I have a variable "ExecuteStep" from the parent that gives information about which tools, that needs to be executed. BUT The child package should be able to run independently also. In this case all tools inside the package should execute. This is however not possible because my variable "ExecuteStep" does not exist inside the package, it is inheritage from my parent. If I create a variable with exactly the same name inside my child package, I can run the child independently, but when executed from the parent the value from the parent package is now overwritten by t ...Show All

• MikeTomkies Transmission queue ?

  Hi There I have sent messages and they are all sitting in the transmission queue with a blank status, why is service broker not trying to send them They are no errors in the sql log. BOL says this is blank when it has not tried to send the message Service broker is definately activated in the database. How do i force sql server to send anything in the transmission que I have no idea what is wrong or where to check Thanx   Dietz wrote: Also i find it odd that these valid erros do not display in the transmission queue The status is just blank in the transmission queue, is this correct The transmission queue can only display errors than happen locally, before the mess ...Show All