Answer Questions

• Markw2004 Cannot change data file setting in management studio?

  Hi There If I go to the properties of a database under Files i see my log is restricted to 2Gig. If i go to the properties of the log file and change the setting to unrestricted and click OK, OK, Nothing changes I get no errors messages and the sql log os clear, however if i go back the file is still restricted to 2 Gig. The DB is in full recovery model. Why can i not change the log file to be unrestricted file size Thanx Hi No i never got a resolution to this. If it is production i reccomend opening up a microsoft case, only way you will get an answer quickly. Thanx Hi I am facing the same issue, did some one find the solution for this Please ...Show All

• Go4More Quick question to check NULL values in input parameters in a stored procedure

  Hi: I have a stored procedure that calls 3 stored procedures. If some of my input parameters are NULL, I would like to skip the call to another stored procedure. Can you someone please help me with this I would like to find out what is NULL, before I execute the other stored procedures. Thanks so much. MA you could use coalesce since coalesce returns the first non null value examples declare @v varchar(40) declare @v2 int declare @v3 int select @v ='1',@v2 =3 if coalesce(@v,@v2,@v2,null) is null begin select 'is null' end else begin select 'is NOT null' end go declare @v varchar(40) declare @v2 int declare @v3 int --will be null if coalesce(@v,@v2,@v2,null) is null begin select 'is null' end else begin ...Show All

• Vaish how to Replicate a creation's table

  Hi, i'v send this email to understand how i can replicate a creation's table between two sql servers the documentation of the replication explain the replication use the alter table !! it's possible to detect with a query this creation of table and start after the replication another solution Regard's Do you mean you want to add new tables to the publication dynamically If so, you can use sp_addmergearticle to add the new table to the publication and it will be sync'ed. ...Show All

