Viewing 15 posts - 2,506 through 2,520 (of 9,643 total)
In my opinion using roles is the best way to assign permissions. Grant permissions to the role and assign users to the appropriate role(s). I still think in...
March 30, 2011 at 1:10 pm
I agree that the BOL entry isn't all that helpful, but with the test provided it shows that ALTER INDEX REBUILD is one of the DDL statements that DOES cause...
March 30, 2011 at 11:55 am
Thanks for clearing this up Gail. The whole R2 naming is what causes the confusion I think.
March 30, 2011 at 10:42 am
You are going to have to do some translation for me. There is no CustomerID column in the information you provided. Can you translate the cryptic table &...
March 30, 2011 at 10:37 am
I'd put the archive tables in their own schema and grant webuser select rights on the schema, then webuser will have select permissions on any objects created in that schema...
March 30, 2011 at 10:28 am
Are you successfully doing this? I wouldn't think it would work because you typically cannot do a restore to a lower version of the product. I'm not sure...
March 30, 2011 at 10:22 am
I ran a quick test and it does.
Here's the test:
CREATE TABLE #test
(
id INT CONSTRAINT PK_Test PRIMARY KEY CLUSTERED
...
March 30, 2011 at 10:20 am
Is it the exact same query with the same parameters?
Are you getting the same execution plan each time?
What are the results of SET STATISTICS IO ON? Are you getting physical...
March 30, 2011 at 10:08 am
Typically when SQL Server accesses resources on the network it uses the SQL Server service account so you'd need that account to have permissions to the network resources. I...
March 30, 2011 at 10:05 am
The only thing I can suggest, if rendering is what takes the time, is to try collapsing the details so that only summary data shows and then have the user...
March 30, 2011 at 9:59 am
Since you are connecting on the same PC you do NOT need to enable remote connections.
Please do not post the same question multiple times as it fragments answers. Here...
March 30, 2011 at 9:53 am
Wow, please only post a question once as it fragments replies and you get asked the same questions over and over.
March 30, 2011 at 9:51 am
Have you run the stored procedure in SSMS to see what it returns?
My guess is that is returns the right results, but that the binding in the .NET code is...
March 30, 2011 at 9:48 am
Okay.
As Lutz asked, what is the error message?
What are you using for the Server Name when you try to connect? By default Express installs as a Named Instance so...
March 30, 2011 at 9:39 am
Viewing 15 posts - 2,506 through 2,520 (of 9,643 total)