Tuesday, June 4, 2013

[SQL 2012] Full Text - Confused

[SQL 2012] Full Text - Confused

Full Text - Confused

Posted: 04 Jun 2013 01:17 AM PDT

We implemented Fulltext on our system. No customization, no added stoplist. We turned off Stoplist on the FT Index.I have a data column that contains the following text "Point 5 CAD" defined nvarchar(255). We dont understand if we do [code="sql"]select * from Table where contains(column,'"Point" and "5" and "CAD"')[/code] we get no resultsif we do [code="sql"]select * from Table where contains(column,'"Point 5 CAD"')[/code] - we get rows returnedif we do [code="sql"]select * from Table where contains(column,'"Point 5 cad"')[/code] - we get no rows returned

Update Statistics Maintenance Plan

Posted: 03 Jun 2013 05:59 PM PDT

Hi AllI am using SQL 2012 SP1I have set up an update statistics maintenance plan to update the stats on all tables in my database - The job seems to be stuck at the beginning phase of the maintenance, this is where it queries the tables - It's been there for 10 hours and hasn't even got to the part where it actually updates any stats.I'm not seeing any waitsHas anyone else seen this before?Thanks

SQL 2012 SSIS execution via stored procedure

Posted: 08 May 2012 01:50 AM PDT

I have a SSIS package that I am try to execute via the stored procedures found in SSISDB.Here is my T-SQL:[code="plain"]DECLARE @execution_id BIGINTEXEC [SSISDB].[catalog].[create_execution] @package_name = N'PackageName.dtsx' , @execution_id = @execution_id OUTPUT , @folder_name = N'FolderName' , @project_name = N'ProjectName' , @use32bitruntime = False , @reference_id = NULLSELECT @execution_idDECLARE @var0 SMALLINT = 1EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id , @object_type = 50 , @parameter_name = N'LOGGING_LEVEL' , @parameter_value = @var0EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id , @object_type = 50 , @parameter_name = N'SYNCHRONIZED' , @parameter_value = 1EXEC [SSISDB].[catalog].[start_execution] @execution_idGO[/code]It says that it executes successfully, but when we check the tables where we are expecting the new records to be there is nothing. Although, if we just run the package via SSDT, all the records are there.Am I missing something stupid? We have tried calling this code from within our web app, and via SSMS, but niether "work".I am running SQL 2012 (obviously), I have granted the test user (that is calling the package) Read, Modify, Execute, and Manage Permissions on the Project, as well as Read, Execute Objects, and Read Objects on the Folder. These didn't help, the user continually got this message:[quote]Msg 27146, Level 16, State 1, Procedure create_execution, Line 167Cannot access the package or the package does not exist. Verify that the package exists and that the user has permissions to it.[/quote]Not until I added the user to the SSIS_Admin role was he able to execute the code, which as stated just returned that it was successful.Thanks in advance for you help.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog