Answer Questions

• jam281 problem with query

  Hello , Actor ANO ANAME A1 L Tree A2 D Pond A3 M Lake A4 J Worthy A5 T Gross A6 L Leaf   Movie MNO MNAME M1 Work a lot M2 Sleep too little M3 Too much fun M4 Laugh and Cry    PLAY ANO MNO Pay A1 M1 $77.00 A1 M2 $80.00 A2 M2 $93.00 A2 M3 $88.00 A2 M4 $91.00 A3 M2 $74.00 A3 M3 $89.00 A4 M2 $75.00 A4 M3 $85.00 A4 M4 $55.00 A5 M1 $50.00 A5 M4 $61.00 A6 M2 $77.00 A6 M3 ...Show All

• mabxsi finding the date of the last thursday

  can anybody help me with the query to find the date of the last thursday for the given month. is it possible to do it without using any kind of loops. Thanks in advance Jacx Yes you can.. use the above function dbo.GetLastWeekDayof it does the same what you need.... i actually wanted to find the date of the last thursday of the given month. for example if i run the procedure of function on any day of jan i should be getting 25 jan as the result. i did it using a while loop but i wanted to know if its possible to do without using loops my query is as follows DECLARE @Dt Datetime select @Dt=dateadd(m,1,(getdate()+21)-datepart(dd,getdate()+21)) While(datepart(dw,@Dt))<>4 BEGIN Set @Dt=@Dt-1 ...Show All

• Orchid2006 Deploying reports on remote report server

  Hello all, I am trying to deploy my rdl's to a remote report server. I have given a valid path in the properties window before deploying...https://RemoteServerName/ReportServer. Now I get the error : Error 1 The permissions granted to user 'domain\user' are insufficient for performing this operation. what permission do I need on the remote server for deployment Thanks..... You specify the deployment folder on the Report Server project properties (TargetReportFolder property). If you want to have access to all folders, grant your account Content Manager rights on the root Home folder in the Report Manager. Hi I got the same issue. I tried to follow the steps given above. This is the first time I am deploying a repor ...Show All

• Andrew Buyan Recovering dropped SQL database

  I am in a big trouble , accidently i have issued a DROP DATABASE XXX command in the sql client, thinking its a local server....... The whole 4 months of database database is now dropped. Please help me , how can i recover the database .... thanks in advance If you don’t have a backup of the data, I will have to tell you, that there is no UNDO button for that. Sorry. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• hazz RESTORE LOG with different recovery path

  I'm trying to RESTORE LOG with a different recovery path. Is there a way to do this I'm getting the below error. I know I could RESTORE from the beginning, but need to RESTORE the log file to the same database schema but different database and server. What steps do I need to do This backup set cannot be applied because it is on a recovery path that is inconsistent with the database. The recovery path is the sequence of data and log backups that have brought the database to a particular recovery point. Find a compatible backup to restore, or restore the rest of the database to match a recovery point within this backup set, which will restore the database to a different point in time. For more information about recovery paths, see SQL Se ...Show All

• GN how to deploy a solution created onto different system

  Hi, I have a solution with it packages, and the solution is running. Now, I want to deploy the same solution onto other server machine. What would be the best way to do this Any suggestions regarding this Hi Manish, If you right-click your SSIS project and click Properties, a project properties dialog will display. One of the options under Configuration Properties is Deployment Utility. If you select this option, you can set the CreatDeploymentUtility property to True. A Build will then create a file with an *.SSISDeploymentManifest extension in the path specified in the DeploymentOutputPath property. Executing *.SSISDeploymentManifest will start the SSIS Package Installation Wizard, w ...Show All

• bminard Getting List of Database

  I have a 2 query here ; 1. That get's all the Database in a Server (a) 2. Get's all Table in Database (b) but the problem i ha a.) SELECT table_name = sysobjects . name FROM sysobjects where sysobjects . xtype = 'U' b.) select * from master . dbo . sysdatabases order by name , dbid Is there anyway i can join this query ex. Database containing list of tables Thanks this gives u all u want..i guess..!! select * from information_schema . tables OK, as there two having different scope, one server level and other database level, so these two dont have direct join. We can help you, if you tell us, what ex ...Show All

• Corrado Cavalli AS 2005 modeling question

  Hello everybody! We have three fact-tables with a classic hierarchical order: -customer table -order table -order positions one customer has multiple orders and one order has multiple order positions and we have one dimension articles related to the position table. Further we defined a count measure for each measure group. The question is how can we connect the articles dimension (related to order positions measure group) to the customer measure group to get a count over customers We tried to use m:n relations. It was not very fast (10 million fact rows). Any ideas to model this 1:n scenario fast and clever ;-) Thanks in advance Ole J. Any ideas Thanks in advance! Ole J. ...Show All

