Answer Questions

• aurorean attribute key was not found error

  everytime i try to process my cube i get this error: Errors in the OLAP storage engine : The attribute key cannot be found : Table : dbo_MCSFinFactData , Column : InvoiceDateDimensionID , Value : 15. Errors in the OLAP storage engine : The record was skipped because the attribute key was not found . Attribute : InvoiceDateDimensionID 8 of Dimension : InvoiceDate Fiscal Year 2 from Database : SRDBAnalysis , Cube : MCSFinancial , Measure Group : MCSFinancial , Partition : MCSFinancial , Record : 10. I have checked the dimension table and the record with an invoicedatedimensionid value of 15 exists. there are also many records in the fact table that use an invoicedatedi ...Show All

• iljanated Don't show point labels if value is zero

  Hey, I have a stacked column chart. It shows headcount per month. The headcount is split up into employees and contractors. I added point labels to the chart to display the exact headcount value per month. (=Sum(Fields!HeadCount.Value))  Now here is the problem: Some months don't have contractors so there is a 0 displayed at the bottom of the X-axis. I don't want this to happen! I already tried to change the expression of the point labels to this: =IIF(Sum(Fields!HeadCount.Value,"chart1_SeriesGroup1") > 0,Round(Sum(Fields!HeadCount.Value),1)," ") But this keeps displaying the 0. Even if the last parameter in the previous expression is 'nothing' it is still displayed. I hope it is possible to remove them ...   ...Show All

• vicky_dceian Max function

  Hi, The question is about the way max function works in SQL. I have to implement a database design where in i have to write a stored procedure which will perform an insert in the table/tables. This table/tables will in the long run have a large number of records, i have been instructed to create another table (lets call it tableA) which will have the primary keys of all the other tables and their respective maximum values being used. While performing an insert into one of these tables, i will have to probe the tableA and find out the currently used id for that table ( in which i have to insert a new row) and use the value for insertion. According to me, we can use a max clause in the stored procedure and achieve the following or use an I ...Show All

• Chinwa KneeHo What is SQL?

  my apoligies for the simple question. i have just had to load sql server onto my desktop in order to use some software called OnTime. OnTime needed to buid a batabase. so i undestand sql server can make databases. im after a real basic paragraph stating what sql server is or can you point me in the right direction Can web sites be loaded onto my SQL server Can other computers access my SQL server Is it purely just for databases Development of SQL Server: http://msdn2.microsoft.com/en-us/sql/default.aspx Product info: http://www.microsoft.com/sql/default.mspx In a nutshell SQL Server is a Relational Database Management System... It is an application that manages databases! thanks for info i have ordered ...Show All

• KonRi SQL Server dumping continuously after running SSIS package

  My problem is the following: I've created a SSIS package that will run without any problems in my development environment, but when I move the databases and SSIS packages to another testenvironment it will trigger the SQL Server to dump on every sub-sequent command. The chain of events: Create the SSIS package and databases in my development environment. Run tests wich has no problems. Move the SSIS package and create backups of the database from my development environment and restore the database in the testenvironment which is in an different AD using an AD-account from that AD. I run the SSIS package without any problems. But when I look in the SQL Server logs I can see that the SQL Server is dumping on what I pr ...Show All

• Rocco Mastrangelo Insert Images in SQL 2005 express DB, using C# code for asp.net 2.0 (VS 2005)

  Help! I found about a dozen samples and articles in the net about inserting images in a sql database, but they were either using VB, or asp only or SQL 2000 and although I tried them all, none worked... Can you help me by posting some code on how to insert images in SQL 2005, using C# in Visual Studio 2005 (asp.net 2.0) Thanks. Can anyone show how the above code would look, adjusted for use with the file upload control in ASP.NET 2.0 Hi, I'm very new to asp.net, but I think it'd be better coding this //Create a new filestream object based on the file chosen in the FileUpload control FileStream fs = new FileStream (ImageUploadToSQL.PostedFile.FileName, FileMode .Open, FileAccess .Read); //Create a binary ...Show All

• CalinMac SQL Server does not allow remote connections

  Hello , The problem is that we are having Problem while making the remote Connection to the Sql Server 2005 Basically We are having a problem connecting to SQL2005 through a package remotely. when we try to connect to a remote data base, we get the following error [Connection manager "CRA LRRS Development DB"] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Login timeout expired ". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "An error has occurred while establishing a connection to the server. When co ...Show All

• Ravi Kite Autogrowth values keep changing

  Hi! We have 2 dbs on our dw-server and the autogrowth values for both the data- and logfiles on both of these dbs changes about once a month. The data autogrowth value changes from 10megs to a percentage value between 3200 and 6400 and the log-file value changes from 10 percent to a percentage value between 3200 and 6400. Resulting in huge files and filling the drive. What am I missing here BR John Not a helpful reply, it can and it does. I have now experienced the same bug myself. SQL 2005 on x64, has been running okay for months. Last month the database jumped from 3Gb to something like 60Gb, I found the autogrowth setting had switched from xxMB to 2048%. I thought I must have done this by ...Show All

• WayneSpangler Report showing #Error when using the custom assemblies in the popup preview window

  Hi all I am trying to create an rdl (server report) in reporting services 2005. I am using my own assembly file as data source. That assembly file is placed on server. I am accessing it by registering it in report properties using Business Intelligence Solutions Explorer(.Net IDE). My problem is that when I try to view the report in external preview window, instead of showing data it shows "#Error". But when I open the report in Preview tab, it shows me the data. According to some documentation it seems to be a security related issue. Documentation says that in preview tab, it only loads the report without implementing any security, but in case of external preview, it loads all the security. Can anyone here help me to resolve this issue. ...Show All

• Michael_Giagnocavo Canot Telnet into port 1433 affter intalling SQL Server !

  I'm working on a completely virgin install of SQL Server 2k in Windows 2003. Just after install I check that the TCP/IP protocol is enabled under the server properties and then I try to Telnet into port 1433. On this one particular box I get back the following: C:\>telnet localhost 1433 Connecting to localhost...Could not open connection to the host, on port 1433: Connect failed. For comparison I tested telnet on a couple other machines and I get back a blank window ready for my commands, as I'd expect. I've checked the firewall settings and other IP Filtering settings to see if any of those were blocking traffic to 1433... nothing. I've triple checked the SQL Server settings for any "problems" and nothing jumps out at me. ...Show All

• Brandon T Perry Convert Long to Datetime

  Hi. I need to convert a vb function into a user-defined function in a stored procedure. The vb function converts a long datatype into Date datatype. Here is the VB function: Function LongToTime(lTime As Long) As Date LongToTime = (lTime \ 10000) / 24 + ((lTime Mod 10000) \ 100) / 1440 + (lTime Mod 100) / 86400 End Function The function is used to convert a timestamp(hhmmss) into a more readable format. Would it be possible to create a function similar to this in SQL Thanks Wes hi there is no mod function in sql server you have to use % i think you can go ahead from here regards % (Modulo) Provides the remainder of one number divided by another. Syntax dividend % divi ...Show All

• susy_pmm Need help with OPENQUERY and Insert statement

  I'm trying to Insert data from a linked server connection into one of my tables in the sql database. it seems to be giving me an error saying column cant be found. It only does this when I put the Where clause in the statement. I dont have the server in front of me but this is how my statement looks. Insert into WorkList (DSK) Select * From OPENQUERY (SCH, 'Select Desk_ID from public.ACCOUNT Where Desk_ID = LA1') The error that I get is the LA1 column cant be found any help thanks This is using a linked server connected by ODBC connection. When I leave the where clause out of the statement below I get it to work perfectly. Even when I put criteria for another field it works, but not when I use "Where Desk_ID = "B01 ...Show All

• TedWagner SQL Recovery Mode

  Hi, How to make all MSSQL DBs run in Simple log form by default other than FULL so when we srhink DBs the logs will go bybye. :-) Thanks If posts address your questions, please mark an answer. Thank you. Yes Please. Sample Script would be gr8 :) Thanks a lot. Can I please have script to set the recovery model simple for all new created db as default. Thanks again. I did it already No need for a script. Just change the recovery model of your model database to simple . Every database you create will have the settings you specify for your model database. SET NOCOUNT OFF DECLARE @strSQL nvarchar(50) DECLARE @databaseName nvarchar (255) DECLARE MyCursor CURSOR FOR --used for cursor al ...Show All

• TonyMan - MSFT No more datatype TIME in SQL 2005...what to do???

  I understand that SQL 2005 doesn’t support TIME ( which is, for me, incredibly weird). Now, could anyone please help me solve my problem. I want to make it possible to insert into database a start-time for the first runner in a team. And when he finishes, a finish-time. This finish-time I will also use as a start-time for the second runner....a.s.o. Furthermore I want to be able to get the results from the database to present them in several ways. This also means I can't simply insert the time as a string since it won't change hour at every 60 minutes. I have read somewhere that it should be possible to create own datatypes, but I have absolutely no knowledge to that. Could anyone please help me ...Show All

• vtortola rsInvalidReportServerDatabase

  We are getting the following error when we try to deploy SQL report on to the reporting server the error: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.20'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase) We are using SQL server 2005 CTP and .Net 2005 beta 2. the OS is Win xp and the reporting server is the local host. Thanks a lot in advance. Thanks & Regards Jayan we used the reporting service config tool to configure the service also we created new database to be used by the reporting service(both reportingservice & reportings ...Show All