Answer Questions

• Paul Bradley How do I break a sql column in to three? please help!!!!!

  I have a column look like this Name ---------------------- John^Smith^P^^^^ Peter^Johnson^M^^^^ Joe^Tedone^^^ I want to break this column in to three as follow FirstName LastName Middle ----------------- ----------------- ------------- John Smith P Peter Johnson M Joe Tedon '^' is the delimiter, how can I do this some one please help me out, thanks a million You need to also use a cross tab query: SELECT CASE WHEN THEN ELSE END AS [] Adamus Yeah, I didn't suggest this because he mostly deals with splitting it into rows, not columns. Please take a look at ...Show All

• Peter Haik Intermittent ole db error

  I have this problem occuring intermittently: When I try to add a package to the project, and click on the Package path button. I get a oledb error x080004005 (client unable to establish connection)... After I click ok, and click on the Package path again 2 or 3 times, the error goes away and I get the list of packages displayed. Some time I get an empty list box. Similar to this happens when I execute a package also. When I execute it 2nd or 3 rd time it works fine. The error happens only when I am trying to connect to the server\database. Once it is in the database I do not get any error message. This is what I have: I have sql 2005 installed. Microsoft SQL Server Management Studio ...Show All

• nadir looking into rdl file

  Some business analysts would like to reverse engineer the ssrs .rdl files by looking into the field mappings and data sources. Do they have to install the client version of visual studio or there is an easier way TIA.. You can open the RDL files in Notepad and see that they are written in XML. You can find the query run by looking for the <CommandText> tag, and each field is listed under a <ReportItems> tag. The data source information is also listed in there, under the <ConnectionProperties> tag. Hope this helps. Jarret ...Show All

• Warren13 Property DefaultSchema is not available for Database [DatabaseName]

  We're using Windows Authentication with our SQL Server.  We've added a domain group to the SQL Server groups and would like to give it a default schema.  The properties window is the same for users and groups but the default schema field is enable only for user entities.  We cannot add a default schema to a group.   Is this by design,  a bug or a problem with our SQL Server installation Updated on 2005/08/29 My first try was done at through Database\Security\Users.  I tried going through Server\Security\Logins and I got this error message    Alter failed for User 'Domain\Group'. (Microsoft.SqlServer.SMO)   Additional Information:   --> An exception occured while ...Show All

• arkiboys The Problem 800a0ea9 absolute recipe what ?

  Windows X64 - IIS6 The Problem 800a0ea9 absolute recipe what conn.asp <% set Bag = Server.CreateObject("adodb.connection") strConn = "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=" & Server.MapPath("db/vt.mdb") & ";" bag.open strConn %> ADODB.Connection error '800a0ea9' Provider is not specified and there is no designated default provider. /test/ vt. .asp , line 16 http://blogs.msdn.com/david.wang/archive/2005/09/23/HOWTO_Diagnose_one_cause_of_503_Service_Unavailable_on_IIS6.aspx Changing IIS6 to run W3WP.EXE as 32bit allows the 32bit ISAPI DLLs installed by .NET Framework 1.1 for ASP.NET to load and run inside of it. This is done by ...Show All

• LouA CREATE ENDPOINT failing with no errors

  I'm hoping someone can shed light on a problem. I'm running SQL under a service account on a Windows 2003 R2 SP1 machine. The machine is also a domain controller. When creating an end point I get back a success message and can view the endpoints in sys.http_endpoints. However, when using httpcfg query urlacl there are no end points registered with http.sys. Using IE to try and access the /SQL wsdl returns a 404. There is nothing in the event log or the sql logs about any failure. The same TSQL code works fine on a development server. I've added the code below but am guessing its a permissions problem. I've followed the instructions at http://msdn2.microsoft.com/en-us/library/ms184379.aspx including SPN registration for the ...Show All

• PMNJ Error calling CreateReportHistorySnapshot method.

  Hello, I am getting an error when calling the CreateReportHistorySnapshot method from a custom assembly. The error is: Response is not well-formed XML. The data source is an XML file which is updated by the custom assembly before the call into the CreateReportHistorySnapshot method. Has anyone seen this problem before or have any suggestions The Data Source XML is well-formed by the way... :-0) I have had this error before when i wasnt the db admin. it seems there are a few errors along these lines where error messages flag up issues which are actually unrelated. Try Permission and i would assume this will fix your error. Andy The user that is running the createsnapsho ...Show All

• Shankar.S InfoPath 2003 - insert data in SQLServer??

  Hello, I created an InfoPath 2003 form, with a datasource from SqlServer 2000. When I try to insert a new record the follow error occurs: "InfoPath cannot connect to the data source. Safety settings on this computer prohibit accessing a data source on another domain." I checked Enabled -"Access data source accross domains" from Security Settings -> Miscellaneous, but the error still appears. Have anyone any idea about this error Thanks. This seems like an InfoPath specific configuration issue. You may want to try re-posting (sorry, I couldn't find a forum to which I could simply move this post) your question to the InfoPath newsgroup at http://msdn.microsoft. ...Show All

• Etienne Meunier I am trying to schedule a job not to run on holidays in SQL server 2005.

  Hi, I want to schedule a job that runs daily but not on holidays and I am using SQL server 2005. Looking for some advice... thanks, Thanks for replying. I will try. Do you mean even in Saturdays and Sundays You can schedule a job to run between Monday to Friday on weekly basis, and for any additional holiday requirement you need to follow what is suggested above. as a variation on this theme, you could set up a seperate job that disables or enables jobs depending on whether a day is holiday or not. More risky, perhaps (if it doesn't run, then X jobs are not set correctly). Include an additional step in the job and check within a stored procedure against a vacation table (which ...Show All

• amendez Why Replication?

  Hi, all here, I really dont understand the use of replication in SQL Server 2005 database engine. My concern is: Replication is used for copy database objects. But we have already have backup, snapshot methods for that. I dont really see the advantages of using replication Thanks a lot in advance for any guidance and advices for that. With best regards, Yours sincerely, replication has its place. for instance, you have a need to keep the publisher and subscriber in sync at the almost real-time. also, you can do 2-way (i.e. merge/peer) replication which the data flows both direction. you can't really do that with backup & restore without a major downtime. Hi, oj, thanks a lot. With best regards, ...Show All

• Kursat Konak Error when deploying forms authentication sample

  Hello I'm trying to get the forms authentication sample working - I have followed the instructions given in the ReadMe that came with the samples. When I try to browse to localhost/reportserver (on the server), instead of seeing the logon page as expected, I get the following error message: An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. ...Show All

• NozFx Logging Query Messages From ExecuteSQL Task

  The ExecuteSQL task makes it easy to capture the resultset of a query or stored proc in a variable. But what about the messages that would normally appear in the Messages tab when running queries in Management Studio or Query Analyzer There must be a way to display and log rowcounts and other messages that a query normally produces.   Various package/task logging configrations haven't helped. I've read discussions about logging rowcounts in data flow tasks, but what about capturing messages in ExecuteSQL and other control flow tasks that run T-SQL   I only have enough time to dabble in this technology so I may be missing something obvious or approaching this incorrectly. Any sug ...Show All

• John Paul Cook AMO vs. ADOMD

  I use AMO to programmatically create a complete database with datasource, datasourceview, dimensions, and cubes. I also have a webservice that uses ADOMD.NET to retrieve metadata about those objects (for security purposes and also for .NET 1.1 applications). However, I notice that using ADOMD's GetSchemaDataSet only return certain metadata. For example, for a dimension, it doesn't return the DimensionID or other properties I am able to set with AMO. I want to use ADOMD.NET because it returns the metadata in XML format already. With AMO, I have to serialize the dimension object. Is there any other way to retrieve additional metadata for AMO objects > I assume I can just deserialize the xml to get the A ...Show All

• cmfairbank trigger

  Table1 has an update trigger. In query analyser I write an update query for table1. What is the query that allows me to see the trigger that gets run after the update query Thanks There is no direct 'way to see the trigger that gets run'. You can inspect the data before and after the UPDATE to verify the effect of the trigger. ...Show All

• Jeroen Alblas SP2 final this year ?

  Does anyone know if the final SP2 will be out this year Really need it for a production enviroment.... So when will it be ready for production We plan to test it this week the CTP - SP2 in a cluster 2005 SQL with no SP on it in our test environment. So we can't move this to production Will we not get any support from MS. Bruce brucehelp@yahoo.com I do not believe that a public statement about the RTM availability of SP2 for SQL Server 2005 has been released. However, I did find mention of the CTP2 release of SP2 located here: https://forums.microsoft.com/MSDN/ShowPost.aspx PostID=760644&SiteID=1 Based on that announcement, it can be assumed ...Show All