Event ID: 17055

SQL Server Database Engine

Index ‹ SQL Server

- Previous
  - 1
    - Get previous sale for a customer's sale? If I have the query: select non empty [Ship Date].[Date].[Date] on 0 from ( select {([Customer].[Customer].&[15566], [Ship Date].[Date].&[1082])} on 0 from [Adventure Works]) where ([Measures].[Internet Extended Amount]) How do I figure w/ mdx that the customer's previous sale was on January 15, 2004 (I don't see .PrevMember working in this case - there is no customer sales date hierarchy estiblished ) For more date data, run this one: select non empty [Ship Date].[Date].[Date] on 0 from [Adventure Works] where ([Measures].[Internet Extended Amount], [Customer].[Customer].&[15566]) Tag: Event ID: 17055
  - 2
    - Trigger to insert multiple records into related table I'm very new to triggers (and stored procedures), I've done a bit of searching and can't seem to find the right direction. Any help would be greatly appreciated. Here is my situation: Thanks in advance! I have 2 tables: Cat_Control (parent), Det_Control (child). They are related via an auto-incrementing ID (Cat_Control_ID) When the user enters a new record into the Cat_Control table, I would like to automatically fill in several default records into the Det_Control table. These default records will be pre-defined based on the Cat_Control.Name field from the record that was just added to the Cat_Control table. I'm sure this is way off base but I hope it will help to clarify what I'm looking to do: 1) For Each Cat_Control record added 2) insert record into Cat_Control table 3) set Cat_Control_ID = @@Identity (for record just added) 4) set Cat_Control_Name = Cat_Control.Name (for record just added) 5) Insert record into Det_Control table 5a) Select Case Cat_Control_Name case 'x' insert record case 'y' insert record case 'z' insert record 6) loop back to step 5, to create 3 more "default records" into Det_Control table 7) loop back to Step 1 for next record Thanks again guys (and gals) for your help. Tag: Event ID: 17055
  - 3
    - Split - Comma seperaed values Hi Guys, I have a table with 2 fields (ID and DepartmentNames), department names column contains a comma seperated list. Can anyone please help me with a query to return the department names in individual rows Current format -------------------- ID DepartmentNames 1 IT,Finance 2 Accounting, Finance, IT Desired format ---------------------- ID Departmnt Name 1 IT 1 Finance 2 Accounting 2 Finance 2 IT Tag: Event ID: 17055
  - 4
    - Cannot Pull table with RDA Dears, I'm trying to set up a rda connection through the pocket pc emulator (standalone version 1.0) and my laptop which runs Windows Vista Home Premium. To start up the rda I first need to connect from my emulated device to my laptop which runs IIS 7.0 (complete installation with compatibility toward IIE 6.0). Connection to http://localhost from my laptop is working fine. I start the emulator (Pocket Pc with Windows Professional) and cradle the emulated device. Connection starts and I'm able to browse from my pc the content of the emulated device or to synchronize it. Then I run Internet Explorer on the emulator and try to connect to http://mycomputername (correct) but I receive a message which says that it cannot connect to the page I was looking for because connection was lost. Any suggestion on how to solve this issue Kind regards and many thanks in advance Cristian It seems that now I can connect to http://mycomputername and I'm able to browse the net with my pocket pc emulator. Anyway when I'm attempting to connect to htpp://mycomputername/subfolder/sqlcesa30.dll (the path is correct, I receive the following error message: " The page cannot be displayed or downloaded because the connection was lost. Check the connection and try later "..which is the same message I've been receiving before) What shall I do Tag: Event ID: 17055
  - 5
    - How to connect to remote server Hi All, I have created my sql database script using SQL data publishing wizard, now i want to execute the same on my shared hosting database. But i am not getting any option to connect to remote server in SSMSE. I have developed web based application with back hand as SQL Server 2005, so now i want to execute my script file onto the server. so how i will connect with my server using SSMSE My application is located under www.briskonsales.com/sales Any idea Thanks, Jay Tag: Event ID: 17055
  - 6
    - SQL 2005 Standard on Vista RTM Hi All, I've read a number of threads on here where users have managed to get 2005 working on Vista RTM. I'm having no such luck however. The issue I have is as follows: Clean Install of Vista RTM Ultimate 32bit. Attempt to install 2005 Standard. This error appears: SQL Server Setup Failed to compile the Managed Object Format (MOF) file D:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation. I've read elsewhere that I need Sp2 of SQL Server. I can't install SQL server though so that makes it hard to apply a service pack. I have also tried the above with the Developer edition of Sql 2005. Has anyone encountered this issue and got past it T.I.A. Glen Surely Microsoft didn't release Vista without having its latest version of their database working on it Tag: Event ID: 17055
  - 7
    - Performance-Issue with variables It's weird, but the literal (untyped) version is faster than the version with the paramenters. Occurs with SQL 2005 SP1 64bit how come --FAST!!!! See execution plan SELECT count (*) FROM dbo . NewsComponent ttNC WHERE ttNC.DateImported BETWEEN '2007-04-02T00:00:00' AND '2007-04-03T23:59:59' ) --( ttNC . DateImported > '2007-01-01T00:00:00' ) --SLOW!!!! See execution plan DECLARE @dateBegin DATETIME ; SET @dateBegin = '2007-01-01T00:00:00' DECLARE @dateEnd DATETIME ; SET @dateEnd = '2007-04-03T23:59:59' SELECT count (*) FROM dbo . NewsComponent ttNC WHERE (ttNC.DateImported BETWEEN @dateBegin AND @dateEnd ) --( ttNC . DateImported > @dateBegin ) Tag: Event ID: 17055
  - 8
    - cannot connect to server i have installed SQL Server management studio when i attempt to connect to report services server i get the following error client found response content type text/html;expected text/xml i cant find where i might have went wrong in installation or report server configuration am new to reporting services so plz help me on this regard thanks sally Tag: Event ID: 17055
  - 9
    - using encryption via an asp site. how is it done ive been playing around with encryption, just encrypting a column with a symmetric key, and having that symmetric key encrypted with a cert, and all that , and it works well through the SSMS, but i want to know how that will be used if im using sql server as a back end database for an asp web site, or an application. does the sql server have to be protected with an SSL cert, and once a user has logged in, what would the steps be to view encrypted data Tag: Event ID: 17055
  - 10
    - The '[CDbl]' function does not exist. I have an MDX query that runs fine on everything except my newest instance of AS 2005. The query is... WITH MEMBER [Measures].[Pct] AS ' CDbl([Measures].[Page Views]) / 100.0 ' SELECT { [Measures].[Page Views], [Measures].[Pct] } ON COLUMNS , LastPeriods( 1, [Time].[Calendar].[Month].&[200701] ) ON ROWS FROM [Web Hit Total] ... and the error is ... The '[CDbl]' function does not exist. Thanks in advance for any help! Keith Spitz, Wall Street On Demand, Inc. Tag: Event ID: 17055
  - 11
    - How to acces report of other system from my system. Hi, Im Designed a Webpage .It consosts of a Button, whenever i click on Button report must generated.When the report is in my system report generated successfully.when I try to access a report from other system.I cudnot able to access report.Can any1 hlp me inthis aspect .any procedure in order to access the report of other system.wht shud be url for Reportserverurl and reportpath.In short When i click on btn i shud get report of other system.what previleges shud be given for other system in other to access With regards, mahender Tag: Event ID: 17055
  - 12
    - FTP Connection problem with "The Password was not allowed" error message Hi I have a simple FTP task that I am trying to connect to an FTP server. I can test the connection fine, however, when I try and execute the package from Visual Studio 2005 I get the "The Password was not allowed" message. I have found some threads that mention setting the protection level on the package to EncryptSensitiveWithPassword, however, I still get the same message appearing. Has anyone any idea as to what is causing this and how I can get around it Thanks Darrell Tag: Event ID: 17055
  - 13
    - Problem with "Transfer SQL Server Objects Task" Hi everyone, I'm currently trying to copy a database from one server to another (both SQL2005) using Business Intelligence Development Studio. I've created an SSIS package. The following parameters are defined: DropObjectsFirst true IncludeExtendedProperties true CopyData true ExistingData Replace CopySchema false UseCollation false IncludeDependentObjects true CopyPrimaryKeys true CopyForeignKeys true The package fails with the following error: Violation of PRIMARY KEY constraint 'PK_tblCallStatus' Cannot insert duplicate key in object 'dbo.tblCallStatus' I know what that error means but I don't understand why I get it. Isn't the package supposed to completely overwrite the destination database It obviously does not. When I manually delete all records from 'tblCallStatus' in the destination database it works fine. I can't remember I had to do that in a SQL2000 environment using DTS. Hope anyone can help since this is almost driving me nuts ;-) Thanks in advance, Kevin Tag: Event ID: 17055
  - 14
    - Problem running SSIS from C# program. I am able to run it from the file system but when I try running it from SQL Server I get an error message that it cannot load package. I am using the following code. Package package = app.LoadFromSqlServer("trans_hist", Properties.Resources.dbServerName, Properties.Resources.userId, Properties.Resources.password, null); Tag: Event ID: 17055
  - 15
    - Schema use in SQL2005 The problem we are having is that we are including components from 3rd parties that are expecting the default behaviour of the EXEC statement within a SP to default the schema correctly according to the invoking user. From what I can see this is not happening in SQL2005. Is this a bug in SQL 2005 or normal behaviour Tag: Event ID: 17055
  - 16
    - Granting UPDATE for only certain columns in a table I have tried using the SQL statement shown below to grant UPDATE permissions for a single column in a single table to a user with db_datareader privileges. grant update (col_1 ) on trs . dbo.table_1 to calc When I then run a SQL script that has an UPDATE for col_1 on trs.dbo.table_1, I get an error message Msg 230, Level 14, State 1, Line 2100 UPDATE permission denied on column 'col_2' of object 'table_1', database 'TRS', schema 'dbo'. Why is the error message referring to "col_2" when my SQL statement is trying to update "col_1" When I performed the "grant" I did it with an account that has db_owner, db_securityadmin, and db_ddladmin privileges. This worked in SQL Server 2000. What must I do to get it to work in SQL Server 2005 Tag: Event ID: 17055
- Next
  - 1
    - Trouble with Pivot Task (multiple problems) - Long All, I am having difficulty with an SSIS package that is simply to pivot a table, and perform calculations used in reporting. Background: A sample set of data is being tested to pivot for reporting purposes. The sample set of data being used is 2226 rows that will pivot to 6 rows having nearly 400 columns. Problem 1: This all seems quite simple except that when I try to pivot on one set of data it works perfectly, I try two at a time, again great. However, as I add three or more groups of data from a view (thus creating 3+ pivoted rows) SSIS throws an error of "-1071636293" and points the to the column containing the values to be pivoted. The error output dumps ALL source data rows with the same error code and message, even on data groups that were successfully pivoted and written to the destination DB all with correct mappings (including the noted with the error code) Running the package on each group of data one set at a time, creating one pivot output row, always works for all data sets without throwing any errors. How is it possible that SSIS would run perfectly on each data set creating one row without any problems/errors/warnings, but when when run on all data at the same time it would fail Problem 2: When running on multiple sets of data creating many pivoted output rows, the error output viewer and log file contain duplicated data rows from the original query. For example if I received the row the pivot id 1001 ONCE in the query from the DB as it is written out to the error file and viewer I see this ID TWICE for each data group. So if each data set were to contain 100 codes to match and I ran this on three data sets, creating an original 300 rows from the db query, the error file and viewer will have 303 rows. This occurs for only different ID's in depending on the data set, but one ID in particular is duplicated for ALL. How could a row be duplicated in the error output in one case but not another when the source data does not contain ANY duplicates Problem 3: When running the package for three sets of data SSIS will note an error and redirect the row to the file I specified with no problem. However, as I run it on 4 or more data sets that cause more errors I receive the message: "The buffer manager attempted to push an error row to an output that was not registered as an error output. There was a call to DirectErrorRow on an output that does not have the IsErrorOut property set to TRUE." Why would the error logging work for one failure but have problems with more I am monitoring the package execution by: 1) logging all available output from SSIS to a file. 2) redirecting all errors from the pivot to a file which works only on the small data sets where I am expecting 1-2 rows to be the pivot result. 3) Placing data viewers on all directional arrows from original db query and pivot Finally, even with all the errors or warnings all data is pivoted as desired and inserted into the destination database as if nothing was wrong, sometimes. Same package, same data, same errors, but delaying the package with breakpoints causes SSIS to either be successful or fail. I'll question that one later as I gather more information. Any help on one or more of these questions would be a great help... Thanks. -1071636293 -1071636293 Tag: Event ID: 17055
  - 2
    - @@Version still shows Service Pack 1 We just installed the service pack 2 to our server, so I did a select @@version but it's still say Service Pack 1, even though the version number is now 3054. Is that a bug in the service pack Thanks. Tag: Event ID: 17055
  - 3
    - Linked server SQL 2005 to 2000 I have something similar... On a SQL 2005 default instance on a box named 'machine1', I define a linked server which points to a SQL 2000 instance also located on 'machine1'. In SSMS, I right-click to use 'add linked server' to add 'machine1\sql2000' (taking the SQL Server radio button as the default). The definition works fine. I then try to use the linked server in a four-part name, e.g. 'select * from machine1\sql2000.dbname.dbo.foobar' and I get a syntax error complaining abou the backslash. No amount of quotes seems to help. What's the trick for defining a linked server in a SQL 2005 instance where the linked server is a named SQL 2000 instance on the same machine and then using that linked server of the SQL 2000 instance in a T-SQL query thx Tag: Event ID: 17055
  - 4
    - SQL Questions Hi All, I was asked couple of questions yesterday and I thought I had to still learn a lot. Questions sound very normal but as for as I am concerned, don't know the answers hence this forum. Please advise. Here the questions asked to me 1) A simple insert into the table (could be from .net application or query analyzer) takes 10 minutes and times out, does not do any thing. What could be the reason and how would you identify and resolve the problem . 2) A simple select from table taking 10 minutes( assuming there are only there columns in the table,those are, id, name, description) id being identity column and has got index as well. What could be the reason and how would you identify and resolve the problem 3) How would you change the identity column value or can we change the identity value and how 4) How would you use the shared, update, exclusive locks in the sql statement. Please let me know. Regards, nw Tag: Event ID: 17055
  - 5
    - Line Chart Color Hello, My line chart displays all lines in a single color (the series color). I'd like a single color per item in the series just like the bar chart. Is there a way to change this Or is the only differentiation the markers Michael Tag: Event ID: 17055
  - 6
    - Im new to using views, and this program they have me working on is using them quite heavily..(cant read from a view) This is my first post, so if i have not posted things in the best manner please lemme know how to be more informative,clear, so that i can learn. So i have made a view with the following command GO /****** Object: View [dbo].[AppraisalView_C] Script Date: 10/11/2007 12:10:43 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER VIEW [dbo] . [AppraisalView_C] AS SELECT a . Counter , a . DateCreated , a . DateModified , a . UserCreated , a . UserModified , a . AppraisalDate_C , a . TypeID_C , a . Customer_C , a . Employee_C , b . Notes_C , b . Value_C , b . AppraisalLineItemID_C , b . AppraisalID_C FROM dbo . Appraisal_C AS a INNER JOIN dbo . AppraisalLineItem_C AS b ON a . AppraisalID_C = b . AppraisalID_C --------------------------------------------------------------------------------------- the program im working on creates the SQL call to read from this view and creates the following query SELECT A . [AppraisalDate_C] , A . [AppraisalID_C] , A . [AppraisalLineItemID_C] , A . [Customer_C] , A . [Employee_C] , A . [Notes_C] , A . [TypeID_C] , A . [Value_C] FROM AppraisalView_C A WHERE [AppraisalView_C] . [AppraisalID_C] = 'APP-000006' but I end up getting the dreaded " Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "AppraisalView_C.AppraisalID_C" could not be bound." error.... I cant change the Query that is called, but i can change the view, what is wrong Tag: Event ID: 17055
  - 7
    - Insert Performance Hey, I'm writing an application where I have to perform a lot of inserts/updates on a SQL Server Compact Edt. 3.1 database (up to 50.000 or even 100.000 consecutive inserts). I'm using native C++ and OleDB. I set the command text only once for each table and I increased maximum buffer size (DBPROP_SSCE_MAXBUFFERSIZE). There are also no table indices or foreign keys. The performance is quite well, but not good enough. I took a closer look at the MS Merge Replication and I observed a really good insert performance. Maybe somebody can tell me some ''secrets'' how I can speed up my query performance! best regards Tom Tag: Event ID: 17055
  - 8
    - Cannot see Report Builder in Report Manager Hi Everyone, I recently updated my instance of SQL Server 2005 express to install reporting services. I am able to navigate to the report manager url but the report builder button is missing. Also, when I go to the report manager url, It prompts me for the server's username and password. Does anyone know how I can fix this Tag: Event ID: 17055
  - 9
    - Update = Delete & Insert? I vaguely recall reading an article that I can no longer find that an update statement is executed as a combination of a Delete and an Insert by SQL server. Does anyone know if this a still a true statement in SQL Server 2005 Thanks, -shl Tag: Event ID: 17055
  - 10
    - odd issue with NOT IN statement Some info We recently moved a database to SQL2005 (start of year) a program I wrote is having a small issue(not rejecting unmatched orders) and I narrowed it to one command statement (that I tried directly in the management studio) I have two databases on the server (a live and a test DB) on the test DB (same tables and views as live but the data is a bit different) side there is no issue, while on the live side it is not working. the command is update wip set haserr=[order xref] where [order xref] not in (select [order xref] from m_orders) on the test database if I add in the wip table a bad order number [order xref] it won't find it and it flags the haserr column and a reject statement is created for that order. On the live database the haserr is not changed and so the filling of the order is not rejected when it needs to. It looks to be an issue with the "not in" command PS at first I thought it was an update issue, but if I do select * form wip where [order xref] not in (select [order xref] from m_orders) edit: did some more testing update wip set haserr=[order xref] where [order xref] in (select [order xref] from m_orders) works update wip set haserr=[order xref] where [order xref] not in (select [order xref] from m_orders) does not I get null Tag: Event ID: 17055
  - 11
    - Looking for Feedback: Native 64-bit Support in SQL Express Hi All, I have another set of questions for the group to help guide me in planning future versions of SQL Express, this time related to 64-bit support. Quick History In SQL Server 2005, SQL Express was only released in the 32-bit architecture. We supported installation to x64 computers using the Windows on Windows implementation that allowed the 32-bit program to install on 64-bit computers. We released two different installer packages, SQLEXPR32.EXE could only be installed on 32-bit platforms, while SQLEXPR.EXE could be installed on both 32-bit and 64-bit platforms, but was the exact same db engine. Package size differences were the result of additional files needed to support WoW installation. Now to the Point A number of people have asked that we release a native 64-bit version of SQL Express, which leads me to my questions for this thread: What advantages will a native 64-bit Express offer you Does a 64-bit Express eliminate the need to support 32-bit WoW (Consider that without WoW, we would not have a single package that could install on both architectures.) If you could only have either native 64-bit Express or WoW support, which would you choose (Bonus if you tell me why. ) What user/application scenarios are driving your need for native 64-bit Express Once again, I will try to limit my participation in this thread, since it's all about your feedback, but I will be reading it closely. I appreciate the effort you put into answering my questions and want to assure you that your feedback is a significant part of how I plan the future of SQL Express. As always, you can answer directly in this thread or respond to me directly, just remove the word "online" from the e-mail address in my profile. Let the feedback begin, Mike Wachal SQL Express team Tag: Event ID: 17055
  - 12
    - Incorrect processing order for views I am using SQL 2005 merge replication with SP1 hotfix build 9.00.2227.00. This build is in use rather than SP2 because a fix I need is not yet available for SP2 Essentially the problem is as follows: 1) Initial state is that merge replication of table and views is working fine 2) I then alter one view which reference s a new view in the same publication 3) Synchronization processes the view scripts in the wrong order regardless of the processing order 4) An 'invalid object name' error results as the new view has not arrived at the subscriber when alteration of the first view is attempted The number suffixes on the script filenames in the snapshot folder do, however,appear to be numbered correctly so as to process in the correct order Note that I have tried using the default processing order and have also set the processing order explicitly using sp_changemergearticle - but the problem still occurs I have tried to recreate this problem on a small database with a minimum of articles, but attempts at repro have failed to date with a simple configuration - ie the processing order applied is correct Is there an known problem in this area Any suggestions would be much appreciated aero1 Tag: Event ID: 17055
  - 13
    - How to insert into a table with a function? I want to add a record into a table, using a function. This function needs to give back the number of records of a given table. Function ImportResults @NumberOfRecords int @TableName varchar(60) @ImportDate datetime @Result bit @Result = 1 @ImportDate =getdate() --Open Table with tablenames select TableName from Tbl_ImportTables For each record in Tbl_ImportTables @TableName = Tbl_ImportTables.TableName @NumberOfRecords = select count(*) from @TableName -- add to Import Results Insert into Tbl_Import_Results (ImportDate ,TableName ,NumberOfRecords ) VALUES ( @ImportDate , @TableName , @NumberOfRecords ) -- Check 0 records (I only want to know if there is a table with 0 records) IF @NumberOfRecords=0 then @Result=0 Next record RETURN @Result End function Can somebody help me with the right syntax (I am new to functions and sp's) Is this a scalar valued function Thanks, Frans Tag: Event ID: 17055
  - 14
    - Data disappearing during Run time When I enter data into a SQL database and save it, the data that I have just added disapears, but when I close the applicaiton and re-open it, it's still there - is there any reason for this and any way to get it to stay Any ideas Tag: Event ID: 17055
  - 15
    - Store Membership information using Access .mdb database Hello, I'm trying to create a web page that is protected by a user login. I want the user data to be stored in an access database file and not an SQL Server express database. I was following this guide on msdn: http://msdn2.microsoft.com/en-us/library/879kf95c(VS.80).aspx However, I was doing everything locally using a file system and not IIS. (Which seemed to work fine) My main problem is that I cannot get the membership information stored in an access database. The only provider option was one for the SQL server express. I think I will have to make a custom provider However, I read through some of that documentation and was equally confused. ( http://msdn2.microsoft.com/en-us/library/Aa479031.aspx ) Anyone have a solution Tag: Event ID: 17055
  - 16
    - Analysis Services Roles - Dimension Data Is there a way to assign dimension data member restrictions within AS 2005 Roles to all attribute hierarchies within a dimension For example we have a dimension with 4 attribute hierarchies : Office Code Office Name Office Group Office Overseas Office Code and Office Name roll up to Office Group (within Office Overseas) We want to restrict certain Active Directory groups to only see their own office data eg Office Code TOR for Office Name Toronto (within Office Group Canada) When an AD group is assigned to only see Office Code TOR (by using the Role Dimension Data member restrictions) Then users in this AD group can still see measure data aggregated for all Office Names and Office Groups (though can only see Office Code TOR) Do restrictions have to applied separately to all attribute hierarchies within a dimension This will be difficult for us to maintain, since most of our dimensions are type 1 with members moving (eg the office groups change quite frequently) Has anyone else come across this issue Tag: Event ID: 17055

Chrisc127

I am running a WSUS and get this error in my event log. I am running Windows 2000 with SQL 2K SP4.

1827

CREAR/ALTER DATABASE failed because the resulting cumulative database size would exceed you licensed limit of 2048MB per database.

Top

Re: Event ID: 17055

Peter Byrne MSFT

2 GB is the data size limit for SQL 2000 MSDE databases. You will need a higher end edition to have a larger database.

Top

Re: Event ID: 17055

Samcara

I am currently through the same issue. Is there anyway to compact or split up the database (SUS.mdf)

Top