Management Studio -> Could Not Find Function xp_msver in library xplog70.dll

SQL Server Tools General

Index ‹ SQL Server

- Previous
  - 1
    - Creating Stored Procedure in SQLServer2005 Thank you all, I have found the Answer I wasnt understanding the complex syntax so i simply deleted it all and kept the Following CREATE PROCEDURE [dbo].[NCompOpp] AS BEGIN Select from opmgr where opmgr.rectype="OP" END my major problem is that there are slight difference between writing Stored Procedures in SQL Server 2000 and in SQL Server 2005 Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 2
    - Help with modifying a data source's query at runtime Please help figure out what is wrong with my code. The script is supposed to load a package (from file). The loaded package already has everything set up to run a query against a local server and output the results to an Excel file. The reason for the outer script is because I need to change the query based on a global variable. When the query changes, though, I think the existing dataflow Path is no longer valid, so I should remove it and re-create another one with the new input mappings. Here is my code, which runs and throws an exception at the AcquireConnections call. The error is Error: 0x2 at Script Task: The script threw an exception: Exception from HRESULT: 0xC020801B I pieced together this code from the examples in the online books, but I am not sure what to do. ' Microsoft SQL Server Integration Services Script Task ' Write scripts using Microsoft Visual Basic ' The ScriptMain class is the entry point of the Script Task. Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Runtime Imports Microsoft.SqlServer.Dts.Pipeline Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Public Class ScriptMain Public Sub Main() ' Dim app As Microsoft.SqlServer.Dts.Runtime.Application = New Application() Dim package As Microsoft.SqlServer.Dts.Runtime.Package = _ app.LoadPackage( "c:\systime\ExcelOut\ExcelOut\ExcelOutDo.dtsx" , Nothing ) Dim pkgVars As Variables = package.Variables Dim gsVar As Variable = pkgVars( "User::gsExcelFile" ) Dim currVars As Variables = Dts.Variables Console.WriteLine(Dts.Variables( "User::gsExcelFile" ).Value) gsVar.Value = Dts.Variables( "User::gsExcelFile" ).Value pkgVars( "User::gsQuery" ).Value = Dts.Variables( "User::gsQuery" ).Value pkgVars( "User::gsCreateTable" ).Value = Dts.Variables( "User::gsCreateTable" ).Value Dim e As Executable = package.Executables( "ExcelOutTask" ) Dim thMainPipe As Microsoft.SqlServer.Dts.Runtime.TaskHost = _ CType (e, Microsoft.SqlServer.Dts.Runtime.TaskHost) Dim dataFlowTask As MainPipe = CType (thMainPipe.InnerObject, MainPipe) ' Get the source component. Dim SourceComponent As IDTSComponentMetaData90 = _ dataFlowTask.ComponentMetaDataCollection( "Local Source" ) Dim srcDesignTime As CManagedComponentWrapper = SourceComponent.Instantiate() srcDesignTime.ProvideComponentProperties() ' Reinitialize the metadata. srcDesignTime.AcquireConnections(vbNull) srcDesignTime.ReinitializeMetaData() srcDesignTime.ReleaseConnections() ' Get the destination component. Dim destination As IDTSComponentMetaData90 = _ dataFlowTask.ComponentMetaDataCollection( "Excel Destination" ) Dim destDesignTime As CManagedComponentWrapper = destination.Instantiate() destDesignTime.ProvideComponentProperties() ' Create the path. dataFlowTask.PathCollection.RemoveAll() Dim path As IDTSPath90 = dataFlowTask.PathCollection.New() path.AttachPathAndPropagateNotifications(SourceComponent.OutputCollection(0), _ destination.InputCollection(0)) 'Console.WriteLine(dataFlowTask.PathCollection.Count) Dim ret As DTSExecResult ret = package.Execute() Console.WriteLine(ret.ToString) Dts.TaskResult = Dts.Results.Success End Sub End Class Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 3
    - Two Dimensions Sharing same Parent Table Dave, Thanks a lot Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 4
    - Can't shrink DB Finally managed to shrink the DB, I've noticed that every DBCC SHRINKFILE command shrinked the DB in about 4-5%, so I just executed the command few 10s of time and it shrank to ~200MB. Thanks, YP Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 5
    - Reporting services in SharePoint integration mode problems Hi, I'm having problems setting up Reporting Services in SharePoint Integration mode. The development environment works fine, but I can't get it to work in production. Problem seems to be in the authentication between SharePoint and Reporting Services. When I go to "Set Server Defaults" in the SharePoint central administration I get the following message: Code Snippet An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Net.WebException: The request failed with HTTP status 401: Unauthorized. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.SqlServer.ReportingServices2006.ReportingService2006.ListSecureMethods() at Microsoft.ReportingServices.SharePoint.Soap.ReportService2006.ListSecureMethods() --- End of inner exception stack trace --- I get the same message when trying to deploy a report from Visual Studio to a SharePoint lib. Some info: - SP apppool is running under domain account a - SSRS apppool is running under domain account b - SP uses NTLM authentication - SP and SSRS are running on different servers - SSRS Configuration shows all green checkmarks Things I tried: - Basic authentication instead of Windows Integrated on SSRS - NTLM only instead of Negotiate on SSRS - Settings SPN's for SSRS, didn't help - Checked NTFS rights on ReportingServer dir, were fine (Domain users have read/list) Does anyone have an idea about how to solve this Any help is appreciated. Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 6
    - Recursive Query Without Self-Referencing Structure I need a statement that can return a hierarchy of folders. There are a number of good articles out there describing how to do this in SQL 2005 with a Common Table Expression (CTE) that references itself under a UNION ALL. Yet every example I come across involves a self-referencing table. Unfortunately the architect of my project did not use that simple structure. Instead, we have a Folder table and Folder Properties table. Creating a child Folder involves adding a row in the Properties table that links to a parent. Here's the statement I came up with: WITH Folders (ID, ParentID, FolderName, FolderDepth) AS ( SELECT FOLDER_ID, NULL, FOLDER_NAME, 0 FROM ZZ_FOLDER WHERE FOLDER_ID = 1 UNION ALL SELECT F.FOLDER_ID, Folders.ID, F.FOLDER_NAME, Folders.FolderDepth + 1 FROM ZZ_FOLDER F INNER JOIN ZZ_FOLDER_PROP FP ON FP.FPROP_FOLDER_ID = F.FOLDER_ID WHERE FP.FPROP_LINK_ID = Folders.ID ) SELECT * FROM Folders The initial statement brings back the top of the folder structure. The recursive statement brings back Folder rows that have an entry in their Property rows for the parent. Yet when I try to execute this, I get: Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Folders.ID" could not be bound. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Folders.ID" could not be bound. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Folders.FolderDepth" could not be bound. It sounds like all the recursive references to the CTE are unavailable. What am I doing wrong Would welcome any suggestions, too. I realize this isn't a T-SQL specific question, more SQL in general, but I didn't see a more relevant forum. What follows are some tables/data to run the above statement against. -- Create Folder Tables CREATE TABLE ZZ_FOLDER ( FOLDER_ID INTEGER NOT NULL PRIMARY KEY, FOLDER_NAME VARCHAR(50)) CREATE TABLE ZZ_FOLDER_PROP ( FPROP_ID INTEGER NOT NULL PRIMARY KEY, FPROP_FOLDER_ID INTEGER NOT NULL, FPROP_LINK_TYPE VARCHAR(50), FPROP_LINK_ID INTEGER NOT NULL) GO -- Populate Folder Tables INSERT INTO ZZ_FOLDER VALUES (1, 'Top Level') INSERT INTO ZZ_FOLDER VALUES (2, 'Second Level A') INSERT INTO ZZ_FOLDER VALUES (3, 'Second Level B') INSERT INTO ZZ_FOLDER VALUES (4, 'Second Level C') INSERT INTO ZZ_FOLDER VALUES (5, 'Third Level A1') INSERT INTO ZZ_FOLDER VALUES (6, 'Third Level A2') INSERT INTO ZZ_FOLDER VALUES (7, 'Third Level A3') INSERT INTO ZZ_FOLDER VALUES (8, 'Third Level B1') INSERT INTO ZZ_FOLDER VALUES (9, 'Third Level C1') INSERT INTO ZZ_FOLDER VALUES (10, 'Third Level C2') INSERT INTO ZZ_FOLDER VALUES (11, 'Fourth Level A3A') INSERT INTO ZZ_FOLDER_PROP VALUES (1, 2, 'Folder', 1) INSERT INTO ZZ_FOLDER_PROP VALUES (2, 3, 'Folder', 1) INSERT INTO ZZ_FOLDER_PROP VALUES (3, 4, 'Folder', 1) INSERT INTO ZZ_FOLDER_PROP VALUES (4, 5, 'Folder', 2) INSERT INTO ZZ_FOLDER_PROP VALUES (5, 6, 'Folder', 2) INSERT INTO ZZ_FOLDER_PROP VALUES (6, 7, 'Folder', 2) INSERT INTO ZZ_FOLDER_PROP VALUES (7, 8, 'Folder', 3) INSERT INTO ZZ_FOLDER_PROP VALUES (8, 9, 'Folder', 4) INSERT INTO ZZ_FOLDER_PROP VALUES (9, 10, 'Folder', 4) INSERT INTO ZZ_FOLDER_PROP VALUES (10, 11, 'Folder', 7) GO /* Top Level Second Level A Third Level A1 Third Level A2 Third Level A3 Fourth Level A3A Second Level B Third Level B1 Second Level C Third Level C1 Third Level C2 */ Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 7
    - c# reusing parameters I have a select statement which requires numerous parameters. here is a snippet. SqlCommand cmd = new SqlCommand("SELECT this from MyTable WHERE Answer1 = @Att 1AND Answer2 = @Att2 AND Answer3 = @Att3", connection) my parameters are added as follows. SqlParameter Att1 = new SqlParameter("@Att1", SqlDbType.VarChar, 50); Att1.Value = Attributes1; cmd.Parameters.Add(Att1); and so on... What I would like to do is be able to remove a parameter and re-run the SELECT statement if the number of entries retrieved is less than 5 (or any number) I tried just having a new Sql command like this. SqlCommand cmd2 = new SqlCommand("SELECT this from MyTable WHERE Answer1 = @Att 1AND Answer2 = @Att2, connection) and then did this.. cmd2.Parameters.Add(Att1); but it didn't work. Is there a way to do this so I don't have to keep copying the whole parameter command Thank you in advance for your help. And please be gentle, I'm very new to this. Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 8
    - allocation problem/disk space disappears when processing cube I am processing a cube, during processing aggregations, the OLAP Drive free space trickles down, while nothing is being added to the files under the specific cube's data directories. Looks like Analysis Services may be temporarily storing aggregations results into some phantom files Anyone know about this Is it possible to tell how much free disk space this requires I don't like when it fails and doesn't say why... Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 9
    - searching a Unicode data within a Image data type By the way: a lot has changed since SQL-server 2005 and W2k3. The collation to use for Hindi is Indic_General_90_CI_AS. I can't test is for you, since we only use Latin-based collations. Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 10
    - SQL 2005 32-bit vs 64-bit guidance What some good reasons to select 64-bit rather than 32-bit for SQL Server 2005 We are preparing to install a very large SQL Server 2005 cluster. Initially, the primary database is estimated at 1 Terabyte, with 5 more databases that will add up to another Terabyte. After a few years, the estimate jumps up to 20 Terabytes for the largest DB and another 20 for the other five, combined. We've made the assumption that a database this large, with up to 1000 concurrent users, that this is a good candidate for a 64-bit installation. And that we're better off starting out with 64-bit, rather than migrating later. Can someone provide some guidance Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 11
    - Setting a filter in the SELECT-statement Is it possible to set a filter in the SELECT-statementpart Normaly you the filter is set in the WHERE-statementpart, but that is too late for me in my statement. Right after the SELECTing the field I want to set a filter to the query Is it possible My statement looks like this now: SELECT [DatabaseName$Item].No_, [DatabaseName$Item].Description, [DatabaseName$Sales Price HAG].[Unit Price], [DatabaseName$Sales Price HAG].[Starting Date], [DatabaseName$Sales Price HAG].[Starting Time], [DatabaseName$Sales Price HAG].[Sales Code] (<== here on this item I want to set a filter) FROM [DatabaseName$Item] INNER JOIN [DatabaseName$Sales Price HAG] ON [DatabaseName$Item].No_ = [DatabaseName$Sales Price HAG].[Item No_] INNER JOIN (SELECT [Item No_], MAX([Starting Date]) AS MaxStartingDate, MAX([Starting Time]) AS MaxStartingTime FROM [DatabaseName$Sales Price HAG] AS [DatabaseName$Sales Price HAG_1] GROUP BY [Item No_]) AS SubQuery1 ON [DatabaseName$Sales Price HAG].[Item No_] = SubQuery1.[Item No_] AND [DatabaseName$Sales Price HAG].[Starting Date] = SubQuery1.MaxStartingDate AND [DatabaseName$Sales Price HAG].[Starting Time] = SubQuery1.MaxStartingTime Thx for helping! Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 12
    - ADO Error: an insufficient number of arguments.... @Month is a parameter here and when you want to run your Function, you have to use all parameters. As you add this parameter thing after creating this Function, your old views do not know your new function needs a parameter now. So they try to use this new function without a parameter and then you get an error. You need to update your views to use this month parameter with your function, otherwise it'll keep raising this error. Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 13
    - Installing SQL Server 2000 SP3a Hi, I wonder if anyone can help me. I have the same issue. When attempting to install SP4 using the command: setup /upgradesp sqlrun INSTANCENAME=MICROSOFT##SSEE /L*v d:\msdelog.log I get the error: "The product is not installed. Check it a appropriate instance of MSDE is installed." Can anyone shed any light on this Thanks Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 14
    - Bookmark in Code not working. I have a report in reporting services that has a bookmark value asigned to each row. In the following Page_Load event for the page, I'm getting the following error on the ReportViewer1.JumpToBookmark("6") statement: "An exception of type 'System.InvalidOperationException' occurred in Microsoft.ReportViewer.WebForms.dll but was not handled in user code Additional information: Some parameters or credentials have not been specified" Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not IsPostBack Then Dim strReport1 As String = "/ReportDirectory/CurrentWeekSales" ReportViewer1.ServerReport.ReportServerU rl = New System.Uri(CStr(Session.Item("ReportServ er"))) ReportViewer1.ServerReport.ReportPath = strReport1 ReportViewer1.ServerReport.Timeout = 500000 Do While ReportViewer1.ServerReport.IsDrillthroug hReport ReportViewer1.PerformBack() Loop Dim RptParameters1 As ReportParameter() = New ReportParameter(0) {} RptParameters1(0) = New ReportParameter("EBO_EmpKey", CStr(Session.Item("UserKey"))) ReportViewer1.ServerReport.SetParameters (RptParame ters1) ReportViewer1.ServerReport.Refresh() ReportViewer1.JumpToBookmark("6") End If End Sub What am I missing Thanks Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 15
    - Slow Running Insert After Changing OLE DB Destination Data Access Mode The other option for the original poster is to use a lookup in midstream to see and test records before inserting them, and if they are in error, you can redirect those to whereever, while pushing the valid records to an OLE DB Destination using fast load. If at all possible, use the processing logic of SSIS to test your records -- don't let the database do it for you. Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 16
    - SQL Server Assertion ERROR I installed the SQL Server 2005 SP2 (CTP) and it seems to have fixed the problem. I dont see this error anymore on my machine. Thanks very much. Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
- Next
  - 1
    - SP2 Calculated Member Issue I have had this calculated Member for over a year, when I applied SP2, I am returned an error. I have looked on MSDN for something that would indicate what the change was, but cannot find it. Here is the MDX: Case When IsEmpty( [Measures].[Loan Amount] ) Then 0 Else ( [Product].[All] * [Channel].[All] * [Date Closing Funded].[All] * [Loan Status].[Status Rollup].&[Closed]* [Date Closing Funded].[MonthName].CurrentMember, [Measures].[Loan Amount]) End Again, this has been working for over a year. Any help would be greatly appreciated! BobP Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 2
    - about database and table protect hello, We wrote an erp,and provide a platform to participator to extend my erp system,so I will give my participator database dictionary,but I only want to give partial database dictionary,I will hide some table and some field, I want they cann't open the database thouth sql server management studio or other tools,only can using our interface to access database,how can I do -- I use sql server 2005 Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 3
    - Database Mirroring. Asp application (IIS 6.0) does't forward connections to mirror server This also might help. Not sure how accurate the statement is. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=421936&SiteID=1 Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 4
    - SQL2005 C# connection problem When attempting to connect to a SQL2005 database using Visual C# Express edition I receive the following message: The user instance login flag is not supported on this version of SQL Server. I do not have this problem when using SQLExpress Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 5
    - how to design queries graphically? This is a great product for laying out (refactoring) SQL: http://www.red-gate.com/products/SQL_Refactor/index.htm However it can't create graphical representations of queries. To be honest I'm not sure you'd gain a lot from displaying that particular query graphically - in fact I reckon that doing so, and making subsequent modifications, could lead to errors due to the query's complexity. IMO in this case it would be far better to 'bite the bullet' and try to interpret and understand the query text. Chris Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 6
    - ASP: error when trying to insert record Hmmh....is that a question If yes, you will have to post the code from line 49 to see what is happening there. Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 7
    - insert into exec distributedprocname The OLE DB provider "SQLNCLI" for linked server "(null)" indicates that either the object has no columns or the current user does not have permissions on that object. Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 8
    - how to use variable to create index Hi , I would like to create index for a table and that index name must be random generated. How to do this declare @value varchar ( 50 ) set @value = rand () set @value = @value + 'index-name' create index @value on tablename(variables) Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 9
    - SQL CE 3.1 Why is there no option for a char vs nchar data type The app I'm building has char based data, not nchar. My SDF database is twice as large and twice as slow as it needs to be. Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 10
    - Disk activity We are about to go to SQL 2005 and that means getting some new Servers and i am wondering if our SAN is adequate. I like to measure over the next few weeks the amount of data that is sent to the SAN and how long its taking to come back....i.e if someone is running a large report how much data is sent and how long it takes to return. This is for 2000 SQL (i like to get all these results to build my migration plan and hardware configuration). I like to see...........18 mb of data , date time and how much read / write etc if possible the sql. Any ideas Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 11
    - Check the finish time of data driven subscription using Sql There is a 'status' field on ExecutionLog that says 'rsSuccess' if the job was successful. Unfortunately, the times don't match and there is no ID on the executionlog to correspond to the subscription. I believe the times are different because when the report is done running, it writes the executionlog, but the email/file delivery has to take place before the subscription is completed. The ExecutionLog.TimeEnd should be fairly close to the Subscriptions.LastRunTime, but not exact. If you run your report every hour, then you can check to see if the two times are within, say, 10 minutes of each other. Jarret Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 12
    - create a "Yesterday", "This Week", "Last Week" calculated member Hi all, I'd like to add a yesterday dimension member to a new dimension, like a "Time Utility" dimension, that references the second last day of non empty data in a cube. At the moment, I'm doing this: Code Snippet create member [MIA DW].[DATE TIME].[Date].[Yesterday] as [DATE TIME].[Date].&[2007-01-01T00:00:00] select [Measures].members on 0, non empty [DATE TIME].[Date].members on 1 from [MIA DW] But the [yesterday] member does not seem to belong to [DATE TIME].[Date].members So I guess there's two questions: 1) Can I have a new empty dimension which contains all these special members like "Yesterday" or "This Week" and "Last Week" (these last two obviously refer to a set of Dates) 2)How come the Yesterday member is not returned by the .members function Thanks Greg Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 13
    - Cluster Query Hi All, I am deciding on high-availibitly for my database server box. My website can get large number of user hits for 4 days in every quater of year. We are also planning to launch some schemes which will help keep are business and servers busy . I am planning to have 2 node cluster. With configuration Windows Server 2003 Standard Edition 64 bit SQL Server 2005 Standard Edition 64 bit 4 GB RAM 8 x 300 GB Ultra 320 SCSI Hard Drives Hardware RAID 0+1 Redundant Controllers Fiber Attached My Question are. 1) What type of clustering I should go for (Active/active vs Active/Clustering) and why 2) Will active/active means load balancing as there will be 2 servers as active and both of them can share the load 3) What are the advantages and disadvantages of clustering type you recommend in question 1. 4) We are also planning to configure transactional replication on these servers as per disaster recovery plan. Will it an overhead to the servers if they are in different geographical locations (My network bandwidth is 100 mbps connection) Please help. Thanks in advance. regards S Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 14
    - Dealing with two databases Hello, Question 1: In my senario i've developed a system which utilizes 2 database, i've writen queries like db1.dbo.table1 join db2.dbo.table2 etc... Now that db2 is getting huge, client wants to shift it to another server. I don't know how to modifiy my queries to cope with such situation. Could somebody plz tell me on how to you write queries involving two databases from different servers. Question 2: I'm maintaining second database (db2) to keep track of records of db1 which have been processed by my software, so that when db1 gets added with more records i can compare db2 table with db1 table to identify which records are new. db1 is not my database and i don't have any control over that, (it's some erp db), is there any way of identifying which rows have been processed. Can the need for db2 be eliminated I'm using SQL Server 2005 Thank You, Sandeep. Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 15
    - Unable to connect remotelly to mdf.life on sql server 2005 express edition I have a c# application running on my machine. I want to point to a sql server data base express edition running on other machine. By default, from server explorer Ionly acces data base files of the local machine. I dont have acces to remote servers. I used the file explorer and opened the mdf file on remote server. I tried to acces the mdf file remotely but i got excepcion. My questios are: - Is sql server 2005 express edition supporting remote connection to mdf data base file - In other words, I can remotelty conncect to mdf file from remote machine So, I how can point my application to remote sql server 2005 express edition data base running on other machine Please, Help Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
  - 16
    - same value for different parameter values Yes, but you have to create a cube for your report. The main reason for using the cube is your current requirement is quite suitable for cube structure. If you have enough time, try that. Tag: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll

JustinK101

Hello,

When I click into Microsoft SQL Server Management Studio Express and login with windows auth and right click the top of tree, the acutal SQL server instance name, and click properties I get the following error.

http://www.ftoperations.net/screen_shot.jpg

Any ideas what is causing this Everything else works perfect in Studio Express, and am able to view tables, stored procedures, generate reports, everything except get the properties of the SQL instance.

Thanks for the help.

Re: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll

JustinK101

Bump. Anybody know or seen this before Thanks.

Re: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll

Satya SKJ

What is the version of that SQL Server you are trying to view

Have you attempted to install Service pack2 and try again.

Re: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll

JustinK101

I am running: 9.00.3042

I think I have service pack 2 installed.

Re: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll

Satya SKJ

Last try is to reinstall client tools, may try.

Re: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll

mrdenny

What happens when you manually run xp_msver from a query window

Re: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll

JustinK101

What happens when you manually run xp_msver from a query window

I tried this, the output is the same:

xp_msver ProductName

Msg 17751, Level 16, State 0, Procedure xp_msver, Line 1

Could not find the function xp_msver in the library xplog70.dll. Reason: 127(The specified procedure could not be found.).

My Ent. Management install is good, perhaps somebody could send me their xplog70.dll from their install and try that That dll should be in the binn folder of your MSSQL Home Dir.

Re: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll

JustinK101

Does anybody have a valid xplog70.dll file

The only thing I can think of is that my DLL is messed up somehow.

Any other ideas though

Re: Management Studio -> Could Not Find Function xp_msver in library xplog70.dll

JustinK101

Anybody have ideas, as I am not able to access the root/top level properties of Microsoft SQL and the settings.

Thanks!