Answer Questions
Danik MySQL function equivalent
Hi, In MySQL, from_unixtime(lonvalue) returns the date format in 'YYYY-MM-DD HH:MM:SS'. Is there any equivalent available in SQL Server, to view the date in man readable format, when the input is an long value in milliseconds. Eg : SELECT FROM_UNIXTIME(875996580); Thanks, Smitha Take a look at the CONVERT function in Books Online. It has different styles that you can use. Optionally you can format the string using various datepart ...Show All
ganesh_bestone source database information
Hi, Yet another question. Where do reports store information about connection strings to their source databases and credentials that are used to access those databases. So far I have only found that report rdl file contains info about data sources, but it's in format: <DataSources> <DataSource Name="ExperimentSource"> <rd:DataSourceID>xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx&l ...Show All
nsqtr How to Deploy .mdf Files
Hi Guys, I have a problam. I wanna deploy my application that it has data.mdf file. When I install and test it I get this message: --------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '42000' SQL Server Error: 5133 [Microsoft][SQL Native Client][SQL Server]Directory lookup for the file "C:\Program Files\MyDic\Database\Data.mdf" failed with the operating system error 5(Access is ...Show All
fhunter Connect to remote RS in SSMS
Got following error when try to connect to remote reporting service in SSMS: TITLE: Microsoft SQL Server Management Studio ------------------------------ The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient) ------------------------------ BUTTONS: OK ------------------------------ No problem to connect to reporting service in SSMS on RS box locally. Use windows authentication with same ...Show All
wantowan2 System.Web.Services.Protocols.SoapException: The item '/foldername' cannot be found
I am trying to figure out how to correctly reference the directory to my subscriptions: Dim subs As Subscription() = rs.ListSubscriptions( "/SSS" , Nothing ) System.Web.Services.Protocols.SoapException: The item '/Hedi' cannot be found. ---> FYI: I replaced sss for privacy purposes only here why am I getting %2f in the URLs on my Report Server so this errors out: Error: System.Web.Services.Protocols.SoapException ...Show All
Andr&#233; Brisebois Best way to represent "don't care" values for matching
Hi, I'm curious about the best way to represent a "don't care" value. For example, a subscription contains a CITY field but the user can optionally enter a value for the city. So, if they specify a city then use it in the matching, otherwise, if they do not specify one then any city is considered a match. In the Flight example that comes with SQL-NS they use an * to accomplish this task. Your where clause would end up ...Show All
John Lagnese Could not load file or assembly ADODB, Version=7.0.3300.0
I have an application broadly deployed (about 10 computers). As of yesterday, two of these computers are unable to start the application, and failing with the error below. All other computers run the application just fine. System.IO.FileNotFoundException: Could not load file or assembly 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified ...Show All
slumley MSFT SQL Server Express License question
Do I need a license to use the SQL Server Express in a production environment I thought I needed an existing SQL Server license such as SQL 7 Please let me know. :) When i try to register, the site complains about "*Required: E-Mail Address" I did, (of course), enter my valid emailaddress at hotmail.com.. Luuk They max changed it during the year, but ...Show All
Progalex Is it possible to dynamically populate a parameter list with values based on another parameter value?
Is it possible to fill a parameter list with values based on another parameter value Here's what I have so far (which hasn't worked)... I'd like to generate a report listing information for a student. The report viewer would first select a school from the first drop-down menu, and then the second drop-down menu would populate with the list of students at that school. I have a dataset that calls a sp which returns a list of schools (Scho ...Show All
Volturno Report Builder - Is it possible to create a named query with a stored procedure as its source?
In SQL 2005, the new Report Builder functionality gives end-users the ability to create their own report. These reports are based on report models that can be created in VS 2005. Is it possible to create a named query based on a stored procedure check this post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=344631&SiteID=1 ...Show All
Chris Boden Update Statement not working
I've got the following update statement: UPDATE ISSUE_ACTIONS SET BAE_FLAG = 2 WHERE IA_ISSUE_NO = 399 AND IA_SEQUENCE = 20 The fields BAE_FLAG, IA_ISSUE_NO, and IA_SEQUENCE are all of the type int. When I run this code inside of my windows app (C#), cmd3.CommandText = "UPDATE ISSUE_ACTIONS " + "SET BAE_FLAG = 2 " + " WHERE IA_ISSUE_NO = 437 " + " ...Show All
sri.raghav I need a CONNECTION GURU to explain what is going on.
I have a application that uses a connection that is always active until the application is closed, and many other connections that are opened and closed as different data is requested. I DO close and dispose these connections, datasets, and data readers after requesting data to release the resources. BUT they still show in SQL Server 2005 Express Edition. I believe they are NOT active and are part of the Pooling system. The problem is the con ...Show All
JohnJSal Report Manager - Blank Reports Page
Hi, I'm getting blank page when I open the Report Manager: I've got a header - "...Reporting... HOME", and then just empty space. I had it working fine a week ago. Any ideas The RS runs on Win2003 Std, SQL 2005 Std. Thanks Log in locally on your report server computer as a member of the Local Administrators group. Then on the home folder, select Properties, go to Secur ...Show All
Eugene Tan checking length of textbox value!
Hi I was looking to check the length of a textbox then truncate it if it is graeter than some value and assign the that value for a textbox control in reporting service.How can i acheve this Thanks I do not know who you are but I really would like to appreciate you ! Thanks a lot! Ephi . I want to do the same thing as well as if the length of the field is shorted than the required length, I need to pad ...Show All
dbw Allocated space for tempdb in SQL 2005 showing up incorrectly in Management Studio
The data file for tempdb is showing up as 4.6 GB in the data directory for MSSQL, however, when you click on the properties tab, it shows only 8 MB allocated for the data file. I'm trying to shrink the file but SQL thinks it's only got 8 MB allocated for the file. Thanks in advance for help/advice that can be provided. ...Show All