How can I get AS 2005 to use more than 2GB?

SQL Server Analysis Services

Index ‹ SQL Server

- Previous
  - 1
    - Microsoft.SqlServer.Dts.Pipeline.BlobColumn I am using Component Script to do - Transforming Comma-delimited list row data to column and I want to use MessageBox to see the value Dim DataPnts As String DataPnts = Row.DataPnts.ToString() -- this is my input column (data type = text in Source table and I put as Unicode string [DT_WSTR] in Output column) MessageBox.Show(DataPnts, "DataPoints1", MessageBoxButtons.OK) ---and why can't I see it. It gives me some message with Microsoft.SqlServer.Dts.Pipeline.BlobColumn. Why Values = DataPnts.Split(CChar(",")) Please point me to more info on how to do transform Comma-delimited list row data to column. Thanks. Tag: How can I get AS 2005 to use more than 2GB?
  - 2
    - Excel 2007 DataMining Add-in Database on SQL Server 2005 destroyed by using SQL Server Managment Studio? Hello, i have made some Data Mining Model Examples in Excel 2007 (not temporarily!). They where there after leaving an re-opening Excel. I have used them several times. Then I want to look, if I can see them also via SQL Server Managment Studio in the Analysis Services. There where nothing in the DMAddInDB in Analysis Services. And after this, in Excel my DataMining Models have disappeared and all Models i have made since this disappeared also. Perhaps I have destroyed the database. But will this happen every time Can I share Data Mining Models I have made with Excel with Projects in SQL Server Analysis Services Thanks Berenice Tag: How can I get AS 2005 to use more than 2GB?
  - 3
    - Select Statement i would like to select only those that have statusdates that are later than statusdates with statusky 'A'. Table1 PaperID StatusID StatusDate StatusKey 0001 4566 2003-09-03 00:00:00.000 D 0001 4222 2003-09-03 00:00:00.000 C 0001 4132 2003-09-01 00:00:00.000 A 0002 4222 1999-04-14 00:00:00.000 C 0002 4132 1999-04-14 00:00:00.000 A 0003 4132 1986-08-03 00:00:00.000 A 0003 4566 1986-07-29 00:00:00.000 D 0004 4135 1999-08-27 00:00:00.000 A 0004 2000 1999-08-30 00:00:00.000 C And i would like to have a result of : PaperID StatusID StatusDate StatusKey 0001 4566 2003-09-03 00:00:00.000 D 0001 4222 2003-09-03 00:00:00.000 C 0001 4132 2003-09-01 00:00:00.000 A 0004 4135 1999-08-27 00:00:00.000 A 0004 2000 1999-08-30 00:00:00.000 C I do not want to select 0003 because it has the correct data (statusdate with statusky 'A' is later than the other status dates) as well as 0002 because the dates are the same. What is the best query to use thanks. Tag: How can I get AS 2005 to use more than 2GB?
  - 4
    - remove SQLserver2005 problem hi all, what is the best way to remove SQLSERVER2005 from my computer running XP-sp2 when i try to remove from tha ADD and Remove program from the control panel it's start the wizard but going to stuck.. thankx Tag: How can I get AS 2005 to use more than 2GB?
  - 5
    - insufficient access rights error when doing backup Im using dbo schema for ABC SQL Server 2005 Enterprise database on my laptop. I would like to deploy the ABC into a server running on SQL Server 2005 Standard database. The server database is using abcuser schema. I can do attach/detach and backup/restore on the server. I got error so I generated sql script and install into the server. So now I see all the tables are created with abcuser schema. Once I tried to generate a backup from the server I got the following error. what is the problem guys Property BackupDirectory is not available for Settings 'Microsoft.SqlServer.Management.Smo.Settings'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo) I have no idea what it means by insufficient access rights. How do I solve it Tag: How can I get AS 2005 to use more than 2GB?
  - 6
    - FileProperty and sp_spaceused Hi All I am trying to execute the following set of commands: select fileproperty('master','SpaceUsed')*8; select sum(reserved)*8 from master.dbo.sysindexes where indid in (0,1,255); exec sp_spaceused ; I am getting different values from fileproperty and the sp_spaceused. I am wondering why this is happening. I am sure that there is a valid reason behind this. Can anyone explain why this is happening I also tried using DBCC updateusage('master') with count_rows and sp_updatestats. Thanks Vijay Tag: How can I get AS 2005 to use more than 2GB?
  - 7
    - Vista SQL 2005 SP2 client to Windows XP SQL 2005 (non-sp2) workstation. (Take 2 w/ Workaround) This issue has not been "resolved" as I can tell. But there is a workaround w/o using sql authentication (hate sql authentication) http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1528018&SiteID=1 I found out that it doesnt matter which combination you use for the server as long as the client is Vista... If you are using a windows account, lets say "jondoe" on your vista box acting as a sql management studio client to a sql server on an xp or w2k3 box using windows authentication.... IT WILL work if both the vista box and the xp/w2k3 box BOTH have "jondoe" accounts, and both "jondoe" account passwords are the same!!! SOOOooo.... Apparently when vista runs the program under jondoe (when you launch the shortcut) it runs it under that context (no-duh) but EVEN if you establish a network connection (using net use) beforehand with alternate credentials (lets say on the xp/w2k3 box the user is jonsmith) and then use sql management studio you are assuming that it will just use those trusted credentials.... you are wrong... it wont anymore in vista by default. WTF Why because apparently sql management studio 2005 no longer is allowed to retrieve stored credentials to impersonate jonsmith when connecting to the xp/w2k3 box.... this is where the infamous "no user is associated with this trusted connection". I also got this error with Visual Studio 2005 Web Express Edition... hmmm... a correlation i see SOOOoooo... Workaround 1 (more secure): Create the windows account "jonsmith" on your vista box, set the password to the same exact password for the server's user account. then run the sql management studio application under the jonsmith account using "runas". Result: it works just as it supposed to... using windows authentication. Workaround 2 (less secure): Create the account "jondoe" on the xp/w2k3 box, set the password to the same exact password for the server's user account. then run the sql management studio application under the jonsmith account using "runas". Result: it works just as it supposed to... using windows authentication. Workaround 3: Use sql authentication. works like a charm but not as secure as 1 and 2. FYI: these apply to workgroup connections. domain computers are exempt cause security is handled by domain controllers. I think there must be a security setting (registry option) that would allow this process to work w/o the workaround, but I have yet to figure it out... I'm like a pitbull sniffing around for clues and the only leads i have is that its vista SSPI and that if there is an option, it would be in local security policy AND/OR undocumented registry option. Note: I hate workarounds unless there is a clear cut reason why we have to do it this way. Either because there was a design oops or security consideration when accounts are hijacked.... either way anyone from Microsoft have an explanation of this Oh... firewall enabled/disabled doesnt matter, all systems patched up the yinyang and what nots do not change the end result. All I did was create matching accounts on both ends (using either workaround 1 or 2) and it worked just fine. SOOOOoooo... my question is..... why can't SQLM2K5 MS and VSWD2K5 express grab the existing alternate credentials that i've established (through net use) and run with the ball BTW: I've tried using that "Alert Me" option below. Doesn't work. page takes a nose dive on the POST. Tag: How can I get AS 2005 to use more than 2GB?
  - 8
    - Unable to create maintenance plan When i tried to create a maintenance plan for my db - it's just a full db backup task, it gave a weird error "Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)." Any idea what is wrong is there anywhere i can find details about the error Tag: How can I get AS 2005 to use more than 2GB?
  - 9
    - SP2 Report Builder and default save location Prior to SP2, when you clicked the save button it would take you to the root of Report Server. With SP2 (in old-style Report Manager mode, not Sharepoint integrated mode) it takes you to the /Models directory by default when you click save. Is there a way around this If I launch Report Builder via the following URL, it does fix the problem. But it doesn't let me pick table/matrix/chart. I would like to override the default save location AND be able to let the user pick table/matrix/chart: http://localhost/reportserver/reportbuilder/reportbuilder.application model=/Models/MyModel&savelocation= Suggestions Tag: How can I get AS 2005 to use more than 2GB?
  - 10
    - Create Subscription For Rpt Service with Windows integrated security !!! hi All, I m nicky here. I have problem on Create Subscription for my report if my Data Source is use Windows Integrated Security, with this error message: "Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report , the linked is no longer valid" Please Help .... Thank you From nicky Tag: How can I get AS 2005 to use more than 2GB?
  - 11
    - 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: How can I get AS 2005 to use more than 2GB?
  - 12
    - How to return multiple values from stored procedures How to return multiple values from stored procedures to reports in sql server 2005 Tag: How can I get AS 2005 to use more than 2GB?
  - 13
    - 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: How can I get AS 2005 to use more than 2GB?
  - 14
    - SqlDataSourceEnumerator.Instance; not returning all instances ...static void Main() { // Retrieve the enumerator instance and then the data. SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance; System.Data.DataTable table = instance.GetDataSources(); ... Hi MS SMO folks, I'm not getting all instances returned in my table. I know there are issues surrounding this call but I have 1 dev box, 1 nt 2003 server and a total of 3 sql srv instances. 2 of which are on my local dev machine. All are 2005. Both servers have SQL Browser enabled and all protocols are enabled. All of my MacAfee and Windows firewalls are temporarily Off. The only instance returned is mylocalbox/sqlexpress. I can understand why it may not see the server, due router or other h/w, but what I really don't get is why it doesn't even see my other instance on my local box: mylocalbox/dbcdev1 Is there another more robust method of enumerating all sql instances on a LAN or getting this to work a bit better Thanks Jim Tag: How can I get AS 2005 to use more than 2GB?
  - 15
    - 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: How can I get AS 2005 to use more than 2GB?
  - 16
    - 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: How can I get AS 2005 to use more than 2GB?
- Next
  - 1
    - AS2005 Cube Excel 2007 Filtering Issue When browsing our AS2005 Cube we only have one filtering option. Top 10... under the Value Filters menu item. All other filtering options are disabled. I can create a pivot table manually from data in an excel worksheet and the filtering options work fine. Which leads me to believe it is something wrong with our cube design / metadata Any ideas for what we might need to have the filtering options enabled. Tag: How can I get AS 2005 to use more than 2GB?
  - 2
    - 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: How can I get AS 2005 to use more than 2GB?
  - 3
    - 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: How can I get AS 2005 to use more than 2GB?
  - 4
    - From and Thru Date parameters I'm using MDX to query a cube. I have two identical data sets: WITH MEMBER [Measures].[ParameterCaption] AS '[Date Shipped].[Year-Month].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[Date Shipped].[Year-Month].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[Date Shipped].[Year-Month].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Date Shipped].[Year-Month]. ALLMEMBERS ON ROWS FROM [Heidtman DW] How do I get one to be the "From" date and the other to be the "Thru" date I'm passing the correct parameters ([Date Shipped].[Month].&[2006]&[4]&[12]) & ([Date Shipped].[Month].&[2007]&[4]&[11]) but I don't know how to tell the query to use them correctly. Tag: How can I get AS 2005 to use more than 2GB?
  - 5
    - Case expressions may only be nested to level 10 I'm running into this issue when I try to query a table (well a view) that was poorly designed and has many fields in the table as YesNo fields instead of a single field that just contains a value. (Fields A-N in the table for example) So my query looks like: CASE WHEN A = 1 THEN 'A' WHEN B = 1 THEN 'B' WHEN C = 1 THEN 'C' WHEN D = 1 THEN 'D' WHEN E = 1 THEN 'E' WHEN F = 1 THEN 'F' WHEN G = 1 THEN 'G' WHEN H = 1 THEN 'H' WHEN I = 1 THEN 'I' WHEN J = 1 THEN 'J' WHEN K = 1 THEN 'K' WHEN L = 1 THEN 'L' WHEN M = 1 THEN 'M' WHEN N = 1 THEN 'N' END AS GeneratedField Is there some other way I can approach this I can't change the table as it isn't mine, but I need to run a report that looks at those fields and in GeneratedField places the result for the field that was checked. Thanks. Tag: How can I get AS 2005 to use more than 2GB?
  - 6
    - 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: How can I get AS 2005 to use more than 2GB?
  - 7
    - Stored Proc creation script in T-Sql I am trying to do the following: I need to execute a t-sql statement that contains the stored procedure creation script. In reality this will have differnt stored procedure creation scripts which will be created in different databases depending upon certain criteria. The example below is just for demo purposes. when i try to execute this in master it is showing me the following errors: USE MASTER GO declare @SQLString Nvarchar ( 1000 ) declare @STR Nvarchar ( 1000 ) declare @DBName nvarchar ( 100 ) SET @DBName = 'BTGenesisMDRockville' SET @STR = ' create proc sptemp @id int as select * from orders where id=@id go ' set @SQLString = 'USE ' + @DBName + char ( 10 ) + 'GO' set @SQLString = @SQLString + @str EXEC ( @SQLString ) Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near 'GO'. Msg 111, Level 15, State 1, Line 3 'CREATE PROCEDURE' must be the first statement in a query batch. Msg 137, Level 15, State 2, Line 6 Must declare the variable '@id' . Can anyone help me on this Tag: How can I get AS 2005 to use more than 2GB?
  - 8
    - Report Builder and optional parameters Hi, Is it possible to create optional parameters in Report Builder An *ordinary* parameter is created by marking a filter expression as "prompted". At run-time, the user will be asked to provide a value for this parameter (or accept a default value if it is available). This works fine. What I want is to let the user choose whether to provide a value, or leave the parameter empty. In latter case, the reports should not take the parameter into account and display all available data. Example: I have a list of products grouped by the name of the supplier. I want users to be able to see the entire list, or narrow it down to one supplier only. So I create a free text parameter that will contain a part of the supplier's name. It works ok, but if parameter is left blank, or set to NULL, the report will display no data (all products always have their suppliers). I tried to create a filter formula to check for empty value and bypass the filter if necessary, but the formula only allows me to use the parameter expression once. So I cannot check for empty value and apply the filter in the same expression. As a last resort, I used the following workaround: created a new formula named "Enter 'ALL' to see all suppliers" that would return text constant "ALL". I then added another prompted filter expression for this field and grouped it with my supplier prompt using "Any of" group. User is now able to choose a supplier, or enter "ALL" to the second prompt field. This clumsy approach actually works, but then another problem emerges - although I mark both filter fields as Prompted, the Report Builder will forget this flag for one of the fields when the report is reopened. I think it could be a bug (we use SQL2005 SP1) Anyway, it'd be nice if I could create an optional parameter as one expression, not two. Is there any way to do that TIA Denis Tag: How can I get AS 2005 to use more than 2GB?
  - 9
    - 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: How can I get AS 2005 to use more than 2GB?
  - 10
    - Applying snap shot at subscriber from DVD on SQL 2000 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 Tag: How can I get AS 2005 to use more than 2GB?
  - 11
    - 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: How can I get AS 2005 to use more than 2GB?
  - 12
    - Maximum size of the SSIS String Variable? In SSIS, what is the maximum size of the String variable (one that you would define in the Variables dialog box) Tag: How can I get AS 2005 to use more than 2GB?
  - 13
    - 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: How can I get AS 2005 to use more than 2GB?
  - 14
    - DataFlow Update? Hi, I'm wondering if it is possible to make an update of a specifics rows in a database table using dataflow tasks thanks Tag: How can I get AS 2005 to use more than 2GB?
  - 15
    - New Log or append? I'm backing into the DBA position from being an app / web designer. Using SQL 2005 and hating wizards, I'm trying to code a BACKUP LOG query to run every 15 minutes and create a separate date-time-stamped TRN. I have several questions starting with - should I be doing this Is it better to create separate LOGs or append to one Isn't it true that the only time I'll need the LOGs is when I have a crash and that then I'll need to RESTORE in date-time-order I'm doing a FULL backup every 6 hours and intend on automating deleting the TRNs on a successful completion of the BAK. The following code runs fine and creates a date-time-stamped TRN but doesn't do what I want, as it overwrites the first TRN, so how do I create, say, four JOBSTEPs and get a JOBSTEP @COMMAND to run the SETs USE msdb IF EXISTS ( SELECT Name FROM sysjobs WHERE Name = 'jobDBBackupWedb_1Log' ) EXEC sp_delete_job @job_name = 'jobDBBackupWedb_1Log' GO DECLARE @now char ( 14 ) -- current date in the form of yyyymmddhhmmss DECLARE @dbName sysname -- database name to include date-time-stamp DECLARE @Cmd nvarchar ( 260 ) -- variable used to build JobStep command SET @now = REPLACE ( REPLACE ( REPLACE ( CONVERT ( VARCHAR ( 50 ), GETDATE (), 120 ), '-' , '' ), ' ' , '' ), ':' , '' ) SET @dbName = 'Wedb_1_' + @now + '_.trn' SET @Cmd = 'BACKUP LOG Wedb_1 TO DISK = ' + CHAR ( 39 ) + '\\SERVER1\D$\SQLDatabases\Backup\WebEoc\' + @dbName + CHAR ( 39 ) EXEC sp_add_job @Job_Name = 'jobDBBackupWedb_1Log' , @Description = 'Run Wedb_1 DB Backup Transaction Log Every 15 Minutes' , @Category_Name = 'Database Maintenance' EXEC sp_add_jobstep @Job_Name = 'jobDBBackupWedb_1Log' , @step_name = 'DB_Backup_Log' , @step_id = 1 , @Database_Name = 'Master' , @subsystem = 'TSQL' , @command = @Cmd /* Start time for the Transaction Log backups is seven and one half minutes after midnight to not conflict with the Full database backups run every 6 hours starting at midnight. The Transaction Log backups are to be run every fifteen minutes. */ EXEC sp_Add_JobSchedule @Job_Name = 'jobDBBackupWedb_1Log' , @Name = 'schedDB_BackupLog' , @Freq_Type = 4 , -- Daily @Freq_Interval = 1 , -- Each day @Freq_Subday_Type = 0x4 , -- Interval in minutes @Freq_Subday_Interval = 15 , -- Every fifteen minutes @Active_Start_Time = 000730 -- Start Time is seven and one half minutes after midnight --@Active_End_Time = 235959 -- End Time is next midnight EXEC sp_Add_JobServer @Job_Name = 'jobDBBackupWedb_1Log' GO Tag: How can I get AS 2005 to use more than 2GB?
  - 16
    - 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: How can I get AS 2005 to use more than 2GB?

