View Complete Post
Prev Reference Question: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/a6166b82-1e1a-4771-952d-a7b54e0b0f23?prof=required
I see the same problem with SQL 2008 Management Studio. I have different schema defined in my database, all the schema permissions work just fine in SQL 2005 but when viewed from SQL 2008. I cannot see tables for which i have given inidividual permissions. I have given SELECT permissions for those tables.
schema: dbo, schema1, schema2 ....
user: user1 (schema1 owner), user2 (schema2 owner), user3 ...
now i have given SELECT on schema1.table1 to user2
this works fine and i m able to see the schema1.table1 when login as user2 in SQL2005. I have tried your solution for giving "View Definition" permission as well. But this doesnt work in my case.
Seems to be some default permission settings with SQL 2008 ??
Any help/Suggestion will be appreciated
I am beginner and need help.
I want design a page where the end user enters information on my page and related information is fetched from the another website on my web page.
For example: Capturing City and state name from USPS.com
End user Task : Enter zipcode and click button 'Fetch'
My page perform few task
1. opens usps site backend
2. Enters the zipcode
3. Captures city name and state as temporary value from the usps
4. Displays the same in labels present in my home page.
I need help and designing the same.
I m getting data from database using SQL
string mysql = "SELECT [ID],[FirstName],[LastName],,[MiddleInit],[DateLastModified] FROM [Databse] WHERE ([ID] = '54321') ORDER BY [DateLastModified]";
I have 4 rows for this sql and I m displaying in GridView. I want the latest modified date as my first row but it is displaying in a reverse order. How can I display rows using Latestmodified date without sorting.
I have a for loop condition as below coding for looping to change word on label.text, but as a result, it just only display the last value.
pls help me how can I do to display each value for a looping.
i want the result is the label1.text to show 1 then 2, then 3, then 4.......finally is 10.
for i as integer = 0 to 10
label1.text = i
On the list display form i have start date field which shows date in the folloving format : 2010-07-06T22:00:00Z
First it shows the wrong date since in edit from i see 7/7/2001
secondly the format is wrong since i choosen date only field so i don't want to see time and zone.
Does anybody knows why this happens and how to fix it?
I have a report to display sales figure for the last 3 days including current date. That means whenever the report is generated it should start the date column with the current date and the previous 3 days data. I have the query ready to pull the data. But
I am not able to generate the column headers in date format. Below is my report format for your reference...
I am having one requirement where the DataFormwebpart should display specific folder data of a List. For an exxample I have one list which has three folders Level 1 , Level2 and Level3 . I want that when webpart is added on SharePoint page it should display
data of Level1 and not the root level data of list.
Basically the webpart needs to be drilled to Level1 folder by default rather than root folder of List.
I have some Date fields defined in my sqlserver database but these display with a time part as well (00:00:00).
how do i esnure that only the date part is displayed and not this redundant time?
I want to display 24 hours time and date in SSRS & for that I am using Format(now,"MM/dd/yyyy HH:mm:ss") but I am using this expression in Parameter, where I need to define datatype of that parameter as DateTime, not string. For Expression Format(now,"MM/dd/yyyy
HH:mm:ss"), If I use DateTime datatype, It is showing error but working with String datatype.
I have parameter To Date and value of this parameter should be 10/11/2010 13:09:16 (To Date: 10/11/2010 23:09:16) , not in AP or PM format and datatype of this parameter, want to keep DateTime that I can select value from Calender.
Please suggest me how I can achieve this?. I don't want to do it in stored Procedure side, want to do it in report side.