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 ....
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...
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...
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...
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...
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...
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
August 26, 2021 at 1:41 am
Did you re-boot the server like the message says?
August 26, 2021 at 1:26 am
There is also the Schema Changes history report under the Standard Reports in SSMS
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....
August 25, 2021 at 11:47 am
Why don't you ask this question in the original thread?
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...
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...
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...
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...
August 17, 2021 at 1:46 pm
Viewing 15 posts - 721 through 735 (of 2,356 total)