m14cus

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

Re: How can I get AS 2005 to use more than 2GB?

Thomas Ivarsson

Hello! You will have to use 64bit CPU Tongue Tied and 64bit O/S and the enterprise 64 bit edition of SSAS2005 to use more than 2 GB for SSAS2005.

Regards

Thomas Ivarsson

Re: How can I get AS 2005 to use more than 2GB?

m14cus

Umm... The CPU's are 64bit but had to go with 32bit install becuase when we went in to production many moons ago back when SSSAS2005 only worked on 32bit and we never got around to upgrading. Now seems like that time Smile

Thanks for your help

cheers

Re: How can I get AS 2005 to use more than 2GB?

Christopher Webb

AS should be able to see and use 3Gb even in Standard Edition 32-bit, once you've set the /3Gb switch. See:

http://technet.microsoft.com/en-us/library/ms175672.aspx

and

http://support.microsoft.com/default.aspx scid=kb;en-us;291988

What is your TotalMemoryLimit server property (for details see http://www.microsoft.com/technet/prodtechnol/sql/2005/ssasproperties.mspx) set to I have a vague recollection that there might be something special you have to do to get AS to use the extra memory, but that could be my imagination.

Alternatively, the error message you're seeing might just be wrong about how much memory AS can see. You can stop the error by altering the MemoryLimitErrorEnabled server property (see the previous link) but it sounds like you do need to upgrade to 64-bit to process whatever it is you're trying to process.

HTH,

Chris