View Complete Post
We have couple of tables with prefix as "TEMP, something like this:-
We are assuming this temp tables are been created inside the store procedure t-sql and by mistake developer's hasn't writing drop table statement at the end of the sp.
So we need to figure out which sp procedure is using above mentioned tables?
Can anybody help me how to search for sp t-sql statement all together at database level?
Is this possible?
Backup made at 10:30
changes made in system
Tail of the log backup taken at 10:35
Restore to point in tim 10:33
At this point I get the error System.data.sqlclient.sqlerror: The File "sysft_yadayada_1" was not fully restored by a database or file restore. The entire file must be successfully restored before applying this backup set.
BUT when I restore the database to most recent possible I have no issues..
when I do a select * from sys.master_files sysft_yadayada_1 does not exist in that list, but sysft_yadayada_5 does... When we were initially configuring fulltext search for this application we had a couple hiccups first till we got
it working and thats the filename that ended up sticking.
I have set up a mysql connection in visual studio 2010 and now i have a connection and dont really know where to go next.
I want to be able to search the data and get the result in a view.
using asp.net mvc
I'm working on a library that stores information on various cases. The case table has several columns that contain descriptive strings on what happened in the case. I would like to create a single filter that returns all cases where the search string is found in any of the columns. I've looked at Dynamic Data Filtering, but as far as I can tell, the "Contains" filter only allows you to connect to each column individually. Has anyone tried this?
ÃÂ IÃÂ´m currently programming a web search application in ASP.Net and having problem with full text searching. My requirements are:
1. Save a byte array from SQL server to word document as a temp file in a server side?
2. How to highlight the string I am currently searching in the Word document and return to the user the sentence with the highlighted string (like on Bing or any other search engines)? Is it possible to fullfill this requirement with full-text search integrated in SQL Server 2008?
Thanks in advance,Regards,
I've got a site 'B' created under site 'A' in SharePoint. When I'm at Site A, I can search and find things that exist in both A&B. However, when I'm in B, the 'highest' search scope I can pick is 'B.' I'd like to be able to select one step higher so
that I can search A&B from any page. Is this possible?
We have a document library on a site created off of the Report Center site template. We uploaded a Word 2007 document with the word zebra in the text. Using the search bar at the top of the page we selected This list: Our document library and searched for
zebra. We received no results.
We tested the same thing on another site (site template Team site) within the same site collection and search worked fine.
Does the Report Center search function differently then the search functionality on the Team site?
I have a requirement to import the profile properties from a text file in sFTP to update the MOSS Profile Database. The objective is to create a single repository for the Staff Directory in MOSS.
Can I use BDC to connect and update the Profile database?
What is the alternate approach?
I have created procedure for full-text search and it works in SQL Management Studio 2008 (SQL Server 2008 Express) but in Visual Studio 2010 not - I have error:
Full-Text Search is not installed, or a full-text component cannot be loaded.
I have read somewhere that only admin can use full-text indexes - so how I can use full-text search in VS2010 ?