Viewing 15 posts - 751 through 765 (of 2,658 total)
Does your coworker have dtexec installed? If not, he can't run something doesn't exist on his system.
I would start out by looking at the error messages. If it works for...
July 23, 2021 at 7:51 pm
This is one of those "it depends" situations. According to the Microsoft documentation (found here https://docs.microsoft.com/en-us/previous-versions/dotnet/framework/data/adonet/sql/managing-permissions-with-stored-procedures-in-sql-server), it states:
Stored procedures take advantage of ownership chaining to provide access to...
July 22, 2021 at 5:33 pm
Personally, I don't like that security model as I like working with a "least privilege" model. I generally apply permissions as part of my object creation scripts.
Now, if you DO...
July 22, 2021 at 5:01 pm
Step 1 - check the logs.
I would probably reach out to the server admins (and check the logs) to determine why starting the service as a user other than the...
July 22, 2021 at 3:02 pm
As a random guess - I would say that in the presentation, entityID was an INT IDENTITY(1,1) and in your code, it doesn't seem to be an IDENTITY type. So...
July 21, 2021 at 9:05 pm
Possibly a dumb question but do you need those WHERE clauses? If the data is the same, setting the value "10" to "10" is not going to hurt too badly...
July 21, 2021 at 4:03 pm
I think I would approach this by using endnum+1 = LEAD(begnum,1). This will help you determine if it is a gap or not; lets call this bitGAP. You can use...
July 20, 2021 at 9:30 pm
To confirm - it only happens on 1 of the 2 read-only secondary systems, correct?
If so, may not hurt to investigate any differences between the 2 systems.
Probably a shot in...
July 20, 2021 at 8:22 pm
I was just reviewing what you had on your site and noticed a few mildly concerning things that may just need more clarification to me.
First, you say "Below is an...
July 20, 2021 at 8:03 pm
To make the post a bit more clear, These are the links to the articles about the ebooks:
https://www.sqlservercentral.com/books/best-of-sqlservercentral-volumes-1-4
https://www.sqlservercentral.com/books/best-of-sqlservercentral-volume-5
https://www.sqlservercentral.com/books/best-of-sqlservercentral-volume-6
https://www.sqlservercentral.com/articles/the-best-of-sqlservercentral-vol-7
All of these bring up...
July 20, 2021 at 5:20 pm
First, I should clarify I don't use AG's so my advice may be way out to left field, but I do not think it is bad advice.
Have you checked the...
July 20, 2021 at 5:12 pm
Looking at those waits, the ones in hours are the ones I would be more concerned about! If I am reading things right on that, the AVERAGE column is showing...
July 19, 2021 at 10:11 pm
For that particular query (experts correct me if I am wrong), but I see 4 indexes being needed - 1 per table. The query looks broken to me on that...
July 19, 2021 at 7:28 pm
Any column in the SELECT result list that is NOT used in an aggregate (or windowing function) MUST be included in your GROUP BY UNLESS no aggregate operations are taking...
July 19, 2021 at 6:11 pm
This forum, being called "SQL Server Central", is mostly focused around SQL Server. The Powershell component of the forum is, for the most part, how to do stuff with SQL...
July 19, 2021 at 5:52 pm
Viewing 15 posts - 751 through 765 (of 2,658 total)