[SQL 2012] label policy-row level security |
- label policy-row level security
- AAG Backup
- RBS (Remote BLOB Storage)
- Creating scalar functions in tsql
- How to login using sqlcmd
- Is there a sql server equivalent of whoami?
| label policy-row level security Posted: 01 Sep 2013 11:18 PM PDT Hi all, anyone have any idea what is label policy?whether it will affect performance of application?thanks sathiyan |
| Posted: 02 Sep 2013 02:31 AM PDT Hi all I have 2 doubts on this can anyone please clarify: On primary for system database backup I have not selected copy only backup, will that be okie? On secondary while configuring Txlog backup If I select all databases backup plan is failing where as if I choose user databases backup it is running fine. Don't we have txlog bkp for system databases backups in AAG? |
| Posted: 01 Sep 2013 08:51 PM PDT Hi all,I'm looking into creating a new database for a fairly large application, which includes a feature for creating and storing many thousands of Word and PDF documents. The application that's being replaced stores the documents in a share on a NAS physically separated from the database server, for performance reasons, but the documents aren't in the database - the database records just include filepath pointers to the documents. Indexing of the documents' contents is done using a 3rd party tool.I'd like to have the documents stored in the database as BLOBs, ideally, to allow for more advanced indexing and querying, but from what I'm reading it's only possible to store the documents on a different server than the database if we have the Enterprise edition of MSSQL. Is that correct? If so, that seems a bit ridiculous - who would want to store the files on the same server as the database?I've enquired and found that Enterprise edition would be prohibitively expensive for us. If I'm correct that Enterprise edition is the only way to store files off-server, is there a workaround? Has anybody had experience doing this sort of thing before? |
| Creating scalar functions in tsql Posted: 01 Sep 2013 09:36 PM PDT Hi all,Firstly many apologies if this is in the wrong place. I'm basicly trying to create a scalar function that returns a nvarchar (15) variable.The Function has two input variables namely [category] and [AreaCode] (both nvarchar(15)) with an output variable [Team Line]. I've constructed this without any problem via a case statement (see below), but as I need to use this statement repeatingly I thought a scalar function would be the answer!I'm new to sql functions so any good advice would be much appreciated!select,case when when [Category]='A' then 'Team A' when [Category]='B' then 'Team B' when [Category]='C' then 'Team C' when [Category]='K' and [AreaCode] in ('Acct','Desp','Analysis') then 'Team D' when [Category]='L' and [AreaCode] not in ('Lark') then 'Team E'else 'Others' end as [Team Line]Kindest regards,J |
| Posted: 01 Sep 2013 09:25 PM PDT Hi,my rdbms version :2012 sqlexpressI created the login using the below commands:[code="sql"]SETUSERGOUSE masterGOIF EXISTS( SELECT * FROM sysdatabases WHERE name='permissionsDB' ) DROP DATABASE permissionsDBGOIF EXISTS( SELECT * FROM sys.sql_logins WHERE name='schemaUser' ) DROP LOGIN schemaUserGOCREATE DATABASE permissionsDBGOCREATE LOGIN schemaUser WITH PASSWORD='Pass#123',DEFAULT_DATABASE=permissionsDBGOGRANT CONNECT SQL TO schemaUserGOUSE permissionsDBGOCREATE USER schemaUser WITH DEFAULT_SCHEMA=dboGO[/code]what is the correct option to login as schemaUser using sqlcmd?http://technet.microsoft.com/en-us/library/ms162773.aspxI try the following it fails[code]C:\Users\user>sqlcmd -S user-pc\sqlexpress -U schemaUserPassword: Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Login failedfor user 'schemaUser'..C:\Users\user>sqlcmd -S user-pc\sqlexpress -U schemaUserPassword: Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Login failedfor user 'schemaUser'..[/code]any assistance is really appreciated!thanks |
| Is there a sql server equivalent of whoami? Posted: 01 Sep 2013 09:19 PM PDT Hi,my rdbms version is 2012 sqlexpress.is there a way to find out what login am I currently login using a command.believe that unix has a command called whoamihttp://linux.about.com/library/cmd/blcmdl1_whoami.htmthanks a lot! |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment