Viewing 15 posts - 1 through 15 (of 4,233 total)
You may want to try using signed stored procedures to create the users instead of using execute as. You don't hit the same limitations with sign stored procedures.
November 7, 2019 at 6:04 pm
I am running the DMV (sys.dm_db_index_physical_stats) to get the fragmentation for a database, however when I get the results the Index column is NULL for 3 tables even though...
November 7, 2019 at 6:01 pm
If you are using one where you deleted the signature block, it's not doing anything. That block is just the code encrypted. Use a version with that block included.
November 5, 2019 at 11:14 pm
On the send mail, you have a syntax error in your original post that I just noticed as the parameter is @file_attachments (plural) rather than singular. Don't think that would...
November 5, 2019 at 8:43 pm
I've hit it where the process that created the file didn't finish up completely when I went to send the mail so that can happen. It could also be related...
November 5, 2019 at 6:50 pm
Error number 32 is ERROR_SHARING_VIOLATION so something else is accessing the file when you go to attach it.
November 5, 2019 at 5:46 pm
This gives me a list of SQL users I have for this database. However, I searched for various GRANT statements and cannot find how to map...
November 5, 2019 at 5:20 pm
I currently have 1 publisher with 100 articles published (SQL 2012) to 1 subscriber (SQL 2008).
I have a new server SQL 2016 which I wish to set up a...
November 5, 2019 at 4:58 pm
It depends on what application they use to connect but you generally get that error if they have selected or use SQL Server Authentication and pass in their Windows login...
November 5, 2019 at 4:46 pm
After you do the sp_dropserver, sp_addserver, etc you need to restart the service for the change to take effect.
November 4, 2019 at 11:09 pm
There is an environment variable PSModulePath that should be pointing to whatever location has the folder structure: PowerShell\Modules\SQLPS
I'd check your environment variable and check for the location of the SQLPS...
November 4, 2019 at 11:05 pm
I hope that's it - thanks a lot for posting back! Please post back if it rears it's ugly head again. It would be good to know if this was...
October 11, 2019 at 4:31 pm
Thanks for posting back. It definitely seemed like something not right with the account - glad it's all working now.
October 10, 2019 at 7:14 pm
Auto update stats may not be executing often enough due to the size of the tables. There is a trace flag that could help your situation on SQL Server 2014....
October 10, 2019 at 12:19 am
It would be in the default trace, depending on how far back you have trace files. Otherwise, yes you would want to use a DDL trigger at the server level...
October 9, 2019 at 11:21 pm