Viewing 15 posts - 20,116 through 20,130 (of 26,484 total)
Roy Ernest (6/30/2009)
Today I actually felt that I am invincible or totally ignored. It was as if I was a ghost... 😛
Hey, I wasn't ignoring you Roy. 😉
I think it...
June 30, 2009 at 12:46 pm
homebrew01 (6/30/2009)
Lynn Pettis (6/30/2009)
June 30, 2009 at 12:39 pm
Start by looking here.
June 30, 2009 at 12:32 pm
Sorry, you said the data was copied to SQL Server from a Progress database, not that you were directly querying a Progress database.
June 30, 2009 at 12:24 pm
I'd still like the DDL for the tables and some sample data. I'd like to be sure that you get an answer that ensures you get the correct join...
June 30, 2009 at 12:22 pm
Please post the DDL for the table and some sample data in a readily consummable format that can be cut/paste/run in SSMS to load the table, and we'll see what...
June 30, 2009 at 12:15 pm
Easiest way to manage this, create an AD group for the application, put all users of the app into that group, and then grant execute permissions on the stored proces...
June 30, 2009 at 11:46 am
Just ran a test in my Sandbox database. A user with only db_reader and db_writer could not execute a stored procedure. I had to give the user db_owner...
June 30, 2009 at 11:44 am
rsheppick (6/30/2009)
I have provided the group the roles db_datareader and db_datawriter , I'm not sure what more it is that I need to give them and why it is.
I may...
June 30, 2009 at 11:40 am
Have you granted your users execute permissions on the stored procedures?
June 30, 2009 at 11:35 am
rsheppick (6/30/2009)
Lynn Pettis (6/30/2009)
Curious, what permissions were the developers using while building the app?We had full god mode rights ha ha, so it never came up.
And that is probably your...
June 30, 2009 at 11:25 am
First, no reason to convert to mm/dd/yyyy when comparing to a datetime column as SQL Server will just convert the character representation back to a datetime value.
Second, this will probably...
June 30, 2009 at 11:20 am
Why? What is the data type of the column you will be comparing the value with?
June 30, 2009 at 11:13 am
Curious, what permissions were the developers using while building the app?
June 30, 2009 at 11:11 am
Amedeo Feroce (6/30/2009)
June 30, 2009 at 11:06 am
Viewing 15 posts - 20,116 through 20,130 (of 26,484 total)