Answer Questions

• e_LA how to create a sql database in the server?

  Hi, I want to create a new database in the server using SQL express,not in the local machine. so what can I do Thank you HI, as stated you may find it in Drive:\Program Files\Microsoft SQL Server\MSSQL\Data and after login in SQL Server you may run sp_helpdb yourdbname , which will gives you detail of the data/log files . Hemantgiri S. Goswami Hi all, When I try to connect to the server using sql express, I cannot find the name of the server instance. So does it mean the sql express should be installed in the server Thank you Hi, I would like to know whether one of the causes of such error is that sql express is not installed in ...Show All

• Allan-Nielsen SQL For-loop stored procedures

  i want to grant exec permissions on all of my user stored procedures. but this process of writing 'grant exec sp_tblAction on public' for each procedure would take years. how can i write a query that loops through all stored procedures, checks if it is a user created procedured, and then grant exec permission for that procedure can it be done tx, Wilmar I completely agree with the sentiment, and this is why I would rarely do this with the dbo schema going forward. So if you subdivide schemas down to functional areas, this is less likely to occur, but you are right, it could be an issue. I also don't use the public group for anything unless it is a generic object that simply everyone needs access ...Show All

• Batkuip Incorporating Data Mining Wizard into a program?

  Is there any way to incorporate the SQL 2005 Mining Wizard into my program Sure, I can create my own mining wizard using DMX, but that's quite a bit of work. Has anyone tried this Is it possible Any pointers -Young K Unfortunately the Data Mining wizard is not a seperable component and is not intended or licensed for reuse in other programs. You're welcome Thanks. I thought as much. Also, thanks for the webcasts, Jamie. They are quite helpful. -Young K. ...Show All

• WebSigMan I have a simular problem as clay.routh, Can you help me please?

  Here is my sumary.txt log file from SQL Express. Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Microsoft Windows XP Home Edition Service Pack 2 (Build 2600) Time : Sun Aug 27 08:16:07 2006 HOME-D84394AF4F : Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Ed ...Show All

• PatOvens KPI that compares the growth over years

  Hi there, I'm new to SSAS and MDX. Creating my first dimensions and cubes went fairly fine. But now I hang on KPI. I'm trying to create a KPI which shows the growth of bookings comparing one year to the previous year. I want to set a fiterexpression for the time-dimension (e.g. YearString equals 1998). If a filter is set, it should show the bookings for that year ([Measures].[Bookings]) as value and the bookings of the previous year as goal. My problem is, that I cannot access the selected YearString, to get the bookings of the previous year. I tried the function parallelPeriod() and also a self-created Calculation, but it seems that [dimension time].[hierachy].CurrentMember is always [dimension time].[hierachy].[(All)]. My data structure ...Show All

• Ben Paddick Obtaining Login ID from page

  Hello, By using DBCC Page I am able to exemine data entered to row and other changes related to the rows. What I want to know is; is it possible to find out (and how) which Login ID commited these change directly from pages or where do I need to look to find it out Any guidance is appreciated.... Two parts to this answer: 1. We don't document the on-disk structures except by special licensing/NDA agreement with ISVs 2. That information is not on the page anyway. ...Show All

• VoiceOfExperience Table cells...accessing a value

  hello All, I am trying to now access the data (if any) in the current cell of a table. I want to know if this cell has been populated, and if so to move on...if not then I want to populate with a zero. I am using the following: ReportItems!textbox9.Value inside of an if statement but it tells me that I am unable to do so as, and I quote: "The Value expression for the textbox 'textbox 9' contains a direct or indirect reference to itself. Loops in expressions are not allowed." Any ideas guys Try putting this in your textbox9 expression: =iif(len(Fields!<FIELD_NAME>.Value) = 0, 0, Fields!<FIELD_NAME>.Value) Replace <FIELD_NAME> with the field that you are trying to display ...Show All

• Greg Van Mullem event id 208 on sql server 7 HELP

  Hi, For some strange reason all of a sudden, my scheduled jobs are not running. I dont remember changing anything that might cause this but i cant say for sure. The other issue i have is that i cannot backup a database to the default location as shown on the second even below. Any ideas Thanks for your help Event Type: Warning Event Source: SQLServerAgent Event Category: Job Engine Event ID: 208 Date: 08/09/2006 Time: 12:00:01 User: N/A Computer: SERVER1 Description: SQL Server Scheduled Job 'DB Backup Job for 'DBMP-EDB'' (0xC50AD7AF9993294A8134D2F7D10C0ADC) - Status: Failed - Invoked on: 08/09/2006 12:00:00 - Message: The job failed. The Job was invoked by Schedule 23 (Schedule 1). The last step to run was step 1 (Step 1). ...Show All

