Viewing 15 posts - 20,116 through 20,130 (of 26,490 total)
We really can't help you based on the extremely vague description of your problem/issue.
If this is a performance problem, please read the second article I have referenced below in my...
June 30, 2009 at 1:53 pm
GSquared (6/30/2009)
john.arnott (6/30/2009)
3NF-Boy got me ROFL with this response:w00t:. I can't wait to see Gus's answer. 😉
No more waiting required. Let me know...
June 30, 2009 at 1:14 pm
You will also want to run the Database Upgrade Advisor against the database. There may be things you need to modify/change before moving to SQL Server 2005, others after...
June 30, 2009 at 1:11 pm
Roy Ernest (6/30/2009)
Lynn, you were posting at break neck speed today.. Jumping one forum...
June 30, 2009 at 12:58 pm
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
Viewing 15 posts - 20,116 through 20,130 (of 26,490 total)