Applying snap shot at subscriber from DVD on SQL 2000

SQL Server Replication

Index ‹ SQL Server

- Previous
  - 1
    - Problem Configuring Reporting Service Hey there, im having a problem that a few people seemed to have had already. The problem is again related to the Web Service Identity. Windows Server 2000, IIS 5.0, SQL Server Express 2005 Adv, and Microsoft.Net 2.0 after installing SQL Server Express 2005 when i launch the Reporting Service Configuration it could not connect to the Server as the Reporting Service was not running. In order to get the Reporting Service running i had to modify the rsreportserver.config file in the C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer directory. Here i modified the added the following <WebServiceAccount>IWAM_SKYREV</WebServiceAccount> this was due to no SKYREV\ASPNET account being available on the server machine. (based on this article http://support.microsoft.com/default.aspx/kb/911846 ) Once i changed this i could now get the Reporting Service running and access the configuration tool. So now we come to my current problem. In the Web Service Identity it shows an exclamation. Here the ASP.net as SKYREV\ASPNET and when i attempt to apply this i get the following error: ReportServicesConfigUI.WMIProvider.WMIProviderException: The account name is not valid. Specify an account in the form domain\alias. at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool) Any one have any ideas for me... Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 2
    - How to return multiple values from stored procedures How to return multiple values from stored procedures to reports in sql server 2005 Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 3
    - Cannot see Local Database template in Add New Item Dialog box Per MSDN instructions I downloaded the folliwng: .NET Framework 2.0, SQL Server 2005, SQL Server Compact 3.5, and Visual Basic Expess Edition. When following the tutorial to create a database, I was never able to see the Local Database template. I am taking the programming lessons in VB, and I am up to Creating Your First Datatbase. It is a requirement that SQL Server Compact 3.5 be installed. Which I have done. Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 4
    - SqlDataSourceEnumerator.Instance; not returning all instances Add the servers to file hosts located in Windows\System32\Drivers\Etc Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 5
    - Drillthrough (beginner) I have created two reports. One links to the other with a drillthrough. The linking works fine, but no values show up in the fields besides the group titles and column titles. Why is this happening The user is given a list of Counties with values. The Counties(in a matrix) are clickable for a drillthrough of Ages and Genders in the Counties. Looks something like this: Years Counties Total Crashes Fatalities Cook 85 98 Manchester 2850 258 Sagamon 987 526 So when a user clicks a county, such as "Cook", this is displayed Years Age Gender Total Crashes Fatalities 0-8 Female 25 8 Male 55 15 9-15 Female 850 258 Male 185 35 16-22 Female 87 526 Male 10 35 But I am getting this in : Years Age Gender Total Crashes Fatalities 0-8 Female Male 9-15 Female Male 16-22 Female Male Whats going on Can anyone make any suggestions Just to let you know its based off of an Analysis Services Cube and not relational tables. Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 6
    - DBCC TableResults Anyone know where I can find the "TableResults" table definition in order to create a table for the DBCC command I can't seem to find it in BOL... Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 7
    - How can I get AS 2005 to use more than 2GB? I'm currenlty running AS 2005 on a Windows 2003 STD edition 32bit. I have added the /3GB switch in the boot.ini to that the server will use all 4GB. Unfortunately AS only appears to see 2GB based on the following error Memory error: The operation cannot be completed because the memory quota estimate (4095MB) exceeds the available system memory (1996MB). As you can see my the error AS only thinks the system has 1996MB of memory. I can confirm that there is 4GB of memory in the server and the OS can see 4GB memory Thanks for your help Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 8
    - AS2005 Cube Excel 2007 Filtering Issue > It would be interesting to know about the features in Excel 2007 that are disabled before SSAS2005 SP2 I agree that it would be interesting to know. This question belongs to the Excel forum, however. Also, in couple of months when everybody has upgraded to SP2, this will become a moot point. > Are these new features being enabled by an update on the client I beleive it's enough to upgrade AS server only. Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 9
    - Apparent Memory Leaks in ODBC We have created a multithreaded application that reads result sets from MS SQL Server (both 2000 and 2005). The MS SQL Server app and our app reside on the same machine. We are using the latest version of ODBC32.DLL (3.526.1830.0) and SQLSRV32.DLL (2000.86.1830). Our application is written in C++ using the Visual C++ 6.0 compiler and libraries. Our app runs as a service, therefore the apparent memory leak is a real problem. Our app needs to run on a server in a closet without human intervention. We are kicking off many user threads that each can read from the database tables. Each of the reads from the database occurs within a critical section to minimize the threads stepping on each other. The ODBC interface class follows all the steps defined in the ODBC application developers documention (see code below). We see or app memory steadily increasing over time (we used PerfMon to monitor Private Bytes and Virtual Bytes, per ODBC documentation). If we terminate the threads which are retreiving the result sets, the memory drops back to the level noted prior to starting the threads. The code below is admittedly inefficient, however, it should not leak memory when accessing the database. Note that it works very well, returns the result sets that we expect exactly. SQLHENV henv = SQL_NULL_HENV; SQLHDBC hdbc = SQL_NULL_HDBC; SQLHSTMT hstmt1 = SQL_NULL_HSTMT; SQLRETURN retCode; SQLSMALLINT sColCount = 0; CODBCInterfaceColumnList lColumnList; CString strDSN; CString strUID = _T("AccountName"); CString strPWD = _T("Password"); CString strServer; CString strDatabase; CString strDebugMsg; if(!CreateDSN( pRecordList->m_strDefaultODBCConnect, strDSN, strDatabase, strUID, strPWD, strServer)) { strExceptionMsg.Format( _T("Cannot create DSN from connect string %s"), pRecordList->m_strDefaultODBCConnect); bReturn = true; return bReturn; } if(pRecordList->m_strDefaultODBCConnect.IsEmpty()) { bReturn = true; return bReturn; } // Allocate the environment handle retCode = SQLAllocHandle(SQL_HANDLE_ENV,NULL, &henv); if(retCode != SQL_ERROR && retCode != SQL_INVALID_HANDLE) { // Set the environment to ODBC Version 3.0 retCode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, SQL_IS_INTEGER); if(retCode != SQL_SUCCESS) { GetErrorMsgs(hdbc, SQL_HANDLE_ENV, strDebugMsg); } if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { // Allocate a ODBC connection handle handle retCode = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc); if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { retCode = SQLConnect( hdbc, (UCHAR*)(LPCTSTR)strDSN, SQL_NTS, (UCHAR*)(LPCTSTR)strUID, SQL_NTS, (UCHAR*)(LPCTSTR)strPWD, SQL_NTS); if(retCode != SQL_SUCCESS) { GetErrorMsgs(hdbc, SQL_HANDLE_DBC, strDebugMsg); OutputDebugString(strDebugMsg); } if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { // Allocate a statement handle retCode = SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt1); if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { // Fixup the select statement retCode = SQLPrepare( hstmt1, (UCHAR*)(LPCTSTR)pRecordList->m_strSelectStatement, pRecordList->m_strSelectStatement.GetLength()); if(retCode == SQL_SUCCESS) { retCode = SQLExecute(hstmt1); if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { retCode = SQLNumResultCols(hstmt1,&sColCount); if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { if(sColCount > 0) { if(lColumnList.DescribeColumns(hstmt1, strExceptionMsg)) { if(lColumnList.BindColumns(hstmt1, strExceptionMsg)) { int i = 0; while((retCode = SQLFetch(hstmt1)) != SQL_NO_DATA) { if(retCode != SQL_SUCCESS) { GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg); break; } else { // Class to hold the result set. CTableColumnList* pColList = new CTableColumnList(); lColumnList.PopulateColumnListObject(pColList); pRecordList->AddColumnListRecord(pColList); } } } } } } } else { GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg); } } else { GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg); } retCode = SQLFreeHandle(SQL_HANDLE_STMT, hstmt1); } else { GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg); } retCode = SQLDisconnect(hdbc); } else { GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg); } } retCode = SQLFreeHandle(SQL_HANDLE_DBC, hdbc); } } retCode = SQLFreeHandle(SQL_HANDLE_ENV, henv); We are at our wits end, not sure what to do next. Any help in sorting this out will be very, VERY much appreciated. Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 10
    - reportviewer issue I am using the reportview in vb2005 to run a report that is on our report server. It just keeps says its processing and does not come up with any results. Any thoughts why this is happening and how I can fix Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 11
    - From and Thru Date parameters For some reason (I first did this report several months ago then broke it when I changed my cube structure) I was passing the parameters with paranthesis around them: ="(" & code.FromDate(Pa....) & ")". I don't remember why I did that and removing them fixed it. Thanks!!!! Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 12
    - Case expressions may only be nested to level 10 I'm not doing anything that isn't shown in my SQL statement there (Other than a SELECT and FROM and WHERE). However, nothing unusual. Now if I run that SQL with say 8 statements then it works just fine. I've read that this appears to be an issue and that others have run into it before. In some cases they wrapped the whole thing in a stored procedure on the linked server or their server and ran it that way. In my case I'm executing this against a linked server and can't make a sproc there. I'll play with the examples provided above and see if those will address the issue for me or not. Thanks! Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 13
    - conditions in where clause Hi I am upsizing the access database to SQL 2005. I currently converting Access Query's to SQL stored procs and functions but i have got stuck on one issue. In access there is a update statement that has an IIF in the where clause, i have tried replicating this in T-SQL buy using case statement but it does not work. in access the where looks some thing like this Where IIF(table1.Column1 = 0,Table2.column1,Table3.Column1) Any one know how i can best replicate this behavior Dagz Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 14
    - Stored Proc creation script in T-Sql Thanks.. That was helpful.. Can i also check whether the proc already exists before creating the script something like this: set @sp = @logDBName + '..sp_executesql' SET @STR = ' SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS OFF IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N''[dbo].[sptemp]'') AND OBJECTPROPERTY(id, N''IsProcedure'') = 1) DROP PROCEDURE [dbo].[sptemp] CREATE PROC sptemp @id int as select * from orders where id=@id go ' EXEC @sp @STR Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 15
    - Report Builder and optional parameters We are talking about Report Builder, a small application designed to allow end users to create ad hoc reports based on data models. RB has serious limitations in the way the report parameters are handled. You cannot explicitly create parameters, but only set "Prompt" flag for filter conditions. You can see "Prompt" when you right-click on the name of the expression in the Filter Data window. I'm new to SSRS and may be mistaking, but I think if you have RS2005, you should also have Prompt option. Dunno about RS2000 though. Denis Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 16
    - Error - SQL Server requires Encryption On Hello All, I have a commercial application built for Pocket PC's that connects to SQL Server 2005 via TCP/IP over wireless networks. In installations for our sales people we installed SQL 2005 Express on their notebooks for demonstrations. In one of these installs we are getting the following error message: "An error occurred - SQL Server requires Encryption On". We do not use encrypted connections and I have verified encryption is turned off in the Options tab in SQL 2005 login screens. Here is the connection string we use in the app.config file on the Pocket PC's: <add key="connStr" value="Data Source=192.168.0.19,1433;Initial Catalog=SQL0018;User ID = User01;Password=PW01"/> Other apps on the notebook are connecting to this same SQL Server without any issues. Thank you in advance for any help here, Jack Tag: Applying snap shot at subscriber from DVD on SQL 2000
- Next
  - 1
    - How can i encrypt or mask a column in the database How can i encrypt or mask a column in the database Any help will be appreciated Regards Karen Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 2
    - Maximum size of the SSIS String Variable? I don't believe there is a limit on the string variable size. As mentioned, there is a 4000 character limit in the expression editor, and I believe the limit for NVARCHAR fields for the SQL Native Client provider is also 4000 (above that it has to be NTEXT). Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 3
    - Enterprise Manager returns [MS Visual Database Tools] - The parameter is incorrect when returning all rows When I try to return all rows from a view or table by selecting Open Table|Return All Rows from the context menu, I get a dialog in the middle of EM stating: An unexpected error happened during this operation. [MS Visual Database Tools] - The parameter is incorrect. Any ideas Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 4
    - DataFlow Update? Yes. It's committing every row that passes through it. This is a very expensive component, and should be avoided in favor of Matthew's suggestion. Load your updates to a staging table, and then issue a one-time update SQL statement using that table as the source of the changes. I personally avoid the OLE DB Command. Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 5
    - New Log or append? Chris, Thank you very kindly! I take your comment about run-time, create/execute; that was spot on. Thanks for the code change - works like a charm ... ... but, I've looked and not found an answer, what is the "N" doing for me in SET @cmd = N'DECLARE ... Is it declaring that what follows is all an NVARCHAR string Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 6
    - JIT Debug HELP See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.NullReferenceException: Object reference not set to an instance of an object. at HP.CUE.Video.PlaybackControl.UpdateProgressBar() at HP.CUE.Video.PlaybackControl._ProgressTimer_Tick(Object sender, EventArgs e) at System.Windows.Forms.Timer.OnTick(EventArgs e) at System.Windows.Forms.Timer.Callback(IntPtr hWnd, Int32 msg, IntPtr idEvent, IntPtr dwTime) ************** Loaded Assemblies ************** mscorlib Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.2032 CodeBase: file:///c:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll ---------------------------------------- hpqimzone Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///C:/Program%20Files/HP/Digital%20Imaging/bin/hpqimzone.exe ---------------------------------------- hpqiface Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqiface/4.0.0.0__a53cf5803f4c3827/hpqiface.dll ---------------------------------------- System.Windows.Forms Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.2032 CodeBase: file:///c:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll ---------------------------------------- System.Drawing Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.2032 CodeBase: file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll ---------------------------------------- System Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.2032 CodeBase: file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll ---------------------------------------- hpqcc2 Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqcc2/3.0.0.0__a53cf5803f4c3827/hpqcc2.dll ---------------------------------------- hpqutils Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqutils/4.0.0.0__a53cf5803f4c3827/hpqutils.dll ---------------------------------------- hpqfmrsc Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqfmrsc/4.0.0.0__a53cf5803f4c3827/hpqfmrsc.dll ---------------------------------------- hpqtray Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqtray/4.0.0.0__a53cf5803f4c3827/hpqtray.dll ---------------------------------------- hpqovskn Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqovskn/3.0.0.0__a53cf5803f4c3827/hpqovskn.dll ---------------------------------------- hpqimvlt Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqimvlt/3.0.0.0__a53cf5803f4c3827/hpqimvlt.dll ---------------------------------------- hpqimgrc Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqimgrc/4.0.0.0__a53cf5803f4c3827/hpqimgrc.dll ---------------------------------------- hpqntrop Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqntrop/4.0.0.0__a53cf5803f4c3827/hpqntrop.dll ---------------------------------------- Interop.hpqcxm08 Assembly Version: 3.0.0.0 Win32 Version: 53.0.13.000 CodeBase: file:///c:/windows/assembly/gac/interop.hpqcxm08/3.0.0.0__a53cf5803f4c3827/interop.hpqcxm08.dll ---------------------------------------- System.Xml Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.2032 CodeBase: file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll ---------------------------------------- LEAD Assembly Version: 13.0.0.113 Win32 Version: 13.0.0.113 CodeBase: file:///c:/windows/assembly/gac/lead/13.0.0.113__9cf889f53ea9b907/lead.dll ---------------------------------------- LEAD.Wrapper Assembly Version: 13.0.0.113 Win32 Version: 13.0.0.113 CodeBase: file:///c:/windows/assembly/gac/lead.wrapper/13.0.0.113__9cf889f53ea9b907/lead.wrapper.dll ---------------------------------------- LEAD.Windows.Forms Assembly Version: 13.0.0.113 Win32 Version: 13.0.0.113 CodeBase: file:///c:/windows/assembly/gac/lead.windows.forms/13.0.0.113__9cf889f53ea9b907/lead.windows.forms.dll ---------------------------------------- LEAD.Drawing Assembly Version: 13.0.0.113 Win32 Version: 13.0.0.113 CodeBase: file:///c:/windows/assembly/gac/lead.drawing/13.0.0.113__9cf889f53ea9b907/lead.drawing.dll ---------------------------------------- interop.hpqimgr Assembly Version: 3.0.0.0 Win32 Version: 53.0.13.000 CodeBase: file:///c:/windows/assembly/gac/interop.hpqimgr/3.0.0.0__a53cf5803f4c3827/interop.hpqimgr.dll ---------------------------------------- hpqthumb Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqthumb/3.0.0.0__a53cf5803f4c3827/hpqthumb.dll ---------------------------------------- hpqasset Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqasset/4.0.0.0__a53cf5803f4c3827/hpqasset.dll ---------------------------------------- hpqmirsc Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///C:/Program%20Files/HP/Digital%20Imaging/bin/hpqmirsc.DLL ---------------------------------------- hpqedit Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqedit/3.0.0.0__a53cf5803f4c3827/hpqedit.dll ---------------------------------------- hpqvideo Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqvideo/3.0.0.0__a53cf5803f4c3827/hpqvideo.dll ---------------------------------------- LEAD.Windows.Forms.DrawingContainer Assembly Version: 13.0.0.113 Win32 Version: 13.0.0.113 CodeBase: file:///c:/windows/assembly/gac/lead.windows.forms.drawingcontainer/13.0.0.113__9cf889f53ea9b907/lead.windows.forms.drawingcontainer.dll ---------------------------------------- hpqmdmr Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqmdmr/4.0.0.0__a53cf5803f4c3827/hpqmdmr.dll ---------------------------------------- LEAD.Drawing.Imaging.ImageProcessing Assembly Version: 13.0.0.113 Win32 Version: 13.0.0.113 CodeBase: file:///c:/windows/assembly/gac/lead.drawing.imaging.imageprocessing/13.0.0.113__9cf889f53ea9b907/lead.drawing.imaging.imageprocessing.dll ---------------------------------------- hpqimlib Assembly Version: 3.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqimlib/3.0.0.0__a53cf5803f4c3827/hpqimlib.dll ---------------------------------------- hpqglutl Assembly Version: 4.0.0.0 Win32 Version: 053.000.013.000 CodeBase: file:///c:/windows/assembly/gac/hpqglutl/4.0.0.0__a53cf5803f4c3827/hpqglutl.dll ---------------------------------------- Interop.hpqvideo Assembly Version: 3.0.0.0 Win32 Version: 53.0.13.000 CodeBase: file:///c:/windows/assembly/gac/interop.hpqvideo/3.0.0.0__a53cf5803f4c3827/interop.hpqvideo.dll ---------------------------------------- ************** JIT Debugging ************** To enable just in time (JIT) debugging, the config file for this application or machine (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the machine rather than being handled by this dialog. Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 7
    - Displaying member name instead of key in query In the tools that I have used for getting generated MDX queries (Query Analyzer, Proclarity, Excel) the query always seems to show the key value instead of the member name. Is it possible or is there a query tool that will generate queries with the member name instead See example: [Organization].&[152551] Should read [Organization].[By Division] thanks, Andrew Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 8
    - Simple select statement gone wild!! Okay, I changed to (People.BirthDate BETWEEN '19001001' AND '20071215'), but the issue I am having is that i should only see birthdates in the 4th qtr, oct, nov, dec.... but i get dates from all other months. Does this make sense >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>Results A KWANG TAK 10/25/1929 12:00:00 AM A EDILBERTO PENA 2/10/1937 12:00:00 AM A RITA ZAPATA 5/22/1938 12:00:00 AM A EFREN MORALES 4/13/1939 12:00:00 AM A JOSE TAGLE 11/26/1943 12:00:00 AM A ROSALINDA DURAN 11/1/1944 12:00:00 AM Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 9
    - Missing DLL during installation XP PRO SP2 I downloaded and installed SQL Server 2005 Express with Advanced Services (9.0.3042.0). The installation appeared to complete successfully and I looked at various options of Management Studio. After exiting, rebooting, and restarting Management Studio, I got the message, (paraphrased) Management Studio failed to initiate - terminating. After using Add/Remove to remove all installed components, I reran the installation. I got two error messages indicating that xpstar90.dll is missing. Did not see these messages during the first install. Log SQL0003_mycomputername_SQL contains these errors: Error Code: 17750 MSI (s) (94!58) [18:24:53:031]: Product: Microsoft SQL Server 2005 -- Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.).. Refer to the server error logs and Setup logs for detailed error information. Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.).. Refer to the server error logs and Setup logs for detailed error information. SQL_ERROR (-1) in OdbcStatement::execute_batch sqlstate=42000, level=16, state=1, native_error=17750, msg=[Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.). sqlstate=42000, level=16, state=1, native_error=14658, msg=[Microsoft][SQL Native Client][SQL Server]Failed to retrieve SQLPath for syssubsystems population. Error Code: 0x80074556 (17750) Windows Error Text: Source File Name: lib\odbc_statement.h Compiler Timestamp: Wed Jun 14 16:28:15 2006 Function Name: OdbcStatement::execute_batch@sysdbupg.sql@113 Source Line Number: 91 Log SQL0003_mycomputername_Core reported: Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run: "c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 17750 Aborting queue processing as nested installer has completed Message pump returning: 17750 Log SQL003_mycomputername_Core(Local) reported: Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Installation of package: "patchMSDE2000" failed due to a precondition. Error: Action "UninstallForSQLAction" failed during execution. Error information reported during run: Action: "UninstallForSQLAction" will be marked as failed due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Installation of package: "patchLibertySql" failed due to a precondition. Skipped: UninstallForRS2000Action Skipped: Action "UninstallForRS2000Action" was not run. Information reported during analysis: Action: "UninstallForRS2000Action" will be skipped due to the following condition: Condition "Action: InstallRSAction was skipped." returned true. Error: Action "ExposeVistaClusteredResources" failed during execution. Error information reported during run: Action: "ExposeVistaClusteredResources" will be marked as failed due to the following condition: Condition "The Clustered SQL Server instance that hosts is installed." returned false. Running: ReportChainingResults at: 2007/8/11 18:27:5 Error: Action "ReportChainingResults" threw an exception during execution. One or more packages failed to install. Refer to logs for error details. : 17750 Error Code: 0x80074556 (17750) Windows Error Text: Source File Name: sqlchaining\sqlchainingactions.cpp Compiler Timestamp: Thu Nov 16 20:31:57 2006 Function Name: sqls::ReportChainingResults: erform Source Line Number: 3521 ---- Context ----------------------------------------------- sqls::HostSetupPackageInstallerSynch: ostCommit sqls::HighlyAvailablePackage: reInstall led due to cancel code received from cancel source: 29539 Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_DCHJL761_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0003.cab" Error Code : 2 Running: UploadDrWatsonLogAction at: 2007/8/11 18:29:5 Message pump returning: 17750 No other log contained a related error message. A third attempt to install resulted in a Failure to create database files. Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 10
    - Issues importing from Visual FoxPro 7 I'm trying to bulk load tables in SQL 2005 from a Visual FoxPro 7 database. We have the latest VFP OLE DB driver loaded and have run into an odd issue. When viewed from the table designer in VFP the tables have all columns set to not null (null column is not checked). However there are lots of rows with "empty" values for columns with both numeric and date data types. When I select these columns from an ODBC test app with the old (version 6.something) odbc driver they are filled with spaces. When I run a select on the tables from SQL 2005 these "empty" values come back as a default value based on the columns data type; 0 for numeric columns and 12/30/1899 for date fields. Now, for the first question, from the OLE DB side of things, is there a way to prevent the OLE DB driver from manufacturing data I can use a case statement to catch and remove the default date as 12/30/1899 isn't in the data. But there is no way to know when a returned 0 for a numeric field is a a valid value and when it was stuffed because the so-called non-null field had no value in it. Or if not, part two, can the old version 6 odbc driver be used from SQL 2005 I have a system DSN defined that works from an ODBC test app when using ODBC 2.0 syntax, but SQL 2005 doesn't seem to want to connect to it. linked server created with: EXEC master . dbo . sp_addlinkedserver 'ODBCLINKTEST' , '' , 'MSDASQL' , 'SystemDSN' and the query results... select * from [odbclinktest] ...tablename Msg 7313, Level 16, State 1, Line 1 An invalid schema or catalog was specified for the provider "MSDASQL" for linked server "odbclinktest". Any hint, tips, tricks, etc. greatly appreciated. Thanks, Ed Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 11
    - problem in connecting to sql server Express Hi Goswami, sorry to ask this what is mean by NET DDE and NET DDE DSDM, but SQL Browser by defult is in disabled(I have to change that thing to Automatic and then i have to start it manually right). Right now I'm using sql server studio express only. With Regards -Amjath Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 12
    - Drilldown/interactive chart Hi, Its not clear to me.Can you write the mdx query for me to solve the proglem pls chandan Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 13
    - Calcaluting total nu of people based on their name field Thanks lot for the codes Adam..Yes Total Number of members are sum of borrowers and depositors. But member can not be both. But from membertable we can not identify whether they are borrowers or depositors. I need to get that info from borrowers and depositors tables. I tried with my codes. I had to change @GETDATE as @Enddate. Except that My code worked. But drawback is user has to input dates manually inorder to see that. I think the one you wrote does not requre user to enter dates. I will try with your code. One more thing..what do u mean CTE Probably for 2007 year members statistics, I may need to make a seperate data set. Thanks again Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 14
    - generate report using recordset Hi Adam, thanks for reply... you mean i can't use recordset data to show using reporting services. Is there any way to make a component in .net which can access recordset data from session object and then pass it to reporting services for generate the report. Any suggestion will be appreciable... thanks Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 15
    - Slowly Changing Dimension [58] Error i am using SCD to insert or update .my source and destination table are Oracle and i am using Orcale OLEDB provider . i am getting the following error while executing the package.what could be the solution [Slowly Changing Dimension [58]] Error: An OLE DB error has occurred. Error code: 0x80040E5D. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80040E5D Description: "Parameter name is unrecognized.". Thanks Jegan Tag: Applying snap shot at subscriber from DVD on SQL 2000
  - 16
    - bug: name change of connection manager is not propogated through package Bob, It is true that I can get the connection managers to work, but everytime Iopen the project I get several errors saying the old connection magagers can not be connected. I think I have tried everything to get these errors to go away including: Renaming, reselecting, deleting and readding, deleting-shuting down app-deleting connection manager lines from XMLfile-readding-reconnecting. I still get the errors. The only fix I have found is to create new packages, add the connection managers, change their names, copy the execution objects from the previous package and set the connections. BTW: I am using Microsoft Visual Studio 2005 Version 8.0.50727.762 (SP.050727-7600) Microsoft .NET Framework Version 2.0.50727 Installed Edition: IDE Standard Microsoft Visual Studio 2005 Premier Partner Edition - ENU Service Pack 1 (KB926601) This service pack is for Microsoft Visual Studio 2005 Premier Partner Edition - ENU. If you later install a more recent service pack, this service pack will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/926601 SQL Server Analysis Services Microsoft SQL Server Analysis Services Designer Version 9.00.3042.00 SQL Server Integration Services Microsoft SQL Server Integration Services Designer Version 9.00.3042.00 SQL Server Reporting Services Microsoft SQL Server Reporting Services Designers Version 9.00.3042.00 Bartron Tag: Applying snap shot at subscriber from DVD on SQL 2000

