OPENROWSET Error

SQL Server Data Access

Index ‹ SQL Server

- Previous
  - 1
    - how to define calculation for this scenario? Now, we just added the com flag attributes in fact table but this expression still doesn't work. This calc only returns a net sale dollars from each store which is comp store and it returns a 0.00$ right now in cube. IIF ([Measures].[Comp Flag]= False , 0 ,[Measures].[Net Sale Dollars]) Any suggestions Tag: OPENROWSET Error
  - 2
    - Trigger data corruption Arnie, thanks for the response. I had errantly erased the alias on the deleted table when cleaning up the sql for display here, as there are some joins there that should be irrelevant. Running your example did not cause the issue, so I have a feeling its something tied to the data that's there. That said, I have tried re-typing the data that is in there exactly, and it still gives the error. Tag: OPENROWSET Error
  - 3
    - Comparing Rows in a table Here is a mockup. I sprayed 32767 records out over 43 days going backwards from 3/20/7 using an iterator table and a scalar RAND udf. These two items can be found on this page: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1330536&SiteID=1 Here is the mockup. I have not yet evaluated whether or not this is efficient. Stand by; another post will follow.. declare @mockup table ( rowid integer, aDateTime datetime, unique (aDateTime, rowId) ) insert into @mockup select iter, cast ('3/20/7' as datetime) - 43 * dbo.rand() as aDateTime from small_iterator --select * from @mockup select rowId, aDateTime, nextDateTime, convert (varchar(12), nextDateTime - aDateTime, 108) as [Time Difference] from ( select rowId, aDatetime, ( select top 1 b.aDateTime from @mockup b where b.aDateTime > a.aDateTime order by aDateTime, rowId ) as nextDatetime from @mockup a ) x where nextDateTime - aDateTime >= cast(cast ('0:15:00' as datetime) as float) -- rowId aDateTime nextDateTime -- ------- ----------------------- ----------------------- ------------ -- 23623 2007-02-11 09:51:57.530 2007-02-11 10:07:25.077 00:15:27 -- 12068 2007-02-12 11:46:03.190 2007-02-12 12:01:25.987 00:15:22 -- 14377 2007-02-14 03:17:02.890 2007-02-14 03:32:39.907 00:15:37 -- ... -- 30564 2007-03-17 04:32:18.287 2007-03-17 04:48:51.520 00:16:33 -- 9053 2007-03-18 21:07:15.663 2007-03-18 21:22:21.220 00:15:05 Oh yeah: I didn't perform a self join; this looked better. Sorry, I am in the middle of a restore. OK! This puppy doesn't look too bad: With this index I am getting a plan of index scan / index seek. To process the entire 32767 records, the IO is: -- Table '#401BB779'. Scan count 32768, logical reads 65746, physical reads 0, read-ahead reads 0. That's pretty good. You might be able to find a better way to do this, but this is at least pretty good. REMEMBER! It is CRITICAL that the date/time column has an index! Otherwise you are NOT going to be able to search by index seek. Tag: OPENROWSET Error
  - 4
    - Refresh a windows form without closing it You need to re-fill the dataset. If you are using a table adapter, it would be like the following: Code Snippet Me .MyTableAdapter.Fill( Me .MyDataSet.MyTable) If you look in the Form_Load event, this is usually where the code is located that will load your data. You can simply copy those steps into the ToolStipButton1_Click event. Once the dataset has been re-filled, use Me.Refresh() to refresh the form. If that doesn't make sense, could you post the code that you are using to load the data into your form Tag: OPENROWSET Error
  - 5
    - Reporting error Hi, How i can hide the "error: Subreport could not be shown" message when record set returns null. In debug window actual error is : [rsRuntimeErrorInExpression] The Value expression for the textbox ‘textbox6’ contains an error: The query returned no rows for the data set. The expression therefore evaluates to null. Many thanks soha; Tag: OPENROWSET Error
  - 6
    - restoring a sql 2000 db in sql 2005 express db with sql server management studio express As I said in the subject I've a problem trying to restore a backup of a previous db created in sql 2000 server When I try to do it I recive the following message: ____________________________________________________________________________________ System.Data.SqlClient.SqlError: Il set di backup include il backup di un database diverso dal database 'musica2007' esistente. (Microsoft.SqlServer.Express.Smo) ------------------------------ For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476 ------------------------------ Program Location: in Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQueryWithMessage(StringCollection queries, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages) in Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries) in Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv) ____________________________________________________________________________________ What should I do What's the probem I've already tried to look for the solution in other messages but I didn't find anything..... Thanks for help,,, by Luke Tag: OPENROWSET Error
  - 7
    - Strange exception - Batch update I have answered your other question. There is not enough info here to debug this issue. Can you create an isolated full repro for this issue Tag: OPENROWSET Error
  - 8
    - SQL Server 2005 Express edition: SQL Server service failed to start during install. In the last step of installing the SQL Server 2005 Express edition I get the following error: Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Jun 21 19:38:35 2007 Service MSSQL$SQLEXPRESS with parameters '-d"c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data\master.mdf" -l"c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data\mastlog.ldf" -m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 21 19:38:35 2007 Service failed unexpectedly (1814) Error Code: 0x80070716 (1814) Windows Error Text: The specified resource name cannot be found in the image file. Source File Name: sqlsetuplib\service.cpp Compiler Timestamp: Wed Jun 14 16:29:04 2006 Function Name: sqls ervice tart Source Line Number: 301 ---- Context ----------------------------------------------- Do_sqlScript SqlScriptHlpr Start service MSSQL$SQLEXPRESS Error Code: 1814 MSI (s) (80!08) [19:39:58:265]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1814) The specified resource name cannot be found in the image file. . Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1814) The specified resource name cannot be found in the image file. . <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Jun 21 19:39:58 2007 Service MSSQL$SQLEXPRESS with parameters '-d"c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data\master.mdf" -l"c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data\mastlog.ldf" -m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 21 19:39:58 2007 Service failed unexpectedly (1814) Error Code: 0x80070716 (1814) Windows Error Text: The specified resource name cannot be found in the image file. Source File Name: sqlsetuplib\service.cpp Compiler Timestamp: Wed Jun 14 16:29:04 2006 Function Name: sqls ervice tart Source Line Number: 301 Any idea how I can fix this Tag: OPENROWSET Error
  - 9
    - Memory Error on AS Backup The error message talks about memory shortage and not about not having enough hard drive space. Several ideas. If you have any other operations going on at the same as backup, that could be a cause of the error. See what is memory consumption on the server before you execute backup command. Try to resycle your server before executing the backup command. If nothing helps and you still getting an error contact product support services and report your problem. Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. Tag: OPENROWSET Error
  - 10
    - Error: fcb::close-flush: Operating system error 21(The device is not ready.) encountered Based on this and what you describe in your other post, you really ought to give Microsoft PSS a call. Tag: OPENROWSET Error
  - 11
    - Call Web Service From Script Task To call a web service from a script task, you need to create a wrapper assembly in Visual Studio first for the web service. Then you can add a reference to the wrapper assembly in the script task. This has an example of calling the Reporting Services web service from a script task: http://mgarner.wordpress.com/2007/06/06/consuming-the-reporting-services-web-service-inside-ssis/ Tag: OPENROWSET Error
  - 12
    - Invalid character value for cast specification I think the error is quite clear, you know what it means, so now, break it down and work out what the value is that cannot be converted. Use the Error output as a start, it allows you to determine which column is failing. Using a data viewer on the error output is a quick way of finding out the data values. You can then review the data value and the target data type and see what is wrong. http://msdn2.microsoft.com/en-us/library/ms166707.aspx Tag: OPENROWSET Error
  - 13
    - Change the schema of a mirrored database any changes you make in the principal database will get reflected just check and see by creating database snapshot........ Tag: OPENROWSET Error
  - 14
    - SPLIT AN ARRAY! Hi, http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=326300&SiteID=1 HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Tag: OPENROWSET Error
  - 15
    - Performance Problems It could help us if we see the query plan, so go ahead if you wish to show it. WesleyB Visit my SQL Server weblog @ http://dis4ea.blogspot.com Tag: OPENROWSET Error
  - 16
    - Query based Textbox Not working...I can not select a Dataset for the textbox Any other ideas Tag: OPENROWSET Error
- Next
  - 1
    - Reporting services configuration NO initialization I am installing sql server 2005 reporting services on server running sql server 2005. I get to the reporting services configuration page and configure... report server virtual directory report manager virtual directory windows service identity web service identity database setup encryption keys when I get to Initialization the button is grey and inactive so I can't initialize reporting services, Do I need to restart server Tag: OPENROWSET Error
  - 2
    - SQL Server 2005 and DTC enabling on 2k Server I had almost the same problem, I found very good msdn article for troubleshooting problems with MSDTS. This will help you to identify and possible to fix a problem you have. link: http://msdn2.microsoft.com/en-us/library/aa561924.aspx Tag: OPENROWSET Error
  - 3
    - recursive calculated measure With that kind of complexity, I would definetely see if you could handle the bulk of the calculation in the SQL environment. You may not be able to calculate the whole value but you want to get it to a state where simple aggregations or a relatively simple expression would give you the value you need. B. Tag: OPENROWSET Error
  - 4
    - DataPort Wizard from PrimeWorks Hi, Just to say that I was using the Data Port Wizard to convert MDB to SDF and back, and it has worked perfectly! I highly recommend it to others that have the same need. Just make sure to be using SQL CE 3.1 Try a look at http://www.primeworks-mobile.com/ it's worth a visit! Tag: OPENROWSET Error
  - 5
    - searching for a word in a text file and retuning it using script taks in ssis does any one how to search for a word in a text file and return it back using the script task in ssis the file may contain data like this POSITION SMSMSS20051230000 S ,,751600 ,,20051110,,20051230,20051230 S ,,751600 ,,20051110,,20051230,20051230 S ,,751600 ,,20051110,,20051230,20051230 S ,,751600 ,,20051110,,20051230,20051230 S ,,751600 ,,20051110,,20051230,20051230 what i am looking for is to be able to parse and get the date which is present in the first line "POSITION SMSMSS20051230000" as "20051230" and then return that as a variable .. Thanks for any help in advance smathew Tag: OPENROWSET Error
  - 6
    - Is it possible to restore from a database backup without a transaction log backup? You dont need Tran log backup to restore the db if you have full backup you can restore the db, the only difference is that using tran log backup provides point in time recovery and hence the data loss is minimised if you have tran log backup. Perform as below, 1. Restore database Yourdbname With Recovery (Execute this command) 2. Now try to restore your full backup. Regards Deepak Tag: OPENROWSET Error
  - 7
    - Query to get rows which match with all given values No, it's not possible. And to complicate the problem, this query will be created in a stored procedure. The specific score to search will be passed in argument to the sp. For that, no problem, I can do it. And I will insert these score into a temporary table (data type). I tried to use the " = all " but I'm not sure it's the right solution. Tag: OPENROWSET Error
  - 8
    - SQL server 2005 snapshort agent problem I have a SQL server 2005, and created a replication function. when I run the snapshort agent, I found the opration will run the sys.sp_MSsetup_partition_groups, but need a long time, and can't stop it, I don't know what is the problem about the snapshort agent, and sys.sp_MSsetup_partition_groups is running for what Tag: OPENROWSET Error
  - 9
    - Unable to connect to sqlserver 2000 from Sqlserver2005 Hi, iam having vs2005 installed on my machine and i also installed sqlserver2005 dev edition on my machine...Unable to connect to Sqlserver 2000 which is installed remotely ....Sqlserver2000 is dev edition.i cudnot find Sqlserver2000 instance when i try to search for Network database engine name ....... I feel to know how to enable remote connection on Sqlserver 2000.So tht i can access this sqlserver2000 from another machine Tag: OPENROWSET Error
  - 10
    - processing cube not pumping data OK! You are using named queries in the DSV. Does everything work correctly if you use tables or views I am not sure if your named queries never work or work sometimes. The next thing i would check in the DSV is that you have correct foreign(logical) keys in the DSV between the dimensions(named queries) and the fact table(named query). Also check that the same relations are defined within the cube, in the dimension usage tab in BIDS. Last. Can you have a problem with that the named queries in the dimensions do not have the same members as the dimension keys in the fact table. If you have time members only for 2006 in the time dimension but only fact records for 2005 Regards Thomas Ivarsson Tag: OPENROWSET Error
  - 11
    - Trouble Installing Reporting Add-In for Microsoft Visual Web Developer 2005 Express I got the same problem here. Can anyone solve this Please help!!!! Tag: OPENROWSET Error
  - 12
    - xquery query path without elements Does the following query give you the result your are looking for Code Snippet SELECT Name , Demographics . query ( 'declare namespace AWMI="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey"; string((AWMI:StoreSurvey/AWMI:AnnualSales)[1])' ) As Result FROM Sales . Store WHERE Demographics . exist ( ' declare namespace AWMI="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey"; /AWMI:StoreSurvey[AWMI:AnnualSales ge 800001]' ) = 1 ; Tag: OPENROWSET Error
  - 13
    - Hotfix for Bug # 473675 (SQL Server could not spawn process_loginread thread) The most common cause of this message is a lack of free virtual address space. The most common cause of virtual address starvation on SQL 2000 are misbehaving com components from the use of sp_oacreate, misbehaving extended stored procedures, or poorly written OLEDB providers that are loaded by the use of linked servers. Start by reviewing your use of these items and remove them from the system as possible. Tag: OPENROWSET Error
  - 14
    - EXEC in WHERE clause I wanted to have something like SELECT * FROM refs1 WHERE (EXEC ref_id) = this.id Should I turn the SP into a function Tag: OPENROWSET Error
  - 15
    - Linkserver connection fails between SqlServer 2005 and Oracle 10g Oracle's provider should be OraOLEDB.Oracle. Have a look at http://msdn2.microsoft.com/en-us/library/ms152516(SQL.90).aspx and the other links referred from there. Tag: OPENROWSET Error
  - 16
    - OUTPUT - help with please ...and Manivannan prove it Tag: OPENROWSET Error

dgolds

I am trying to execute the following ad-hoc query (I have already configured the remote server to allow ad-hoc queries):

--EXECUTE AS USER = suser_name()
SELECT c.*
INTO #MyTempTable
FROM OPENROWSET('SQLNCLI', 'Server=MyRemoteServer;Trusted_Connection=yes;',
'select * from mydb..mytable (nolock)
where PurchaseOrderID in (''19509114'', ''24075854'')) AS c;

I receive the following error message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

I have admin privileges on the remote box-how can I get this to execute in the context of my account rather than this NT AUTHORITY\ANONYMOUS LOGON account

Thanks,
-Dave

Re: OPENROWSET Error

Jens K. Suessmeyer

Hi,

being logged in with a SQL Server account wont’make it possible for SQL Server to impersonate you at the other end. Do you use WIndows Authentication on your query issuing connection (i guess not)

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

Re: OPENROWSET Error

dgolds

Actually, I am using Windows Authentication. None of our servers are configured to even allow mixed or SQL Authentication.

Thanks,

-Dave