No announcements
Found 1016794 threads
-
1 VotesPermissioning across three databases
If there are lots of them, TRUSTWORTHY + EXECUTE AS can be the best choice, but an absolute requirement in such case is that the databases are owned by an SQL login with ...Answered | 6 Replies | 927 Views | Created by lb483 - Tuesday, June 27, 2017 4:14 PM | Last reply by Erland Sommarskog - Tuesday, June 27, 2017 9:42 PM
-
0 Votes
LINQ Join Across Three Tables
That does show how to do a join across three tables.Answered | 6 Replies | 10667 Views | Created by Ussabin - Wednesday, September 15, 2010 6:12 AM | Last reply by Ussabin - Tuesday, September 21, 2010 5:55 AM -
2 Votes
Database Ownership Chaining Across Servers
Or an Access database.Answered | 4 Replies | 1386 Views | Created by Jeelani Kamal - Thursday, April 24, 2014 8:26 PM | Last reply by Erland Sommarskog - Friday, April 25, 2014 7:17 AM -
1 Votes
moving databases - retaining permissions
You might have to script out the permissions of the existing users and create the permissions in the database in new cluster replacing the user names with new username ...Answered | 2 Replies | 738 Views | Created by Stevan Allen - Monday, January 5, 2015 3:20 PM | Last reply by Stevan Allen - Tuesday, January 6, 2015 8:10 AM -
4 Votes
Assigning group permissions across multiple sites
Hi Di Hughes, If the three sites are in different site collections, you need to create group in each site for granting permissions.Answered | 4 Replies | 1900 Views | Created by Di Hughes - Thursday, October 6, 2016 12:53 PM | Last reply by Di Hughes - Monday, October 10, 2016 11:15 AM -
0 Votes
RI Across Databases?
Say you implemented RI (using triggers) and you have to restore a sligthly older version of one of the databases.Answered | 2 Replies | 4315 Views | Created by Randy Minder - Tuesday, June 9, 2009 7:34 PM | Last reply by TiborK - Wednesday, June 10, 2009 5:02 AM -
0 Votes
Select (Read) permission on database
This may take a few minutes to replicate across your domain, and in case the members of this domain are already authenticated to a machine, these users may need to refresh their ...Answered | 10 Replies | 1339 Views | Created by LasseF - Monday, October 26, 2015 12:58 PM | Last reply by Raul Garcia - MS - Tuesday, October 27, 2015 6:07 PM -
0 Votes
copy database files across
Just to make it perfectly clear: No, you can't just copy the database files while the database is in use.Answered | 10 Replies | 4257 Views | Created by neophytenik - Tuesday, August 25, 2009 4:07 PM | Last reply by Borndba - Wednesday, August 26, 2009 8:00 AM -
2 Votes
New database permissions
Best to script out permissions from the current database and save it to a script file.Answered | 4 Replies | 1036 Views | Created by '''HuuM''' - Wednesday, August 24, 2016 1:40 PM | Last reply by Satish Kumar Gajula - Wednesday, August 24, 2016 3:38 PM -
0 Votes
User permissions on multiple databases.
I need to grant user permissions (read/write) on every single database and wanted to check if there is any way I can do this in quicker way other than granting them one DB ...Answered | 2 Replies | 9116 Views | Created by Prash25 - Wednesday, September 19, 2012 1:25 AM | Last reply by Uri Dimant - Wednesday, September 19, 2012 8:03 AM -
3 Votes
Database across multiple drives
Please confirm that by doing so, i will have any discrpencies in my server / database environment.Answered | 21 Replies | 9105 Views | Created by RubSay - Thursday, March 18, 2010 12:34 PM | Last reply by RubSay - Thursday, March 25, 2010 12:44 PM -
0 Votes
Need Help Resetting Permissions to Main Objects Across the Site Content DB
This one looks best for my needs because it works across all the objects.Answered | 3 Replies | 998 Views | Created by Chabbers - Wednesday, November 27, 2013 3:09 PM | Last reply by Chabbers - Wednesday, November 27, 2013 3:40 PM -
3 Votes
Service Broker across database versions
This blog describes how to setup Secure SQL Server Service Broker across databases in less than 10 ...Answered | 2 Replies | 5276 Views | Created by Shival Mathur - Wednesday, October 17, 2012 6:19 AM | Last reply by Iric Wen - Thursday, October 18, 2012 7:44 AM -
0 Votes
Listing dependencies across databases
So using sp_msforeachdb, you first load database and object names into a single table (basically a globallised version of sysobjects).Answered | 3 Replies | 6224 Views | Created by Yash Ganthe - Tuesday, January 6, 2009 1:21 PM | Last reply by Dan Cambridge - Thursday, July 26, 2012 9:32 AM -
0 Votes
How to split IDs across three columns
Hello all, For example I have a table: declare @t table(n int) insert into @t(n) values (2), ...Answered | 4 Replies | 2993 Views | Created by Ignatov Oleg - Wednesday, June 22, 2011 5:50 AM | Last reply by - Wednesday, June 22, 2011 11:18 AM -
0 Votes
cross database view permissions problems...HELP!!
and i shouldn't need to grant explicit permissions to the tables the view queries right?Answered | 2 Replies | 9230 Views | Created by dedbeat - Saturday, March 12, 2011 2:21 PM | Last reply by Dan Guzman - Saturday, March 12, 2011 3:27 PM -
4 Votes
Trouble Copying database across servers
Yes, it is part of the DBCC command set known, now, as database console commands.Answered | 6 Replies | 4992 Views | Created by BAYoung09 - Friday, April 16, 2010 8:33 PM | Last reply by BAYoung09 - Monday, April 19, 2010 7:24 PM -
0 Votes
CREATE DATABASE permission denied in database
So it was annoying that a permissions issue was thrown rather than something more useful such as 'database does not exist' or similar.Answered | 7 Replies | 16113 Views | Created by BTMI - Friday, August 27, 2010 12:40 AM | Last reply by Narasimhan Padmanabhan - Friday, September 30, 2011 8:37 PM -
0 Votes
how to fetch the recordes from multiple tables across the databases in a same instance?
CREATE VIEW NEWVIEW AS SELECT * FROM [Database A].Answered | 3 Replies | 1367 Views | Created by rupc - Wednesday, October 9, 2013 9:26 PM | Last reply by SaravanaC - Thursday, October 10, 2013 3:46 AM -
1 Votes
sql database permissions
Also keep in mind that every thing you do and create etc in the model database is "copied" to each new database you create afterwards.Answered | 2 Replies | 4784 Views | Created by club140 - Monday, July 26, 2010 8:56 PM | Last reply by Arild Røksund - Tuesday, July 27, 2010 10:44 AM - Items 1 to 20 of 1016794 Next ›
No announcements