PhilD62154

I want to send snap shots by DVD to a SQL2000 server from SQL2005. This config is replicating fine using trans replication with the publisher and distibuter on the source SQL2005 server. I am using push subscription to the SQL2000 server.
I now need to create snap shots on the SQL 2005 server that I can send to the SQL2000 server using DVD. I know how to create the snap shot on the SQL2005 server but I cannot find any way to use it on the SQL2000 target server.
Can anyone tell me how to do this
Thanks
Phil

Top

Re: Applying snap shot at subscriber from DVD on SQL 2000

Hilary Cotter

copy the entire path from repldata down to the dvd. IN SSMS, create the pull subscription as normal but do not synchronize it immediately. Once it is create, right click on the subscription, select properties, then subscription properties, and in the snapshot text box enter the path like this q:\repldata, where q is your dvd drive.

Top

Re: Applying snap shot at subscriber from DVD on SQL 2000

PhilD

Thanks for the info. I cannot create a pull subscription on the SQL2000 server from the SQL2005 server as Enterprise manager will not connect to SQL2005. I get an error on registering the server DMO must be used.
Any idea how to get round this

Top

Re: Applying snap shot at subscriber from DVD on SQL 2000

Hilary Cotter

Connect to your subscriber in SQL Server Management Studio and pull it there.

Top