The above statement will work fine. But what if the user inputs H G Wells, or there is an entry in the DB as H G Wells? How can I make sure all his books are selected in any case.
I can think of a couple of ways of overcoming it, though I'm unsure what the overhead and the pros and cons are.
My question to the forum is: What is the best way of dealing with this situation?
Good day. I am wanting to author a function in the CRM DB. The function does not write to any tables or views in any way, but is a function to convert HTML into plain text - ie. a tag stripper. HTML in and clear text out. Could this cause a problem in the MSCRM DB?
I have an agent service account that works fine - the account that jobs run under.
I know it works fine because this is the same account all my SQL Backup jobs run under - without a hitch.
I also have a valid sql server account that I use for connection string logins when building packages -
that account works fine. I know it works fine because I can login to the SQL Server Manager with this account.
So, I build a package with the sql server account and password for the OLE DB connection manager in a package. All the package does is a simple query on a table and outputs to a flat file.
I create a job, with 'sa' as the owner. in step 1 I select SSIS package, run as SQL Agent Service Account, package source is file system and I point to the package. The package itself uses the sql server login account to execute.
If I run the package it works fine. I close the solution, someone else comes along and opens the solution - THEY CHANGE ABSOLUTELY NOTHING ABOUT THE LOGIN OR SQL AGENT SERVICE ACCOUNT, but apparently just the fact that they opened the solution and looked at the package, breaks the login. If they try to run the package, they get a login failure, whereas I did not. After they close it, it breaks for me as well. If they open the solution, open the connection manager, re-enter the sql login's password, the package works fine for them, until I come along and open the solution, then it is broken again.
This makes no sense to me. Why would an 'author' opening a solution impact the connection manager when ABOLUTELY NOTHING ABOUT THE CONNECTION MANAGER WAS CHANGED?!
Seems like a bug to me. Anyone seen something like this?
I would like to know what book is considered the best when it comes to optimizing SQL Server configurations and troubleshooting SQL Server problems encountered in the error log.
I would like to know what book is considered the best when it comes to optimizing SQL Server configurations and troubleshooting SQL Server problems encountered in the error log.
I have to buy two books for the MIS dept for sql server 2000. Which one do you recommend? We are still on sql 7.0 and migrating to 2000 soon. All developers have good experience with sql server 7.0.
Want something that gives you recommendation about better practices for performance issues for writing SPs.
I read all the reviews on amazon and b&N . It's confusing to choose only two.
Hi , i am new to certifications in general.. I would like to do the certification exam 70-431. However i want to study on my own instead of going to classes. what if i get the microsoft e-learning books or microsoft press books? will this be enough in helpnig me with the course requirements? what are the difference between the two e-learning and MS Press books?
I just started at a client's site and have found that the Books On Line has been removed (all other items are there in the program group instead of BOL). Is there a site at microsoft that mimicks BOL? (sybase has a 'sybooks on the web' which mimicks their 'Sybooks' product documentation.
Can anyone recommend books on SQL Server 7.0 Data Transformation Services? Looking to find info on importing data from a Sybase server to SQL server (need good examples). Thanks.
How do you use BOL? I've heard time again that there is much info in BOL but when i look at it it seems too brief and not detailed. I find it hard to find what i'm looking for anyway. How do you use it?
naresh writes "I would like to learn sql server 2000 and I do not have any programming experienc at all so how do i learn this programme. Do you have any suggestion or any basic books or materials you guys can refer to me
we are trying to build warehouse in our company its very small database but still. we have come to a point where we are able to pull reports from the database that we have created as OLTP which is truncated and reloading everyday . Now we have to stop doing that and just update the database and check for the changes in the existing data. Can anyone suggest ETL book/webcast/weblinks that could help me.
Could someone explain the difference between these 2 books besides the fact that one is geared towards the express edition. The SQL Programming book sounds more thorough than the Express Edition book.
I would be teaching an applied database course to buisness majorundergrads. I'm looking for a book that introduces database conceptsusing SQLServer as the database. I would really appreciate if you couldrecommend me a few such books.ThanksNemo
I am new to SSIS and wondered if there are any books around to learn in depth regarding SSIS and exampls for transformation to try and help me understand it better.
Hi All - I have come across the need to use a cube in AS 2005 for an application. Unfortunately this will be the first time writting an ASP.Net application which uses one. I was wondering if any of you had any good books or references that I could look at to get an idea of how I should approach this issue. Thanks in advance.
Can anybody suggest a couple of good books to use to prepare for the SQL Data Warehousing exam (70-019)? I'm starting to get ready for that exam to complete my MCDBA and was wondering if anybody had any good recommendations or those to stay away from.
Thanks for any help that you can provide in this matter.
Sorry if this has been posted before, but I performed a search on the archives and didn't find anything !
I have just been turned over a SQL 6.5 SP3 / NT 4.0 SP3 server that has several SQL errors in the event log. I need to find a good book to read/scan, so I can get up to speed on SQL.
Can anyone guide me to a place where I can download some Tutorials / Books (Not that new) covering Microsoft SQL 2000 essentials ? I tried to find here, but artices are too advanced for me.. I need something that covers the Basic and that could be used as a small reference/guide while I am learing...
I have a couple of years of light experience with SQL server. I'd like to start studying to take the SQL 2000 exams. I have a good test environment set up and I'm reading through the Books Online. Can anyone recommend a book or books that might be helpful for me? My end goal here is to pass the test in the near future, but I want to really learn SQL rather than just learn to pass the test.
