Tuesday, June 25, 2013

[MS SQL Server] Linked Server - Missing Feature "Provider Options"

[MS SQL Server] Linked Server - Missing Feature "Provider Options"

Linked Server - Missing Feature "Provider Options"

Posted: 25 Jun 2013 03:01 AM PDT

I see references to changing setting on the "Provider Options" page, but on my 2005 and 2008 servers, I don;t see that option. I have "General", "Security" and "Server Options". Where are these "Provider Options" they speak of ? What am I missing ? I have 2005 SP4, and 2008 R0

Sql Server doesn't use the right index

Posted: 25 Jun 2013 01:13 AM PDT

Hello,I've a strange issue with an index. I discover the sql have not used the right index last week.This's my SQL code:SELECT -- type 'C ' AS [type], -- item RTRIM([models].[mode]) + '@' + RTRIM([skus].[grid]) AS [item] , -- ware 'PFG0' AS [ware], -- duedate LEFT([dbo].[get_date_fmt]([commessa_C_excp].[duedate],'GGMMAA',NULL),6) AS [duedate], -- outflow 0 AS [outflow], -- backorder [PRODSTARTS].[maxqm] AS [backorder], -- mingrossreq 0 AS [mingrossreq], -- maxgrossreq [commessa_C_excp].[maxgrossreq] AS [maxgrossreq] INTO #COMM_C_EXCP FROM [commessa_C_excp] INNER JOIN [skus] ON([skus].[id] = [commessa_C_excp].[sku_id]) INNER JOIN [models] ON([models].[id] = [skus].[mode_id]) INNER JOIN [fitcode] ON([fitcode].[id] = [skus].[fitcode_id]) INNER JOIN [prod_starts] [PRODSTARTS] -- -- -- WITH (INDEX(MI_prod_starts_linea_id_tipo_id_cod_rel_id_fitgrp_id_year)) -- -- -- ON([PRODSTARTS].[linea_id] = [models].[linea_id] AND [PRODSTARTS].[tipo_art_id] = [dbo].[tipo_id_std]([models].[tipo_id]) AND [PRODSTARTS].[cod_rel_id] = [dbo].[get_release_id]([skus].[id]) AND [PRODSTARTS].[fitgrp_id] = [fitcode].[fitgrp_id] AND [PRODSTARTS].[year] = YEAR([dbo].[skus_min_drel]([skus].[id])) )GOI'm forcing the select to use the index now, the problem is I don't understand why it stopped to use it.I try to rebuild it but no change.Best RegardsMarco

sql job showing wrong execution time in job's history

Posted: 25 Jun 2013 01:43 AM PDT

hi i have a sql server 2008 r2 instance, after checking a few of my sql agent jobs, i see the last execution time being in the future. today's date is 6/24/13 and is showing it last executed on 6/28/13. i ran one of these job's manually and then it shows correct current time. I also checked server's time and it shows correct current time. I also checked the following: SELECT SYSDATETIME(), SYSDATETIMEOFFSET(), SYSUTCDATETIME(), CURRENT_TIMESTAMP, GETDATE(), GETUTCDATE() and they show the correct current time. Can anyone help?

Restore a development DB form Prod.

Posted: 24 Jun 2013 10:09 AM PDT

I'm trying to restore a development DB form Prod.I get an error on the Log file but it is a valid path.I do not get it.Any help would be greatly appreciated.[code="plain"]RESTORE DATABASE CypressFROM DISK = 'I:\Backups\CYP_DW\Full\MyDBDW\MyDBDW_backup_2013_06_24_163430_3276765.bak'--WITH REPLACE,WITH NORECOVERY,MOVE 'MyDBDW' TO 'E:\MSSQL\Data\MyDBDW.mdf',MOVE 'MyDBDW_Horizon' TO 'E:\MSSQL\Data\MyDBDW_HorizonObjects1.NDF',MOVE 'MyDBDW_log' TO 'E\MSSQL\Log\MyDBDW.ldf'Msg 5105, Level 16, State 2, Line 1A file activation error occurred. The physical file name 'E\MSSQL\Log\MyDBDW_New.ldf' may be incorrect. Diagnose and correct additional errors, and retry the operation.Msg 3156, Level 16, State 3, Line 1File 'MyDBDW_log' cannot be restored to 'E\MSSQL\Log\MyDBDW_New.ldf'. Use WITH MOVE to identify a valid location for the file.Msg 3119, Level 16, State 1, Line 1Problems were identified while planning for the RESTORE statement. Previous messages provide details.Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally.[/code]

Licensing standalone SSRS (2008 R2 or 20012)

Posted: 24 Jun 2013 09:16 AM PDT

Hi GuysWe currently run 2008 R2 and SSRS (not sharepoint) on a 4 core VM, so license is around $8K. We have more and more needs for data driven subscriptions, but can't justify upgrading to enterprise version on 4 core machine ($28k). I was thinking that spinning up a dedicated VM for SSRS with a single core and running enterprise version of SQL Server would get us what we need fro about $8K (SQL and WIn licenses) -- we have enough RAMI've read that having SSRS on a dedicated box improves performance too.So would this work if we offloaded all of our SSRS to a new single core VM? Can you buy just an Enterprise SSRS licenses or must you always buy it with SQL server?I've scoured the web, but couldn't find an answerBTW, we own SQL2012 licenses, can't use it yet because of 3rd part app compatibility, but I figured if we went this route we could use some of the new features of SSRS 2012 with 2008 R2 data sourcesThanksMark

Error Restoring Database

Posted: 24 Jun 2013 11:09 AM PDT

I execute the following:[code="plain"]FROM DISK = 'I:\Backups\CYP_DW\Full\MyDBDW\MyDBDW_backup_2013_06_24_163430_3276765.bak'WITH RECOVERY,MOVE 'MyDBStaging' TO 'E:\MSSQL\Data\MyDBStaging.mdf',MOVE 'MyDBStaging_log' TO 'E:\MSSQL\Log\MyDBStaging.ldf',REPLACE[/code]RESTORE DATABASE MyDBStagingI get the following error. I'm not trying to create the DB on but on E?[code="plain"]Msg 3257, Level 16, State 1, Line 2There is insufficient free space on disk volume 'D:\' to create the database. The database requires 216796037120 additional free bytes, while only 160890318848 bytes are available.Msg 3119, Level 16, State 4, Line 2Problems were identified while planning for the RESTORE statement. Previous messages provide details.Msg 3013, Level 16, State 1, Line 2RESTORE DATABASE is terminating abnormally.[/code]
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog