Viewing 15 posts - 6,151 through 6,165 (of 6,395 total)
have you prefixed the new db on to the query
oldmasterdb.sys.sql_logins
November 17, 2011 at 2:43 am
Dev (11/17/2011)
anthony.green (11/17/2011)
this is a good reason why service accounts should be used with none expiring passwords to run SQL server services
Agree for SQL Server Service Accounts. ...
November 17, 2011 at 1:31 am
Dev (11/17/2011)
bpportman 52825 (11/16/2011)
I was able to...
November 17, 2011 at 1:23 am
this is a good reason why service accounts should be used with none expiring passwords to run SQL server services
November 17, 2011 at 1:21 am
alternative
DECLARE @NUMBER INT
SELECT @NUMBER = COUNT(*) FROM ATable
SET @NUMBER = @NUMBER -5
SELECT * FROM ATable WHERE ID NOT IN (SELECT TOP (@NUMBER) ID FROM ATable)
The reason its a random order...
November 16, 2011 at 7:34 am
They can still create under DBO as you cannot specify a default schema for an AD group, so it will always default to DBO
One way to get around this is...
November 16, 2011 at 5:54 am
Usman Butt (11/16/2011)
Why don't you explicitly DENY the permissions on [dbo] schema for that AD Group.
What happens should a user be part of the AD group and also part of...
November 16, 2011 at 5:51 am
this really isn't the site to be asking this as PCI DSS is very broad and not specific to SQL.
what tier and level are you aiming at as that depends...
November 16, 2011 at 5:45 am
you could also build an expression to dynamically generate the dates if you are clued up on the expression builders in SSRS
other wise like Ole says, build in a new...
November 16, 2011 at 5:13 am
Are you under any space constraints on the hard drive? If not then I wouldnt shrink the database.
Shrinking will cause fragmentation in the database, so you will have to...
November 16, 2011 at 2:47 am
This is one of them where "how long is a piece of string" comes in to play.
Unless you know excatly what is thrown through TempDB its a tough one to...
November 16, 2011 at 2:36 am
bpportman 52825 (11/15/2011)
Ufortunately, they did log off and the issue is still happening.
Not to worry, always try the most obivous thing first.
Few questions
Has the users machine dropped out of the...
November 15, 2011 at 8:14 am
has the user logged off and back on again after changing his password? if not this is a good place to start as the servers will be trying to...
November 15, 2011 at 7:35 am
google the /PAE and /3GB switch for windows boot.ini file as depending on what RAM configuration you need both or just one
then you need to enable AWE in SQL
but you...
November 15, 2011 at 4:10 am
configure AWE on your existing 32 bit server, this will increase the upper limit of RAM that the server can address, that way you can assign more than 4GB of...
November 15, 2011 at 3:56 am
Viewing 15 posts - 6,151 through 6,165 (of 6,395 total)