Answer Questions

• Kolf Filtering on a part of a field - 2

  Hi, I got a problem which looks like the same with a futher topic of me ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1156355&SiteID=1 ), but this one is a little bit more difficult. I want to set a filter on a field, but the it must set a filter on a part of the field. I think it will be more clear with an example: I have a list with ItemNumbers and ItemDescriptions. ItemNo ItemDescription 1 Pineapple yellow 2 Cauliflower size 6 3 Orange sweet yellow etc. etc. Now I want that the user of this report can set a filter just by entering a part of the description. So, if he enters 'flower' he only see the cauliflower. If he enters 'yellow' he only see the pineapple and the orange, etc. etc. If a ...Show All

• S_A_S Transactions - Back to Basics

  Hi all, I am having no end of trouble with transactions in the package which i am building. I now just want to go back to basics and see if someone can tell me where i should set specific transaction options. Firstly, my package runs a for each loop which loops through a directory of directories. In each of the sub directories there are 2 files. The first steps in the loop are to check if a folder has been processed previously, if so then it moves it to a specified directory. The reason that this is done first is that i cannot move the directory whilst it is being read in the foreach loop, so i pass the path to the next iteration of the loop. There is another file system move directory task outwith the foreach loop to deal with the last di ...Show All

• hailong1977 Reporting service not starting - The user or group name 'VIDICOM\ASPNET' is not recognized.

  Hi, I've been trying for the past week to get SQL 2005 Server up and running. The SQL is up and running however I am unable to get the Reporting service to start. The log file is below but the main line is: ReportingServicesService!library!4!29/06/2006-14:33:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'VIDICOM\ASPNET' is not recognized., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:The user or group name 'VIDICOM\ASPNET' is not recognized. But the domain user ASPNET is present. Similar posts across the internet mention about the .NET Framework not be installed correctly. I have reinstalled it many times. Any help is most ...Show All

• PatrickDonohue Questions on backup and report services

  Hi, I am thinking of using SQL and VB express for a project. Reading different versions information lead me to the following understanding on bakups and report services. Please comfirm my understanding or correct me if I am wrong. Any suggestion is always welcome. 1. SQL express does not include Agent Job Service so I cannot schedule a backup job or daily report to run automatically at a specific time. Is there a work around on this 2. If I install the SQL express with the Advance Services edition, I still have to install the express tool kit to get the business intelligence developer studio in order to generate the reports. Do I have to install both on the same machine (the server) or the advance edition on the server and the too ...Show All

• jchau how can i check date, hour and minutes only?

  I am using this code to insert starttime and endtime. INSERT INTO working_schedule ( id_number , starttime , endtime , created_user , created_pc , created_version , created_domain , created_os , created_workingset ) VALUES ( @id_number , @starttime , @endtime , @created_user , @created_pc , @created_version , @created_domain , @created_os , @created_workingset ) and this code to check for duplicate before inserting.. IF EXISTS ( SELECT id_number , starttime , endtime FROM working_schedule WHERE id_number = @id_number AND starttime = @starttime AND endtime = @endtime ) but it's checking the seconds as well.. how can i only check date, hour and minutes (without the ...Show All

• Kennon2005 need more info on ReportServer.dbo.AddEvent

  can any body let me know in detail on how to use the given below code exec ReportServer.dbo.AddEvent @EventType='TimedSubscription', @EventData='cb1fa94b-1df1-4d7a-8d9a-f4b1d90b5565'. I copied this from one of the web site 'http://www.developmentnow.com/g/115_2005_5_0_0_518701/advanced-report-scheduling.htm' I also need to know like how to setup the subscription to run way out into the future so it will never hit its execution date (you need this to get the id for the subscription). This is mentioned in the same site which I mentioned above. Can you just explain different values for @EventType and also @EventData and from where we get this value for the @EventData Please treat this as urgent and reply ASAP. Thanks in advance ...Show All

