Viewing 15 posts - 136 through 150 (of 4,477 total)
Hello,
I read that in new SQL is Ag feature also for sync system database, can you give me some hint please ?
I cannot find how to set.
thanks
Here is a...
February 18, 2020 at 10:58 pm
Yup, deny takes precedence with the only exception being column level permissions and table denies - which is suppose to be deprecated at some point. A member of a role...
February 14, 2020 at 3:46 pm
In situations like this SQL Server will use the most local column it can find if there are no aliases. So if the column name is present on both...
February 14, 2020 at 3:34 pm
Appreciate the update - thanks for posting back!
Sue
February 14, 2020 at 3:10 pm
One thing to check on with whoever is managing the AS400 is to checking on the indexing to see if you can use Index As Access Path which is a...
February 13, 2020 at 10:59 pm
My first guess is that it's a mapping issue. And mapping with an AS400 data source and using the import/export wizard is likely to be a headache. This article might...
February 13, 2020 at 8:13 pm
You are very welcome, glad I could be of assistance. And thanks a lot for posting back as that really helps when people provide updates like you have.
Sue
February 13, 2020 at 7:14 pm
##csvtemp only contains 6 lines.. so it is not big...
set @sql = 'bcp "SELECT Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8,Col9,Col10,Col11,Col12,Col13,Col14,Col15,Col16,Col17,Col18,Col19,Col20,Col21,Col22 FROM ##csvtemp" queryout '+@processedFolderLocation+'/"'+@csvFileName+'" -c -d ' + DB_NAME() + ' -t, -S '+...
February 13, 2020 at 5:43 pm
If you want to create a linked server, you would install the Client Access on the SQL Server as well.
IBM has an older documentation that gives the general idea of...
February 13, 2020 at 5:25 pm
dbatools also has the cmdlet Get-DbaAgReplica that you may want to try.
Sue
February 13, 2020 at 5:16 pm
And if you also made sure the permissions for the service account are also correct, you may want to double check those permissions. Error code 1314 is : A required...
February 13, 2020 at 3:19 am
Make sure to create the proxy account using sp_xp_cmdshell_proxy_account and specify a Windows account. The OS level permissions can't be granted to a SQL Server login.
Sue
February 13, 2020 at 1:48 am
It looks like your xp_cmdshell is hanging - and you can't kill that as it spawns a windows process external to SQL Server. You would need to restart the server...
February 12, 2020 at 9:32 pm
If the guest account is enabled in those databases, that's one thing that would allow those databases to show.
Sue
February 12, 2020 at 7:26 pm
If you have never applied any patches and are on SQL Server 2012, that could be a problem. Any chance you could please provide the version?
Sue
February 10, 2020 at 10:30 pm
Viewing 15 posts - 136 through 150 (of 4,477 total)