Answer Questions

• RAYMOND KNIGHT Before to generate a Report Model to convert an integer in a string

  Hello, we use status information by generation of a report. For example, we would like to have the number of quitted examinations, where the rebuild status is an number having 30 bits and a quitted examination should have on 7th bit=1. This means requild status&128=128. The problem is that Report model generation wizard makes from the integer rebuild status, a #rebuild status. How can I get an integer or a boolean variable telling me whether the rebuild status is 0 or 1 without to change database structure Thank you for your help in advance. Best regards, Olga Jaufman ...Show All

• Leahx Error Handling-- no connection

  I have a package that connects to remote AS400. I am wondering what is the best way to handle situation if my package could not connect to source. -kushpaw thanks, that ' a good start.   kushpaw wrote: I have a package that connects to remote AS400. I am wondering what is the best way to handle situation if my package could not connect to source. -kushpaw   There is no best way but here's a suggestion: Verify a data source before using it ( http://blogs.conchango.com/jamiethomson/archive/2005/10/10/2253.aspx ) -Jamie   ...Show All

• Neno Log Shipping v Database Mirroring (again!)

  Hi I'm looking at replicating our primary SQL server to a secondary offsite server (linked via 100Mb so effectively LAN speed). What are people's preference when deciding on a solution On the surface mirroring looks much better but having dug a little I've found it is recommended only 10 databases are mirrored per instance. That said, I've found a post from someone who is upto 58 databases mirrored. Are there similar limitations with log shipping Does anyone have any experience of mirroring and is using it in prefence to log shipping Our current recovery strategy is the classic restore the SQL dump from tape onto a rebuilt server so either method will be a vast improvement. None of our databases are mission critical that they ...Show All

• crino Dynamic view

  Is it possible to create dynamic sql views in Sql Server 2005 I have a requirement of having to change the Sql View depending on the user selection criteria. Is it possible Krutika wrote: Thanks. I cannot use stored procedure, any other option to programattically alter the view No. Well, you can use CASE statements in your view if that helps. Thanks. I cannot use stored procedure, any other option to programattically alter the view No, A "view" is always the same list of fields. Also, if you create a view which says: CREATE VIEW V_TABLEA AS SELECT * FROM TABLEA When you create the view, it caches the list of fields it is going to display. ...Show All

• moh hassan Bulk load from Access to SQL 2003

  I am trying to configure a bulk table upload from a 2003 Access table to a matching table in SQL with SSIS. I can configure the source file but am unable to configure the destination. When I configure the SQL source and use SQL Native Client I get an error message of: The selected connection manager uses an earlier version of a SQL server provider. Bulk insert requires a connection that uses a SQL server 2005 provider. When I go through the new connection setup I don't see any available provider named like that. I believe the SQL server I am loading to is a 2003 version. Thanks, that seemed to work to pull the table up. Pushing takes forever. try using the ole ...Show All

• mdschwarz Full-Text Search Problem When I Upgrade from SQL 2005 Express to Express Advanced Services

  Hi. I'm trying to get full-text search working on my SQL 2005 Express with Advanced Services and am having problems. I thought that I installed it correctly, and when I look in the services running, I see it SQL Server Fulltext Search(MSSQLSERVER). Also note that I have SQL Server 2005 Standard installed on this same laptop. I don't know if that Full text Search applies to the Standard, Express or both. What I do see is that if I connect to the database engine named <mylaptop>, I can see the version is 9.0.1399 and I can see the check box to enable full-text indexing in a particular databases properties. When I run SELECT FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'), I get a 1. However, when I connect to the engine name <m ...Show All

• JKountouroglou How do you search for textvalues with wildcards in xml?

  What I want to do is search for a text string inside a xml tag using my own wildcards. For example: The following xml is stored in a column in the database. < MetaData > < MetaFields > < MetaField Id = " 20 " Key = " x " > erwrw </ MetaField > < MetaField Id = " 23 " Key = " x " > Foxvalue </ MetaField > < MetaField Id = " 24 " Key = " x " > adsas </ MetaField> < MetaField Id = " 25 " Key = " x " > Varde1 </ MetaField > </ MetaFields > </ MetaData > How can I search the xml to see if any of the /MetaData/MetaFields/MetaField values contains Fox* In xquery there is ...Show All

• Ronbb accessing result of sp_tables

  When I run exec sp_tables it give me a "list" of tables in databases. In fact the result is a table where one of the columns contains the database table names. It is no problem to access it in a client application but I need to access that column and verify existance of a certain table in SQL Server's user stored procedure . So far anything I tried did not work. FETCH pertains to a cursor and I cannot declare a cursor for this command. The only thing I got so far was @@ROWCOUNT but it is of no use for me. Perhaps there is another way to verify if a table exists from inside a stored procedure . I have the same problem in terms of verifying existence of a user stored procedure from inside another user stored procedure but if I g ...Show All

• ramkanna Enter Data in a mask format

  sorry for my question, maybe it seems un professional but I need to know the answer, is it possible to enter the data in a sql table in a specific format and how it could be for example I want to have a mask in the table to enter the data in this format ##.## so it will not accept any other data to be typed in without this format. Regards I totally agree with joeydj's comments. Based on the description of your initial question, my answer would have been to use CHECK CONSTRAINT. Based on your second message, I would recommend to do your checking/formating on the application (front end) where the user is entering the data.       Those were just examples tha ...Show All

• m_umair_85 Unable to Access SQL Server 2005 Remotedly

  Not sure if this is the right forum to post this... After going through lot of old posts in various forums and changing lot of settings, i'm still not able to access my Server remotely. This is Windows 2003 Server machine with Sonicwall Firewall, i have allowed Port 1433 in both Firewall and ISA and call is getting through but i'm getting following error msg :- {"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 does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"} This machine is also having Sql Server 2000, and ...Show All

• gebers rsAccessDeniedToSecureData

  I've installed a fresh load of SQL Server 2005 onto a Windows 2000 server, including all the trimmings with SS2005. Reporting Services 2005 is the main thing I want to initially check out, but I can't get it to work. In the 'Reporting Services Configuration' it shows the 'Web Service Identity' as a blank grey box which can not be edited. I can't help but think this might be where the issue is. I looked at this thread, as it describes the exact same problem, but the solution did not work for me. The RS service will start up, but then when I navigate to http://localhost/reportserver or http://localhost/reports it gives me the following error: Reporting Services Error They allready had access. Thank you for all your replies on this Teo. ...Show All

• fender46 HTML Rendering Wont Finish

  I seem to be having issues with the HTML rendering in the report manager. i am running a particularly large report but not an enormous one and the report seems to run for about 30mins before the screen goes to a page not found error. i have looked in the execution log which says that the report has completed and i have also run a profile on the report to see how it is working and all seems ok apart from right at the end the report chunk snapshot seems to get cleared out before it is displayed to the screen. The server it is running on is a dual processor dual core, with 8gb of ram. Thanks my msn is measlescar@msn.com if anyone can help please contact me ...Show All

• JohnDB sp_executesql From App's Dynamic SQL Causing Performance Problems vs. Query From SSMS

  Okay, so I came across an odd performance issue that I'm wondering if some guru can help me out with. I have a query that uses a paging algorithm that uses a paging algorithm and a table variable, then gets a page of data based on a join to that table variable. Here's a simplified query using the algoritm: --declare table variable... not shown for brevity --make sure we only store the least amount of records possible SET ROWCOUNT ( @pageNumber + 1 ) * @pageSize --insert into table variable INSERT INTO @TableVariable( Key ) SELECT key FROM table WHERE whatever = @p1 --we only want one page of data SET ROWCOUNT @pageSize --now get the page of data from the table SELECT key FROM table WHERE whatever = @p1 AND [Table ...Show All

• Docpro777 Executing Stored Procedure with Variables

  I have a foreach loop in my SSIS script. I am able to successfully enumerate through an input query. I have a script task inside of my container. I would like to use this task to formulate a Stored Procedure and save this procedrue in a variable so I can use in a future Execute SQL task. Here is a copy of the code (Which Does Not Work) I am using in the script task to set the variables. Public Sub Main() Dim vars As Variables Dim DropVariable As String Dim CreateVariable As String Dim InsertVariable As String DropVariable = "Execute dbo.[sp_DropTable] '" + RTrim(Dts.Variables( "varTable" ).Value.ToString) + "'" CreateVariable = "Execute dbo.[sp_Custom ...Show All

• jklegseth Visual Studio VS ReportBuilder problem

  Hi ! We have made a lot of reports using Visual Studio. Now some of our client would like to customize those reports. We have install ReportBuilder on their server to allow them to create their own reports. Everything is working fine when they are trying to create new reports. The problem is when they are trying to customize reports that we have made using Visual Studio. When they are trying to open those reports in ReportBuilder they get this Error: One or more unexpected Report Definition Language (RDL) elements of the following type have been removed: DataSet Microsoft.ReportingServices.ReportBuilder.ReportModel.Report: System.Web.Services.Protocols.SoapException: The operation you are attempting on item "/Data Sources/DataSou ...Show All