• hrubesh Where is DataDirectory ?

  Hello, I see that one of the new features of SSEv is DataDirectory support. Where is DataDirectory pointing to Is it the same directory as the program ".exe" file Thank you Tom Hi, | DataDirectory | (enclosed in pipe symbols) is a substitution string that indicates the path to the database. It eliminates the need to hard-code the full path which leads to several problems as the full path to the database could be serialized in different places. DataDirectory also makes it easy to share a project and also to deploy an application . For example, instead of having the following connection string: "Data Source= c:\program files\MyApp\Mydb.sdf&quo ...Show All

• James S Lapalme Cannot Install SQL Server 2005 Developer Edition - Minimum Requirements

  I am having the same issue and can't find out why it fails on the minimum hardware requirements. I was looking at firewall issues, AMD Turion Mobile 64 clock speed issues, but can't seem to get past this issue. I've tried express and developer with no sucess. I'd love to see an answer from microsoft on this one. I've found that I can only install SQL 2005 from local media on Windows 2000 - you're not attempting to install from a network drive, are you No. I am using MSDN Disk 3097.1 and the PCs DVD reader/recorder. Here is an excerpt from SQLSetup0001_586III800205_Core(Local).log : No Instance Name provided on the command line If possible, deter ...Show All

• Gurpreet Singh Sawhney OpenRowSet and OpenDataSource Fail on Production to open Excel data

  The following statement fails when using SQL Analyzer under sa but works on all of our development and staging server. All are SQL Server 2005 SP1. We upgraded production over the weekend from SQL Server 2000, creating a new instance machinename\SQL2005. SELECT * FROM OPENROWSET ( 'Microsoft.Jet.OLEDB.4.0' , 'Excel 8.0;Database=d:\data\test.xls' , 'SELECT * FROM [Sheet1$]' ) The error we are getting only in prodcution is: OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server &q ...Show All

• Zero_ Select Case, Custom Code to Select Field

  Hi, I am moving from Crystal Reports to Reporting Services and need a bit of help with a Profit and Loss Report; I have a table in my accounting software with the following fields: Account Name, Balance01, Balance02, Balance03,..........Balance12; I am writing a monthly profit and loss report; I've created a Report Paramater called "Month" I want to the user to select the month they want to run a Profit and Loss Statement for; Where January would be Balance01, February Balance02 etc. I have written the following custom code: Function Balance(Month as String) Select Case Month Case "January" Return Fields!BalanceThis01.Value Case "February" Return Fields!BalanceThis02.Value End Select ...Show All

• dweeks Using Datediff

  Hi All I am having a few problem writing this query, I need to find the difference between two times within the same table. The table looks like this: id sessionid timestamp 48012 SESSFINISH 2005-01-11 10:48:00.000 48012 SESSSTART 2005-01-11 09:11:00.000 48013 SESSFINISH 2005-01-11 14:51:00.000 48013 SESSSTART 2005-01-11 13:32:00.000 so for id 48012 i need the difference between the start time and end time Thanks Rich Thanks for your help Richie: I would use a "self join" to find the time difference; a sample of a self join follows: declare @ ...Show All

• comtel_95 searching with LIKE operator using parameters

  suppose that i want to build a simple search based on LIKE operator. there are few parameters that are supplied for search say @name, @address, @comment, @hobbies. IF the user may supply name and address then the search should be carried out using LIKE operators for name and address only and similarly the LIKE operators should be applied to those parameters that are supplied. how to do this any suggestions Please help! Like to add one more small comment with Jens K. Suessmeyer Ensure your @param values hold the '%' wild card pattern.. It may be end of (@Param +'%') or begin of ( '%' + @Param ) or enlclosed with ('%'+ @Param + '%')your param value.. If you are missing the WildCard pattern on LIKE then it will act as EQUAL(=) oper ...Show All

• Florent Montsegur WMI alerting error

  After installing SQL Server 2005, I tried to create a WMI alert by doing the following: USE [msdb] GO EXEC msdb.dbo.sp_add_alert @name=N'Database Created', @enabled=1, @delay_between_responses=0, @include_event_description_in=0, @wmi_namespace=N'\\.\root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER', @wmi_query=N'SELECT * FROM CREATE_DATABASE', @job_id=N'00000000-0000-0000-0000-000000000000' GO This produces: "The @wmi_query could not be executed in the @wmi_namespace provided. Verify that an event class selected in the query exists in the namespace and that the query has the correct syntax." Now, I have done the install many times on a VM box and believe to have tracked it down ...Show All