Answer Questions
Adam Miles How do you SELECT just one row?
Hi All... How to you SELECT just one row from a table when you dont have something to match a field with That is how would I get only the first record with the following statement: SELECT * FROM MyTable ORDER BY DateAdded Thnx! --- Curt SELECT TOP (1) * FROM... Use the "TOP" option: SELECT TOP 1 * FROM MyTable ORDER BY DateADDED -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 -- " "CurtisDeHaven"@discussions.microsoft.com " < "= UTF-8 B Q3VydGlzRGVIYXZlbg== ="@discussions.microsoft.com > wro ...Show All
Simonsbs SQL Server
What are the different method to add security to sql server database WHat do you mean by that, in terms of administration liek the GUI or TSQL commands or security on object level or data level HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All
Polina159216 find out what tables contain a specific column
I want to write SQL that will search the tables in a database for a specific column, like this. For instance, I have a column "Unique_ID" that is in many of our tables (hundreds) but not in others and want to find out the tables it is in. It is always the first column. I tried to find a system stored procdure to do this but couldn't and tried to create a script using the sysobjects and syscolumns tables in the Master db, but came to a roadblock because they don't seem to be related at all. I would surely appreciate if someone else has already done this! Thanks! WONDERFUL! Just what I was looking for. Thank you so much! Try this way. If you still don't get anything, then you have other "issues". ...Show All
TomsiKa RDLC printing/scaling issues?
I am trying to print a .RDLC file programmatically as per the article here: http://msdn2.microsoft.com/en-us/library/ms252091.aspx . The only difference is that I am actually printing to a real printer (HP 1320n). I am doing this in the context of an ASP.NET web service. The issues that I am having are that when I execute the web service on my development workstation running IIS, the .RDLC prints to the network laser beautifully; but when I try to run the exact same code on the server (Win2003 SP1), the report prints, but is scaled up by about 125% so that it doesn't fit on the printed page. This is obviously very frustrating. I have the same driver version installed on both machines, the drivers are configured identically, and th ...Show All
setareh Challenge with SQL Express Installation
I am having a problem with the installation of SQL Express. the uninstall program says that part of the Beta is still installed. then the uninstall program crashes with a syntax error saying that in wrong place. found it deleted it and then the program will not continue. i cant find any remnants of the beta but SQL Server express will not install!! Please help. where would i find the setup log Check out the Setup log, it will give specific information about what components are still installed. If those components are not listed in Add/Remove Programs, you can uninstall them using: msiexec -x <product ID> Product ID will be listed in the setup log. ...Show All
Alessandro Camargo Duplicate Values on Top Level of Dimension
Hey there community, I have a problem, and i am lost as to how i can fix it.. I would be over joyed if someone can give me a hand in identiffy it.. I will try to explain below:: I have a cube for sales, that displays sales by a Market heiracy of Market->Division->Family->Item. When i drill down, sales numbers look fine.. I added in a budget file, which only specifys budgets down the the Division Level.. I have added the Budget Figure as a Measure Group. In the dimension usage tab, i specify the Division as the Granuality for the Budget Measure Group on the Market Dimension.. Measure Groups Dimensions Standard Measure Bu ...Show All
wtmmag Cannot connect to localhost using Windows Security Group as login
I have a test environment set up at home with a small windows server 2003 Active Directory domain. I created a windows security group on the dc and added myself and another user to the group. I then use this group as a login for SQL Server and add the login to the sysadmin server role. This works exactly as I would expect on the Windows Server computer (which is also the Domain Controller) regardless of which computer I use to connect to this Windows Server computer. However, when I set up the exact same login on the local sql server instance of my client laptop running windows xp pro, the I get an error message (Login failed for user MYDOMAIN\dgolds...) when I attempt to connect to the local instance of SQL server, even though I am able t ...Show All
Daniel_laksjdhfg saved package gets corrupted
Hi, I am facing a problem. I have custom data flow transformation.We have saved a package using component's earlier assembly version. Now when we install later version of the component the saved package fails to open. If I try creating new package it succeeds. Error message : Error 1 Validation error. Data Flow Task: DTS.Pipeline: The component metadata for "component "Oracle Destination" (153)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. Package.dtsx 0 0 We tried overriding "perform upgrade" method but still I am facing the same issue. Dharmbir There is a good sample on how to overridfe PerformUpgrad ...Show All
lbugnion New Server Registration offers no Server Name options
Real newbie question this, I suppose. (Apologies if in the wrong forum!) Have just downloaded and installed SQL Server Express. When I attempt to start it up, the New Server Registration dialogue box appears. When I attempt to enter a Server Name, there are no options in the drop-down box except <Browse for more>, which then offers me neither Local Servers or Network Servers. The machine is running XP Pro and I wish to use the SQL package to develop on the PC as a stand-alone environment while I evaluate it. So what am I doing wrong Many thanks in advance for any help. Duh! I realized that I had only downloaded the Management Studio package and not SQL Server itself. All working no ...Show All
prozac11 How to connect via ODBC
Hi, I would like to connect in SqlServer 2005 via ODBC SQLServer, how are the steps 1 - How can I connect ODBC 1.1 - I need SqlServer 2005 name - ok 1.2 - Which option should I take in order to login Windows NT authentication or Sql Server authentication Which one is the best option Cheers, Alessandro Hi, - I picked windows authentication. I can not use OLE DB from my application. I've created one windows user and created one login, but I still getting " Not associated with a trusted SQL Server connection". I changed Surface Area configuration and Configuration Manager as well. I heard that I nedd to enable mix mode option, how can I do this thanks You haven't told me anythin ...Show All
Koelho Interactive sort changes time field values to 0
Hello all, I have a report which connects to a Pervasive database via an ODBC connection on the reporting server (RS2005). When I initially bring the report up, a time field (OdbcType.Time) shows the correct format: hh:mm:ss. When I sort any of the sortable columns on the report, the time field (which is not sortable) values all change to 0. Backing out of the report and re-running it restores the correct time values. Any ideas Thanks, Ken Thank you Fang. I have submitted a bug report and uploaded the files. Thanks for your time Fang, I've pasted the snippet for the field in question: <Field Name="TIME_RECEIVED"> <rd:TypeName>System.TimeSpan&l ...Show All
Tom bernard Reporting services:Can't display parameterized multiple charts
Hi, On a report I have created two datasets (X and Y), with same fields and report parameters, just the queries pulls data for two different regions. Now, I am trying to display the data on two different charts,on the same report, that would receive the same number and type of parameters. The first chart for region 'X' (dataset 'X')displays correct data; but the second chart doesn't display data for region 'Y' (dataset 'Y') though the parameters supplied is same.Please help. ...Show All
Moim Hossain Nested case?
IS it possible to use nested case statement in TSQL,if yes what is the syntax of it I m using SQL 2005 thanx its possible...here is an example/syntax... declare @var1 int declare @var2 int set @var1 = 1 set @var2 = 1 select CASE @var1 WHEN 1 THEN ( CASE @var2 WHEN 1 THEN ( 100 ) ELSE 99 END ) ELSE 98 END thanx very much.... this is the thing i asked for ...Show All
Yodatg Specifying the Role Cache Refresh Frequency in SSAS
Hi all How can i specify the Role Cache Refresh Frequency in SSAS 2005. The msdn mentiond this option in: http://msdn2.microsoft.com/en-us/library/ms175424.aspx The option not exists in the Managment Studio as mentioned. Thank you. Shlomi Hi Your document not contains the RoleCacheExpirationInterval that specified by the mentiond article. Do you know somthing about this property You can access Anlysis Server configuration file (msmdsrv.ini) directly by going into c:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\Config. You might need to restart Analysis Server after changing it's properties. Please also be aware changing some of the advanced proper ...Show All
april.louise Service problems after SP1 upgrade
We have an instance of SQL 2005 enterprise that was upgraded to SP1 over the past weekend. This instance has been very stable and the server hardly ever has any issues. After upgrading to SP1 a couple times a day SQL service has been terminating unexpectedly. The following events are being logged - Application Log: Event ID 17311 SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart). SQL Ev ...Show All