Viewing 15 posts - 3,001 through 3,015 (of 7,168 total)
SD1999 (9/28/2012)
We’ll have 10-20 people per group with same read only permission for all dbs.
In some cases, permissions for some members of the...
September 28, 2012 at 9:29 am
EdVassie (9/28/2012)
There is also the risk of people being added to an AD group and inadvertently being granted access to data they should not have access to.
Security best practice is...
September 28, 2012 at 9:08 am
Happy you got it sorted. For those onlookers that do not wish to do an uninstall & reinstall here is the info on how to do an Edition Upgrade:
September 28, 2012 at 8:57 am
Can you do this manually or so you need this to be an automated process?
Interactive:
- How to: Execute Statements Against Multiple Servers Simultaneously (SQL Server Management Studio)
Programmatic:
September 27, 2012 at 4:02 pm
These little mysteries tend to bug me 🙁
If you ever nail it down and have a moment to spare please post the root cause.
September 27, 2012 at 3:58 pm
Matt Miller (#4) (9/27/2012)
this may fix your prefix issue:
EXEC('use CORELIBRARY_ARCHIVE;SET IDENTITY_INSERT dbo.MessengerLog ON') AT [NAS2-RPS];
That may execute but when you go to do the insert using 4-part naming it...
September 27, 2012 at 3:42 pm
Executing via a SQL Agent job? SQL Agent has had issues allowing called programs to handle their own errors in the past and the response to end the job happens...
September 27, 2012 at 3:23 pm
There is no time limit for a Maintenance Plan or for any running batches to execute on the server side. Have you been able to isolate how long it runs...
September 27, 2012 at 3:09 pm
How about something like this?
CREATE TABLE dbo.CustomerSales
(
CustomerNumber INT,
CustomerName VARCHAR(100),
SalesYear INT CONSTRAINT [ck_dbo.CustomerSales.SalesYear] CHECK (SalesYear BETWEEN 1990 AND 2100),
JanuarySales DECIMAL(20, 4),
FebruarySales DECIMAL(20, 4),
MarchSales DECIMAL(20, 4),
...
September 27, 2012 at 2:57 pm
I was keying on the first part of your post having to do with IDENTITY_INSERT and I think we have beaten that horse silly.
Looking at the error message:
The object name...
September 27, 2012 at 2:12 pm
MyDoggieJessie (9/27/2012)
@opc.three - tried that. Again I can execute it but the code won't compile. Executes successfully, gives the above error when hitting the parse or compile buttons.
Right....
September 27, 2012 at 1:14 pm
Jeff Moden (9/27/2012)
opc.three (9/27/2012)
Jeff Moden (9/27/2012)
opc.three (9/26/2012)
Jeff Moden (9/26/2012)
opc.three (9/25/2012)
sanjuv999 (9/25/2012)
please guide me
Do not enable xp_cmdshell! You do not need it for this scenario and it introduces risk in your...
September 27, 2012 at 1:12 pm
As far as I know adding an EKM system would still be a third-party solution. I looked a while back and Microsoft had no offering in the space. There are...
September 27, 2012 at 12:40 pm
Is there a front-end? If so that is where I would put the sorting logic.
If not, or you must do this in the database, you could look into using sp_executesql...
September 27, 2012 at 12:01 pm
Jeff Moden (9/27/2012)
opc.three (9/26/2012)
Jeff Moden (9/26/2012)
opc.three (9/25/2012)
sanjuv999 (9/25/2012)
please guide me
Do not enable xp_cmdshell! You do not need it for this scenario and it introduces risk in your environment.
If you want...
September 27, 2012 at 11:03 am
Viewing 15 posts - 3,001 through 3,015 (of 7,168 total)