Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
After changing the Collation of SQL Server to Latin1_General_CI_AI from QL_Latin1_General_CP1_CI_AS I'm trying to add the server back to MSX as target in CMS but Enlisting is failing. One...
Asked on 11/08/2021
1 answerI have a server in which many users and logins already have access to I was wondering if it is possible to allow all of these users and logins SELECT...
Asked on 11/08/2021 by thepieman314
2 answerI am trying to run, via a linux shell script, a Postgresql command that reads a CSV and updates a table with it. The difficulty I am facing, is that...
Asked on 11/08/2021 by olivier2101
1 answerAn SSIS package that I'm building has two OLE DB connections, to databases named "core" and "staging". I created test versions of these two databases on my local SQL Server...
Asked on 11/05/2021 by Matt Alexander
1 answerI have a ton of configured connections listed in the Server Groups, is there a way I can save this? not just save the passwords but the Server Group Settings...
Asked on 11/05/2021 by Phill Pafford
5 answerCan anyone help me to find a below given details for long running query.ProcessID, process name, database, host ,user ,process login time, query start time and query duration. ...
Asked on 11/05/2021 by user3598321
2 answerI have a query that is not using existing indices and I do not understand why. The table:mustang=# d+ bss.amplifier_saturation ...
Asked on 11/05/2021 by andrew cooke
1 answerThis seems like a really simple request, but I can't find the answer. I'll admit that I only have a very limited understanding of JOINs, so it could just be...
Asked on 11/05/2021
1 answerI have restored a database in another server. I don't want any of the transactional subscriptions of the former database. I already calledexec sp_removedbreplication 'MyRestoredDB' goAnd alsoexec...
Asked on 11/05/2021 by ReluctantDBA
1 answerI have a directory of text files, as the filename is the id, and the content text for this table:CREATE TABLE texts(ID int(11) unsigned,Added date,Text MEDIUMTEXT,PRIMARY KEY(ID)) ENGINE=InnoDB DEFAULT...
Asked on 11/05/2021
2 answerGet help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP