2
votes
2answers
2k views

SQL Server drop and create all users in every DB

I would like to drop and recreate every user in a database without having to manually do this for 500 users. I have this so far: USE [Maintenance] GO IF EXISTS (SELECT * FROM ...
1
vote
0answers
120 views

How do I use MDX scripting in SQL server 2005 Business Intelligence Development Studio to create the following Member? [closed]

I am using Microsoft SQL server 2005 Business Intelligence Development Studio to build a cube. I need to calculate a member called INCREMENTAL OVERTIME. INCREMENTAL OVERTIME is based off of the ...
3
votes
2answers
215 views

Microsoft SQL Server 2005 Encryption Options

I'm trying to explore some encryption options on Microsoft SQL Server 2005. I've recently got around SQL Server 2008 and was able to enable Transparent Data Encryption (TDE). Now I'm trying to figure ...