Viewing 15 posts - 1 through 15 (of 6,102 total)
It’s usually good to break up the files in this manner. However, be sure to check out how this maps back to actual storage. It may be that you’re creating...
January 31, 2018 at 9:15 am
For most situations I agree with you. I would do it via more normal means. However, the reason I mentioned the example I did was to basically ask the question...
January 31, 2018 at 9:08 am
January 30, 2018 at 11:40 am
Don't use a logon trigger. Go with an extended event:
January 30, 2018 at 11:23 am
Another idea for a PK is a composite key (two columns) consisting of the year + the day of the year. There are some uses for this.
January 30, 2018 at 11:21 am
If you've configured successful or failed logins monitoring for the SQL Server, the information will be written in the SQL Server logs as well as the OS' Application event log....
January 20, 2017 at 7:35 am
Andy Leonard (former SQL Server MVP) doesn't frequent these forums much, but I would ask him if he knows a better way as I know he does DevOps with SSIS...
January 20, 2017 at 7:32 am
Have you done this?
Go into SQL Server Configuration Manager for that SQL Server and clear out all the TCP Dynamic Ports (set them to 0) and TCP Port...
January 20, 2017 at 7:29 am
As Steve posted, check the SID on the new login versus the user SID in the database.
SQL Server, like Windows & AD, uses a unique identifier (SID) to...
January 20, 2017 at 7:17 am
Without doing something crazy security wise, you'd have to leave those settings on all the time for users C and D to work. Out of curiosity, why are they trying...
January 20, 2017 at 7:12 am
This may be more doable and it's what I recommend over the aliasing. It's an A or CNAME record (recommend the CNAME) by your DNS administrator:
January 20, 2017 at 7:04 am
You typically get this error when there's an issue communicating with the storage device. What happens when you run a backup using a SQL Server Agent job and not through...
January 18, 2017 at 1:22 pm
I don't believe this can be done without some sort of scripting effort such as around dtutil.
January 18, 2017 at 1:06 pm
January 13, 2017 at 2:39 pm
Is antivirus in control of the firewall? I've seen cases where it is and unless you check advanced, it may appear off when it isn't.
January 13, 2017 at 2:34 pm