Viewing 15 posts - 7,021 through 7,035 (of 13,469 total)
sqlnaive (8/3/2011)
1. I have this NT group domain\group1 which contains users domain\u1...
August 3, 2011 at 8:22 am
sqlnaive (8/3/2011)
I've checked that granting Veiw database state to a role executes successfully. However the users having that roles mapped are still not able to access the DMVs.
, yeah, unless...
August 3, 2011 at 7:20 am
sqlnaive (8/3/2011)
August 3, 2011 at 5:18 am
Ninja's_RGR'us (8/2/2011)
Nice script > briefcasing!.Had you considered the profiler method to see what was going on? Might have saved you some time.
no, i fell into the stubborn learn without...
August 2, 2011 at 6:37 pm
Thanks to a PM from a fellow member here, i found that the script i posted 10 plus months ago had a few minor flaws in it: I've edited the...
August 2, 2011 at 3:29 pm
lemme see where i put Remi's password again....
August 2, 2011 at 2:06 pm
Ninja's_RGR'us (8/2/2011)
sqlfriends (8/2/2011)
Lowell, just curious how did you add the image to the post?
Upload the image, then right click on the attachement and hit copy link.
Then use the img tags...
August 2, 2011 at 1:55 pm
yes, it just requires a little setup.
you create a master key on production.
you create the cert on production.
you backup the master key and the cert from production.
you restore them on...
August 2, 2011 at 1:43 pm
also, your example tables are all in Oracle syntax....a trigger in Oracle looks and behaves differently than SQL.
Oracle is all row based, where SQL is set based.
show us what you've...
August 2, 2011 at 1:17 pm
Laura_SqlNovice (8/2/2011)
when creating Symmetric key with Certification do I have to create certificate for every users who will access the data column?
nope...typically you create one cert and use it everywhere....if...
August 2, 2011 at 12:52 pm
well first that's not just one query...i count 15 queries, the one at the end is pretty huge.
maybe you could pull a specific query out that is giving you an...
August 2, 2011 at 9:38 am
http://www.sqlservercentral.com/articles/Administration/dbaroles/517/
http://www.sqlservercentral.com/articles/Administering/thevalueofadba/1806/
http://www.sqlservercentral.com/articles/State+of+the+Business/deathoftheproductiondba/432/
http://www.sqlservercentral.com/articles/Certifications/3176/
http://www.sqlservercentral.com/articles/Miscellaneous/2989/
Daily Tasks
The following tasks should be completed on a daily basis:
Check to make sure the SQL Server is still online and that you still have connectivity.
Check the NT and SQL...
August 2, 2011 at 9:15 am
--supposed we have a table
CREATE TABLE WebUsers (
UserName varchar(100),
UserEmail varchar(100),
UserPass varchar(100)
)
--and some data
Insert into WebUsers
SELECT 'Lowell','lowell@somedomain.com','NotMyRealPassword' UNION ALL
SELECT 'Calvin','Calvin@somedomain.com','G.R.O.S.S.' UNION ALL
SELECT 'Hobbes','Hobbes@somedomain.com','Calvins Friend'
--now we want to encrypt the...
August 2, 2011 at 7:55 am
PaulSp (8/2/2011)
As I am new to Database Mail (as you can obviously tell) - can you suggest which settings I need to amend...
As far...
August 2, 2011 at 7:25 am
Laura those articles go into some really good detail on how to use encryption, and do a better job than i can at explaining .
As for database changes, it depends...
August 2, 2011 at 5:59 am
Viewing 15 posts - 7,021 through 7,035 (of 13,469 total)