Answer Questions

• KitGreen Opening a SP to modify gives incorrect name on TAB

  In SQL Server Mangement Studio when I right click on stored procedure to modify the name on the tab does not have the name of the stored procedure on it. Is there a way to turn this on When I more than one open how do I tell where a certain sp is what u see in Management Studio is Schema.StoredProcedureName... u might be seeing in Summary window where u have Name first , then Schema and Then Created... Both are same ... Madhu The tab name currently displays an autogenerated file name with server and database information (same as what a new query would do). It does not show the stored procedure name. Currently there is no way to turn this on. Please post a suggestion for this on http://co ...Show All

• Lionb HELP!!!! - Report parameter "Read Only"

  I'm stuck with a report not being able to use the URL parameter. I get the error: The report parameter  is read-only and cannot be modified. I do have a prompting text for the report, and I've checked the XML and there are <PROMPT></PROMPT> tags! I just dealt with a similar problem (working in RS2000) and no matter what I tried, I couldn't get the error to go away. I tried removing the parameter and re-adding it manually. I tried removing the procedure that required the parameter, re-deploying, and then adding the procedure (and thus the parameter) back in. That still didn't work. This is what I finally did: 1) Removed the parameter from the procedure (commented out the param ...Show All

• litewoheat easy (hopefully) matrix question

  I'm working with a matrix in the designer and noticed I need to add a new row in between two existing rows. When I right click and choose add row a row is added at the very bottom of the matrix. What's the easiest way to add a matrix row to the middle of a matrix, one that doesn't include editing the rdl directly. thanks Thanks for the response! I can insert a row below the first row but every other row is missing that white line that indicates I can insert. Can you insert between every row or just between the first and second rows You're right. After expanding the box and some very careful mouse work I got it to insert. Hopefully the MSFT guys will make this very basic function easier to use. Thanks again for the help. ...Show All

• Deldy Replication Issue with Dynamic Filter using HOST_NAME()

  Dear ppl, I am having a couple of problems with using dynamic filters in Merge Replication (SQL Server 2005 - SQL Mobile) 1) I am trying to add a dynamic filter to my publication using the wizard as follows: SELECT <published_columns> FROM [dbo].[Audit] WHERE AuditorID = CONVERT(int,HOST_NAME()) This gives me an error Conversion failed when converting the nvarchar value 'MSSWS02' to data type int. because my computer name cannot be converted to an integer. After reading on http://msdn2.microsoft.com/en-us/library/ms152478.aspx I have found that it has been recommend specifying CONVERT(nchar,AuditID) = HOST_NAME() in the wizard and then use sp_changemergearticle to change the clause to AuditID = CONVERT(int,H ...Show All

• YRaj Paging in Stored Procedure

  I got this code on internet for Stored Proc paging. This will work if my final result is the order of eployee id. In my case my final result is in the order of emplyee name. What i have to change in below code so i can have paging in SQL plus my order is by name. I dont want to create Temp table. Becuase i think Creating temp table is overhead to sql server and in that case i'll use Datagrid defualt paging and return all rows always.(My total number of rows will not be more than 300 and in 70% cases they are below 100) CREATE PROCEDURE [dbo].[usp_PageResults_NAI] ( @startRowIndex int, @maximumRows int ) AS DECLARE @first_id int, @startRow int -- A check can be added to make sure @startRowIndex isn't > count(1) -- from ...Show All

• Fred Bernstein Copy Database wizard issue

  Despite the fact that both the package and the model db have the file locations set to e:\data\nnn, the SSIS package is creating / copying the files into C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. This is running as a job - could it be a security issue I don't see any warning / error messages that would indicate an issue. Update... This is sounding more and more like a bug. I changed the model db file locations to the c:\ drive (diff location but known access). no change I changed the destination file location in the wizard-created SSIS package to the c:\ drive. no change No matter what I do, the wizard insists on putting the files into the program files directory listed above. Both DB's ...Show All

• jv_getmore VS2005 ReportViewer HTTP ERROR 401 Unauthorized

  Hi, can anyone help with this pls - it's getting very fustrating! there seems to be some messages and text on this issue (looks like a common problem that MS haven't published anything about yet!) but nothing I could make heads or tails off... so any help here would be very useful! I'm using VS2005 (release, NOT beta), the new reportviewer web control and an ASP.NET page - really basic, nothing fancy. I've set the reportviewer properties to: ReportServerURL= http://mytestserver/reportserver ReportPath = /AdventureWorks Sample Reports/Company Sales I'm testing the ASP.NET page is on my local machine - and the reportviewer is connecting to a remote test server (W2k3 SP1). When I view the page, then I get HTTP ERROR 401 Unautho ...Show All

• Abualnassr Varying parameter size..?

  Hello, I want to write a function that takes varying number of parameters.I mean: Fonk(4,5,7) Fonk(2) Fonk(6,6,6,8) There is a way to do this in T-SQL Thanks in advance... Hi, if this is an array of values passe to the function you should consider to pass the values as a string and a function to split the values to a table like done in: http://forums.microsoft.com/TechNet/ShowPost.aspx PostID=320221&SiteID=17 If they are indepedent parameters which are not just a value collection you can’t do it. TSQL does not allow writing function with different signatures. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Just to add to what has been guessed, I think you mean o ...Show All

• Kennon2005 Error: 18456 Severity: 14, State: 11

  I have a SQL 2005 SP1 test server running Developer Edition on top of Windows Server 2003 SP1. We're testing out a 3rd party application that is using Windows Authentication to connect to SQL 2005. The SQL Error Log is saturated with the error message listed in the subject line. The text accompanying the message alternates between "Login failed for user 'MYDOMAIN\TESTDA1$'. [CLIENT: <named pipe>]" and "Login failed for user 'MYDOMAIN\TESTDA1$'. [CLIENT: xxx.xxx.xxx.xxx]". There are two strange parts to this: 1) The application appears to be working fine on the surface, and, 2) The MYDOMAIN\TESTDA1$ account mentioned in the error text is not the user account that we are using to connect the application to SQL 20 ...Show All

• elfenland CURSOR INSENSITIVE

  Hi, DECLARE MyCursor CURSOR READ_ONLY FOR Select statement it seems I could not use INSENSITIVE in this cursor declaration, how can I accomplish that Please update thread Jim. INSENSITIVE in the declaration is a SQL-92 syntax, and READ_ONLY is not. So they are part of two different versions of cursor syntax (confusingly smashed together. Check books online in the DECLARE CURSOR topic and it shows the two different syntaxes together. Why do you think you need both INSENSITIVE implies read only: INSENSITIVE: "modifications made to base tables are not reflected in the data returned by fetches made to this cursor" And to answer your other questi ...Show All

• AndyC12345 Parallel execution of source SQL commands

  Hi, we're accessing a SQL Server as a source for some SSIS packages using quite complex SQL commands. We have dataflows getting data from up to 10 queries. The problem is that SSIS starts all these queries in parallel using up all the memory of the server (the source SQL server, not the server SSIS is running on). So the queries are very slow. Is there any way to force SSIS to start the queries after each other I already browsed the web for some answers on that and I'm not very optimistic... Maybe the only solution is really to feed the result of the query in raw files and process them later... Thanks, Jamie, thanks for the fast reply... As far as I understand (and that's what I see at least while debugging) precende ...Show All

• StarPilot Help with SQL

  Hi, i hope i posted int he appropiated forum. I hope you can help me with an sql sentence i dont know how to do,... The problem is that i have a database with fields like this: name, adress, etc.... , phone number but sometimes, i get them like this: paul, ... street... , etc... , 776509332 paul, ... street... , etc... , 234536445 paul, ... street... , etc... , 567847345 The client si the same, but he has more than one phone number.... I need to do, somehow, another table that makes this kind of duplicates to dissapear, and joins the phone numbers in an unique field for that person, so it will in the end look like this: paul, ... street... , etc... , 776509332 234536445 567847345 Can anybody help me Thanks ...Show All

• Davidsfg how to control the distance between the two matrix? or (matirx and table )

  hi everyone: the report show two tables two matrixs how can i control the distance between them I want to set the same distance between the table and matrix or (table and table ) Younger, You could possible place your tables and Matrix each inside of a rectangle and then maintain the distance between your rectangle should get you to your desired results. Ham Ham Thank you very much Your idea is good, that is worked well. Younger ...Show All

• ABS_BEG Issues With SQL 2005 Encryption

  Are there any pitfalls i should look out for when using the encryption in SQL 2005 Here are the most common issues that probably you should be aware of before using encryption: Encryption is not deterministic. This affects the ability to index encrypted data. I wrote an article describing this problem in detail as well as a few suggestions that may help you to solve this problem, you can find this article in my blog: http://blogs.msdn.com/raulga/archive/2006/03/11/549754.aspx . Performance. Encryption/decryption will consume some extra cycles. Unfortunately I don’t have any numbers to share here, but a suggestion would be to try to minimize the encryption/decryption operations to the min ...Show All

• shaper Can't precompile script

  Hi, with a script task I get an error "This task is configured to pre-compile the script but the binary code is not found. Please visit the IDE in Script Task editor by clicking Desing Script button to cause binary code to be generated". Well, if I do so the error doesn't disappear. The only chance I have is to switch of precopilation, which is quite a performance issue... I have no idea where this error is comming from... The script is quite easy, just some string and file operations (find out file change date using system.io)... Any idea Hmmm...bizarre. Sorry Thomas, can't help you there! ...any idea where to look If I switch of precompile everything works, so there shouldn't be any error in th ...Show All