Viewing 15 posts - 22,681 through 22,695 (of 39,961 total)
It's possible that permissions are not granted on that table from those roles. It's a system table, so I'd expect that db_datareader wouldn't, but I wouldn't think db_owner would not....
August 27, 2009 at 9:07 am
Is it to any server? Any query?
If so, you likely have a corrupt install. I'd uninstall/reinstall it.
August 27, 2009 at 9:07 am
Tim Mitchell (blogger/author on this site) is involved in a Fort Worth group, I believe. I'd contact him.
August 27, 2009 at 9:06 am
This is a huge subject and there isn't necessarily an easy book that covers all this. I know that there are a few good SSAS books from WROX (beginning and...
August 27, 2009 at 8:46 am
You need to look at the maint plan log. It's usually a text file in the /log folder. It has more details. If you don't log from the maint plan,...
August 27, 2009 at 8:44 am
Why not store the data in a table and change it there? Access can do this easily as a front end for business people. Then you can more easily manipulate...
August 27, 2009 at 8:40 am
You really need to read up on replication and how it works. It's not that complicated, but it's not something we can necessarily give you a quick answer to.
A publication...
August 27, 2009 at 8:38 am
We're still sending it to you. Likely there was some filter update at your company.
August 27, 2009 at 8:37 am
I don't think you can do this with the bcp command. You aren't running T-SQL here, you'd shelling out to a command prompt and then running a utility to pull...
August 27, 2009 at 8:34 am
for the change to take effect, the service must be restarted. Just like you need to log off for someone else to log on and use the same files on...
August 27, 2009 at 8:26 am
Check for triggers, get the execution plan, trace what happens. Post come code.
August 27, 2009 at 8:25 am
It can't be done, and you are not understanding what an NDF is. It's a file, and not necessarily consisting of one object.
You have to export/import the data from one...
August 27, 2009 at 8:24 am
Replication is by table. You can drop that article for the table and reinitialize just that table and article with a snapshot.
The export/import duplicates replication functionality. If you are...
August 27, 2009 at 8:22 am
Viewing 15 posts - 22,681 through 22,695 (of 39,961 total)