Viewing 15 posts - 721 through 735 (of 2,356 total)
You missed the first step
USE [master]
GO
CREATE LOGIN [TheLogin] FROM WINDOWS WITH DEFAULT_DATABASE=[YourDatabase]
GO
User is unable to login now with Windows Authentication after doing this .
login failed ....
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 30, 2021 at 2:34 pm
You are attempting to add a user to a database that does not have a login to the server.
There are 2 steps. The first is to add the LOGIN to...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 30, 2021 at 1:51 pm
I was on the Visual Studio marketplace the other day. Stumbled across this tool.
https://marketplace.visualstudio.com/items?itemName=MAQSoftware.SQLCodeCheck
I was hoping it would be a simple tool to root out basic issues...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 30, 2021 at 1:33 pm
I was on the Visual Studio marketplace the other day. Stumbled across this tool.
https://marketplace.visualstudio.com/items?itemName=MAQSoftware.SQLCodeCheck
I was hoping it would be a simple tool to root out basic issues in SQL...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 30, 2021 at 12:40 pm
EDIT: My SQLServerAgent was not running on the SQL Server, only on the server containing the Analysis Services project
The agent needs to be running on the server where the...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 26, 2021 at 8:04 pm
Heh... good lord. It's been so long since I looked at that built in report that I'd forgotten a couple major (IMHO) flaws it has...
First, It does NOT report...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 26, 2021 at 12:14 pm
Once you generate the script to create the new table, you can use this command to move the data. No logging, almost instantaneous.
ALTER TABLE Source
SWITCH TO Destination
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 26, 2021 at 1:41 am
Did you re-boot the server like the message says?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 26, 2021 at 1:26 am
There is also the Schema Changes history report under the Standard Reports in SSMS
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 26, 2021 at 1:24 am
@Thanks Jeff..I can check the error log way but can I get references on how I can filter the all data but the login records into the .xel files....
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 25, 2021 at 11:47 am
Why don't you ask this question in the original thread?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 24, 2021 at 1:26 pm
It is Dell Data Domain Boost
Have you done test restores from this? We looked into this a while back, and they could not prove to me that their backup...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 18, 2021 at 2:55 pm
I'm trying to get rid of all backup messages in my SQL logs and I was able to successfully suppress completed notifications by enabling trace flag 3266. However, I'm...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 17, 2021 at 5:40 pm
Not a bad description, though I dislike the "experience" with, as it doesn't weight anything higher than anything else. What do you care about more? Not that you might...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 17, 2021 at 4:05 pm
This is from a job posting that another department in my company put together.
Basic Qualifications
Bachelor’s degree in data science or related field and 2+ years of related experience
Proven experience writing...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 17, 2021 at 1:46 pm
Viewing 15 posts - 721 through 735 (of 2,356 total)