• JGreever Is there anything like rowid, rownum like in MySql and Oracle??

  Hi, i am new to SQL Server. I want to write a query where in i want to delete duplicate rows from a table keeping the master copy. If it is MySQL or Oracle we can write that using built in rownum or rowid. How to do that task in SQL Server 2005. Is there anything like rowid, rownum in SQL Server If not suggest me a way to do that ...aazad Thank god .. you are using SQL Server 2005 use the following query Example: CREATE TABLE Table1 ( [Id] [int] NULL ) go INSERT INTO Table1 values ( 10 ); INSERT INTO Table1 values ( 10 ); INSERT INTO Table1 values ( 20 ); INSERT INTO Table1 values ( 20 ); go   With Test ( rownum , ID ) as ( Select Row ...Show All

• KitGreen Dates in Reporting Services

  hey all set up Visual Studio 2005 SQL Server Express / Reporting Services four fields State date Start time Finish Date Finish Time I need to take one away from the other - can someone please help me Is it better to keep these in separate fields or to combine and subtract Is there anything special I need to know with subtracting time I am reasonably newbie still so would appreciate any help thanks I am using the visual side in Reporting services - Data - Layout - Preview. thanks Jewel thanks heaps for replying so I would have a line like this - other info eg Tracker / Description etc would be on the 2nd line and Criteria would be = Closed Call ID Rece ...Show All

• Mikko Nylén Use of user data types for creating local temporally tables in store procedures

  I am able to use user data types for creating local temporally tables in store procedures, but I receive an error at run-time about the user data type. Msg 2715, Level 16, State 7, Procedure SP_SAMPLE_TEST, Line 4 Column, parameter, or variable #1: Cannot find data type D_ORDER_NUMBER. The same user data type is used as parameters in several other store procedures, and they work perfect. It is also used in several table definitions. What am I doing wrong Thanks in advance to any one who can help me with this problem. Diego Sierra User-defined types are scoped at the database level.  Temp tables are created in TempDB -- s ...Show All

• Fradam Silent SQL SE 2005 install headaches...

  Yet another roadblock: Does the standard SQL SE 2005 not install any of the query commands (isql, isqlw, or osql.exe's). I could have sworn that they were, but every time I go to test the install on my VM none of them are ever installed. If it doesn't is it included in the advanced version of it (which I'd really rather not do) If still no what's the easiest option I still have open Can I have my app connect to the master db and run a restore script from the app I've been arm wrestling with this install for over a week and it's just about brow-beaten me completely. TIA, Jayyde SQL Server 2005's command line utility is called sqlcmd.exe - try that with your scripts. Hi Jay, were you able to ...Show All

• Sailu data mining 2000

  i want show other products when somebody choose a product, ect: product1 product2 A B, C ,D B C,D,E C F, G ....... i create model: I create a mining model: CREATE MINING MODEL [bh'S] ([Cusid] LONG KEY , [Products] TABLE PREDICT ([Productid] LONG KEY )) USING Microsoft_Decision_Trees INSERT INTO [bh'S] (SKIP, [Products] (SKIP, [Productid])) SHAPE {OPENROWSET(…, 'SELECT DISTINCT "dbo"."customers"."cusid" AS "Cusid" FROM "dbo"."customers" ORDER BY "dbo"."customers"."cusid"')} APPEND ( {OPENROWSET(…, 'SELECT DISTINCT "dbo"."orderdata" ...Show All

• Zulbaric Large number of rows issue

  Hi , There is a table with the following structure __________________________________________________________________________________ Date-Time of Operation | Message | details | Reason | Username | IP | MAC-Address __________________________________________________________________________________ A user can fire query based on some condition on columns. The maximum no of rows that should be returned are 1 billion. By default the data returned to the view is sorted on Date-Time. Further user can sort the data in the view on Message, details , reason , username , IP , Mac-Address. Suppose i have a scenerio where the user first gets the 1 billion records, then some records are inserted in the database.Then user sort on IP colu ...Show All

• TheVisual Problem with SQLBindParameter

  I am developing an application, using ODBC, that needs to call a stored procedure in an SQL Server DBMS that has a mix of INPUT and INPUT_OUTPUT parameters. I have the code so that there aren't any errors returned from the function calls but I do not see the bound data change after the SQLExecute() function. Code snippets follow. CHAR szStatement[256]; CHAR szBuf[256]; SQLINTEGER irval = 0, filenum = 808042, DoNotCall = 0; SQLVARCHAR vcPhoneNumber[PHONE_LEN]; SQLVARCHAR vcInstanceCode[INSTANCE_LEN] = {0x20}; SQLVARCHAR vcReason[REASON_LEN] = {0x20}; SQLINTEGER rvalLen = 0, fileLen = 0, noCallLen = 10, phoneLen = SQL_NTS, instanceLen = SQL_NTS, reasonLen = SQL_NTS; lstrcpy( szStatement, "exec = some_proc , , , , " ...Show All

• arsonist SQL 2000 Enterprise Memory usage

  Hello... I have a couple servers that are running SQL 2000 Enterprise on Windows 2003 Enterprise edition with 8gig of ram.  However, we cannot seem to get the SQL server to take more than 1.7GB... Is there something that we are missing do we still need to to the /3g switch or any other startup switches Also is it a good idea to set the 'reserve physical memory for SQL Server' option for a dedicated machine Thanks for the help... I can seem to find this answer. and the windows server has the /PAE option set I was checking through task manager but we have a monitoring service that used the performance couters and that is the main data I was going off of.... how do you enable AWE I wa ...Show All

• Tyrone Fay Linked Server B/w two SQL SERVER 05 instances (on differnt pc;s) VERY URGENT

  I created a linked server named CONFUSION (as the machine name with perticular IP say a.b.c.d) TESTED the connection by USE master GO EXEC sp_configure 'show advanced options', 1 GO RECONFIGURE WITH OVERRIDE GO EXEC sp_configure 'xp_cmdshell', 1 GO RECONFIGURE WITH OVERRIDE GO EXEC sp_configure 'show advanced options', 0 GO CREATE TABLE #foo ( pingResult SYSNAME NULL ); INSERT #foo EXEC master..xp_cmdshell 'ping CONFUSION'; IF EXISTS ( SELECT 1 FROM #foo WHERE pingResult LIKE '%TTL%' ) BEGIN PRINT 'Feel free to use linked server.'; END ELSE BEGIN PRINT 'Linked server not available.'; END DROP TABLE #foo; I executed the above code and the result was ::: (13 row(s) affected) Feel ...Show All