Posted: 30 Jul 2013 07:19 AM PDT

Hello,I am new to SQL Server 2008 administration and I have been asked to give a user access to only 1 table of a database. In addition i have been asked to give them access to only 2 columns within that table. How can I do this? I was told there is more than one way if you know multiple ways please share. If I have to type a command where do I type it? please start from scratch with me. Thank you very much I appreciate your input.

Posted: 30 Jul 2013 09:08 PM PDT

Hi Experts,We lost SQL Server sa password and our windows authentication is not allowing us to login .How can i connect to server now?

Monitoring performance after index deployment.

Posted: 30 Jul 2013 09:26 AM PDT

I am trying to figure out how to monitor performance of the database before and after deploying an index. Are there any simple ways of doing this?

Error while installing

Posted: 30 Jul 2013 11:30 PM PDT

Hi allhere i am trying to install the sql server in our server but finally it is showing some error message like " external component has thrown exception"here in c drive we have less space so we are installing data files in e drive.firewall is disabledstill same problem is coming.can u please help me out

SQl2k8 R2 Ent stops installation after installing setup files

Posted: 14 Jul 2012 10:31 AM PDT

Hi all.I'm having trouble installing SQL 2k8 R2 Ent on a Windows Server 2008 R2 box. This box had 2k8 express, 2k8 web edition and 2012 R0. Since an upgrade failed, I removed all 3 and attempted to do a fresh install but ran in to a new problem.The initial error mentioned something about reporting services files and database still being on the server. A google search mentioned removing these manually, which I did. But as soon as I did that, rebooted and attempted another install, I ran in to a different problem.When I run setup.exe, it launches to the initial screen and I click "New installation or add features to an existing installation" and the installation starts. As soon as the installation finishes installing the set-up files, the install window closes and I'm back to the installation center window that originally opens when you run setup.exe. No error, just appears to close the current attempt at installation.I checked my setup bootstrap/log files and there are numerous text files in this folder but nothing jumps out as a straight "error" or "cancelling setup". Below is the only thing that may relate to an error and it's the end of the file named "Detail_ComponentUpdate.txt".Copying the files from the DVD to the hard drive yielded the same results. I uninstalled everything and manually cleared the install directory. I also tried the upgrade option. I deleted what registry keys I could find relating to SQL Server. Still no luck although these files installed fine on another server.Any ideas?Thanks,Mark[code="other"]2012-07-15 19:02:17 Slp: C:\Users\Administrator\Desktop\SQL Server 2008 R2\x64\FixSqlRegistryKey_x86.exe exit code: 02012-07-15 19:02:17 Slp: Completed Action: FixSqlRegistryKey, returned True2012-07-15 19:02:17 Slp: ----------------------------------------------------------------------2012-07-15 19:02:17 Slp: Running Action: PostMsiTimingConfigAction2012-07-15 19:02:17 Slp: The object state property 'workflow' is null/empty.2012-07-15 19:02:17 Slp: Error: Action "PostMsiTimingConfigAction" failed during execution.2012-07-15 19:02:17 Slp: Completed Action: PostMsiTimingConfigAction, returned False2012-07-15 19:02:17 Slp: Completed Action: ExecuteStandardTimingsWorkflow, returned True2012-07-15 19:02:17 Slp: ----------------------------------------------------------------------2012-07-15 19:02:17 Slp: Running Action: ExecuteCloseWorkflow2012-07-15 19:02:17 Slp: Workflow to execute: 'CLOSE'2012-07-15 19:02:17 Slp: ----------------------------------------------------------------------2012-07-15 19:02:17 Slp: Skipping Action: ProduceStatusLogs2012-07-15 19:02:17 Slp: Action is being skipped due to the following restrictions: 2012-07-15 19:02:17 Slp: Condition "Is the datastore flag /Scenario/GlobalFlags/AreProductFeaturesSupported set" did not pass as it returned false and true was expected.2012-07-15 19:02:17 Slp: ----------------------------------------------------------------------2012-07-15 19:02:17 Slp: Running Action: FinalizeProgressStatus2012-07-15 19:02:17 Slp: Completed Action: FinalizeProgressStatus, returned True2012-07-15 19:02:17 Slp: ----------------------------------------------------------------------2012-07-15 19:02:17 Slp: Running Action: RebootMessageAction2012-07-15 19:02:17 Slp: Completed Action: RebootMessageAction, returned True2012-07-15 19:02:17 Slp: ----------------------------------------------------------------------2012-07-15 19:02:17 Slp: Skipping Action: FinishPage2012-07-15 19:02:17 Slp: Action is being skipped due to the following restrictions: 2012-07-15 19:02:17 Slp: Condition "Is the user's scenario set to EditionUpgrade" did not pass as it returned false and true was expected.2012-07-15 19:02:17 Slp: ----------------------------------------------------------------------2012-07-15 19:02:17 Slp: Skipping property RequireMode of class: StopAction2012-07-15 19:02:17 Slp: Input of property will not be set due to the following failed restriction(s): 2012-07-15 19:02:17 Slp: Condition "Is the user's scenario set to ComponentUpdate" did not pass as it returned true and false was expected.2012-07-15 19:02:17 Slp: ----------------------------------------------------------------------2012-07-15 19:02:17 Slp: Running Action: CloseUI2012-07-15 19:02:17 Slp: Stop Action2012-07-15 19:02:17 Slp: Completed Action: CloseUI, returned True2012-07-15 19:02:17 Slp: Completed Action: ExecuteCloseWorkflow, returned True2012-07-15 19:02:17 Slp: ----------------------------------------------------------------------2012-07-15 19:02:17 Slp: Running Action: PassPidBackFromComponentUpdate2012-07-15 19:02:17 Slp: Pass the flag CuPidDisplayed to the main setup2012-07-15 19:02:17 Slp: ENU value specified, trying to pass the value to main setup2012-07-15 19:02:17 Slp: PID value specified, trying to pass the value to main setup2012-07-15 19:02:17 Slp: SQMREPORTING value is specified in CU workflow, trying to pass the value to main setup2012-07-15 19:02:17 Slp: Completed Action: PassPidBackFromComponentUpdate, returned True2012-07-15 19:02:19 Slp: 2012-07-15 19:02:19 Slp: 2012-07-15 19:02:19 Slp: ----------------------------------------------------------------------2012-07-15 19:02:19 Slp: 2012-07-15 19:02:19 Slp: Setup result: 0[/code]

Sql samples, sql tips

Wednesday, July 31, 2013

[MS SQL Server] How to give users access only to certain columns of certain tables in a database?

[MS SQL Server] How to give users access only to certain columns of certain tables in a database?

No comments:

Post a Comment

Search This Blog