• hazz SQL Express Advanced with Sharepoint Services.

  Hi I've recently upgraded from MSDE (SBS 2003 SP1 with .NET 2.0) to SQL Express SP1. I am trying to enable full text sarching on the Sharepoint instance but whenever I go to Sharepoint central administaton and text sarching it reports that the SQL server installed does not suport this. I can't find any documentation on this anywhere. Admidatley the machine is a domain controller and I know this isn't recommended but surely this shouldn't stop this from working All components where selected when installing SQLExpress and I recieved no errors. Any sugestions would be greatly appreciated. Many kind thanks Gareth Gareth.Hunter@gmail.com You can not switch the Sharepoint Instance to us ...Show All

• Matt Duffy T-SQL Code help

  Hi, When I execute the following procedure, SQL Server creates an error called 'must declare @table variable'. So I did not overcome this error. Would you please help me CREATE PROCEDURE erase @column nvarchar(25), @erasable nvarchar (25), @table nvarchar(25) AS delete from @table where @column=@erasable Hi again, I learned the answer. When we use exec statement for Strings, the batch in the String is also compiled and executed but this is only valid for Strings, is not it Hi I don't quite follow what you mean. Basically the code that I posted (and oj) simply builds a dynamic SQL String and then executes this string. If the dynamic string was a SELECT statement then when the string is executed the results would be dis ...Show All

• Crusty1 Error in send email task

  I have a script task in which I check the size of a file. If the size of a file is greater then 0 KB then I need to send this file as an attachment using send email task. If size is equal to 0 KB then I don't want to send email at all. In the script task, I have a flag(@sFileExists) which i set to true in case of size of file greater then 0 and false in other case. I am using a precedance constraint (Expression : @sFileExists=true) and condition is logical AND. After script task based on the condition (@sFileExists=true) I am using the send email task for sending the email. But I am not receiving the email. Please sugest where I am wrong. Please note that the send email task is working all-right separately. ...Show All

• TrevorW groups in reports

  I have grouping in my report...   when the user selects print...is there a way of opening expand all the grouping   Thanks got it working - had to set the visibility of detail row! Thanks again! :) I forgot to mention that I am using Reporting Services 2000... will this still work ! I noticed when I go edit Group - Visibility it has: Visibility can be toggled by another report item... but it is disabled ! I tried to do as you advised: now if the user selects true group has - toggle and when false +toggle..... but when its true it doesnt actually drilldown... Thanks Hi- I don't believe there is a ...Show All

• Paul Teal update

  hi i cant use update like this. how set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo] . [tt] AS BEGIN SET NOCOUNT ON ; DECLARE @t1 TABLE ( a int , b int , c int ) DECLARE @t2 TABLE ( a int , b int , c int ) insert into @t1 select a , b , c from table_1 where a = 1 insert into @t2 select a , b , c from table_1 update table_1 set c = @t1 . c where ( @t2 . b = @t1 . b ) END Can you post a bit more full example, with data. It doesn't make complete sense yet... select * from table_1 update table_1 set c = ( select ( c ) from table_1 b where table_1 . b = b . b and a = '1' ) ...Show All

• cmendozas Report Manager not responding

  Hi, I'm hoping to get some help here. I've spend countless hours trying to get Reporting Services running without success. When I run the Report Manager it does not respond. Coming up with Opening page http://localhost/reports/Pages/Folder.aspx . . . The progress bar ticks along but the page never actually loads. The Configuration tool shows green icons everywhere. No errors in the Event viewer. I am running Windows XP Professional with SP2. I have uninstalled and re-installed IIS, ASP.NET and SQL2005 numerous times. Varying the order, all without success. What else is involved I have loaded Service Pack 1 and the latest hotfixes. What else can I try Thanks in advance, Claude Are you abl ...Show All

• Cobaia Integrate more than one SSIS packages into one package

  Hi I'm new to SSIS field. I'm importing data from flat files to sql server 2005 through SSIS packages. I have around 30 packages which transfers data from flat files to corresponding database tables. I want a single package that will run all the 30 packages by running that single package. Like in a single stored procedure we can run multiple stored procedure, I want the same solutions for my packages. Is there any method which can solve the above issue Please kindly guide me . Its urgent. please reply soon. Thanks in advance. priyanka.dash wrote: Is there any better approach to integrate packages into one package My target is to create a single ...Show All