• gauls The syntax for 'FORMAT_STRING' is incorrect.

  Hullo All, I am trying to get through chapter 8 of SQL SERVER 2005 Analysis Services Step by Step. When I deploy the cube with a new calculated member i get the following two errors. 1.Error 1 MdxScript(SSAS) (14, 1) Parser: The syntax for 'FORMAT_STRING' is incorrect. 0 0 2.Error 2 Query (5, 1) Parser: The syntax for 'FORMAT_STRING' is incorrect. 0 0 This is the following MDX expression i wrote: IIf ( IsEmpty (([Measures].[Reseller Sales Amount],[Product].[Product Category].Parent),1,([Measures].[Reseller Sales Amount])/([Measures].[Reseller Sales Amount],[Product].[Product Category].Parent) Is there anything wrong with my syntax. Any help will be highly appreciated. Ronald Can you look at t ...Show All

• Jamie Ward Create Mining Structure and Mining Model with code

  Thank you very much for your help. The errors that I can see in the code that you gave in your answer are the following and they are more or less the same as I had previously I tried the code but initially I have encounter the following problems. 1. In any line that have the declaration As Server , As Database like in Public Function CreateDatabase(ByVal srv As Server, ByVal databaseName As String) As Database gives me the problem that type Database is not declared the same type Server is not declared and it does not give me any option. 2. In addition to that for As DataSource, As RelationalDataSour ...Show All

• Xeon_boy Null Checking

  hi i'am very new to this forum of experts... I'am doing a test case where i want to know in a numeric column as eg. below Table x Column Col1 40 88 NULL NULL to apply any aggregate function like sum() do i need to write like sum(isnull(Col1,0)) or just sum(Col1) as SQL server will automatically ignore the NULLS. What generated my doubt here is when i use to do database applications before i use to code like sum(isnull(Col1,0)) as i had faced live problems returning NULLS in calculation but now it seems to be working fine, can anyone explain me is there any type of settings or other things are there which can put light on this. Mat Null values in a column are ignored while an aggregate function is operating.You need not wr ...Show All

• Handra rsactivate error message

  Hello all, Since I installed SQL Server 2005 on the same server than SQL 2000, my Reporting Service is getting me this error: "The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help Bad Data. (Exception from HRESULT: 0x80090005)" I looked over some other logs and forums, and pretty much all pointed to use the rsactivate utility. Well, I am getting frustrated trying to run the rsactivate utility since I typed in the command rsactivate -r and got an error message that ...Show All

• arashikage Specifying Dimensions

  If I have a fact table with dimensions that don't have any attributes other than the dimension values themselves, does it make sense to build dimension tables with only one field (or one field and an ID), or just build the cube using the exsiting fields in the fact table as 'dimensions' Thanks, Kayda This is one of more general questions in datawarehousing. Each of the approaches has it's advantages and disadvantages and you can get quite a bit information about each once you search for it. The short question from analysis services perspective it is better break out dimensions into their own tables. Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• BIG S It's possible to call a view from a different SQL Server?

  dear friends, It's possible to call a view from a different SQL Server I need to create a connection inside one view from the first server to call the second server... Thanks Create a linked server then use a fully qualified object name: SELECT * FROM Server2.database.dbo.view I did it and the point 1. works, but in point 2. with Inner join, doesnt work: 1. (OK) SELECT * FROM GCXNCLISM1S301 . SMS_B02 . dbo . _CPY_OfferManager_1005 2. (NOT OK) SELECT dbo . v_R_System . Netbios_Name0 , dbo . v_GS_COMPUTER_SYSTEM . Manufacturer0 , dbo . v_GS_COMPUTER_SYSTEM . Model0 , dbo . v_GS_PC_BIOS . SerialNumber0 , dbo . v_GS_X86_PC_MEMORY . TotalPhysicalMemory0 , dbo . v_R_System . User_Name0 F ...Show All

• F.Costa Reports behind a domain with SSL

  Greetings, SSL was recently applied to the domain the reports are behind. I have been trying to get the "unsecure dialog" to not appear when viewing a RS report. The report is embeded in a div tag in the aspx page. When accessing the site via https everything still works, if left unchanged, except the "unsecure content" dialog is displayed before the report renders. When I change the URL of the div tag to https:\\<RSSERVER>\<REPORTCOMMAND>, I get the following error: "Content was blocked because it was not signed by a valid security certificate." Anyone know what I need to do to make this work http://msdn2.microsoft.com/en-us/library/ms345223.aspx needs to be followed. ...Show All

• Sniper167 SQL Query Help

  I got a form to return a cd by just entering the movies id. What i want it to do is add a fine to the user if the cd is late and then add it. So i know i need to times the price by dayslate. Rent table contains: cd_id, Member_id, date rented, datedueback, returnedDate, dayslate cd table: cd_id, title, price_band price band: price_band, price, daysRent Member: Member_id, name, fines, noof_cds_rented How should i go about doing this and most of all what would the SQL be to do this Change of plan guys was making it to complicated for myself. What i'm going to do is have two SQL querys. What i need to do is just get the the price of the cd being returned. For this i ...Show All

• TheGreatOtakuKraken Understanding Collation Selection With Multi-Lingual Requirements

  I'm researching the SQL Server 2005 requirements for an application that will support five code pages: English Chinese (Traditional) Chinese (Simplified) Korean, and Japanese I would plan to use only Unicode data types. I'm unsure how collation figures in to this scenario. If all character data's stored as Unicode, do I need to consider which collation I use If so, is it possible to have a single collation that supports these five diverse code pages Thank you. Loosely speaking, unicode is a variation of a data type that allows you to store more characters that you see on an English keyboard while a collation is a sub set of all the characters you can store. overview for Sql Ser ...Show All

• goozbee ReportItems in Page Header

  I've added a hidden field to my report so I can show the value in the page header using ReportItems. However it only works for the first page - the value is blank on subsequent pages. Does the hidden field need to appear on all pages of the report Would I need to make it a hidden field in a repeated list or table Right click on the textbox and bring up the properties dialog, under the Tooltip box, there is the "Repeat report item" checkbox. Make sure that's checked, and pick a data region in the dropdown list. Same problem here. The RepeatWith even tough it is set to the Date Region, isn't repeated at all N, Yes, that correct, but anything in the header is mostly static ...Show All

• Barry Kwok Best way to learn SQL Mobile?

  I am an experienced web developer using PHP and MySql have experience with VB. What is the best way for me to learn programming pocket pc's Is using sql server mobile the best offline database to use as I will be using MySql Compact framework to connect direcly to our Linux server. Any help is much appreciated as I can't seem to find any useful tutorials on quering an sql databse to update, insert, read or delete. I have created a datebase however, I just don't know how to use it. Thanks in advance. Mark Hi Mark, The SQL Mobile is ideal for offline scenarios. You can find SQL Mobile related resource on MDSN. I am providing the links below SQL Mobile page on MSDN - http://msdn.microsof ...Show All

• Colin D Kick all Users?

  Is there a T-SQL command to kick all users out of a database while I run an update One other thing, and this is probably  a network issue, is there any way to pass a  message to the users prior to kicking them out, so they can complete what they were doing Thanks Melt Thanks everyone for the replies and useful info. Regards Melt Thanks a lot for the replies and the code, I don't have to worry abour my users running critical processes, they're all just "SELECT" users. How would I send the NET SEND message Regards Melt NET SEND may not be the best & reliable way to do this type of notification. For ...Show All