SQL Server Management Studio (SSMS) Object Explorer-\u0434 \u0441\u0435\u0440\u0432\u0435\u0440 \u0434\u044d\u044d\u0440 \u0445\u0443\u043b\u0433\u0430\u043d\u044b \u0431\u0430\u0440\u0443\u0443\u043d \u0442\u043e\u0432\u0447\u0438\u0439\u0433 \u0434\u0430\u0440\u0430\u0430\u0434 Properties-\u0433 \u0441\u043e\u043d\u0433\u043e\u043d\u043e \u0443\u0443. \u0410\u044e\u0443\u043b\u0433\u04af\u0439 \u0431\u0430\u0439\u0434\u043b\u044b\u043d \u0445\u0443\u0443\u0434\u0430\u0441\u043d\u044b \u0421\u0435\u0440\u0432\u0435\u0440\u0438\u0439\u043d \u043d\u044d\u0432\u0442\u0440\u044d\u043b\u0442 \u0442\u0430\u043d\u0438\u043b\u0442 \u0434\u043e\u043e\u0440\u043e\u043e\u0441 ‘SQL \u0431\u043e\u043b\u043e\u043d Windows \u0431\u0430\u0442\u0430\u043b\u0433\u0430\u0430\u0436\u0443\u0443\u043b\u0430\u043b\u0442\u044b\u043d \u0433\u043e\u0440\u0438\u043c’-\u044b\u0433 \u0441\u043e\u043d\u0433\u043e\u043e\u0434 OK-\u0433 \u0441\u043e\u043d\u0433\u043e\u043d\u043e \u0443\u0443. \u0422\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u044d\u044d \u0434\u0430\u0445\u0438\u043d \u044d\u0445\u043b\u04af\u04af\u043b\u044d\u0445 \u0445\u044d\u0440\u044d\u0433\u0442\u044d\u0439.<\/p>\n\n\n\n
\u0422\u0430 \u0442\u0443\u0448\u0430\u0430\u043b\u044b\u043d \u043c\u04e9\u0440\u04e9\u04e9\u0441 \u043c\u044d\u0434\u044d\u044d\u043b\u043b\u0438\u0439\u043d \u0441\u0430\u043d\u0434 \u0445\u0430\u043d\u0434\u0430\u0445\u044b\u0433 \u043e\u0440\u043e\u043b\u0434\u043e\u0436 \u0431\u043e\u043b\u043d\u043e:<\/p>\n\n\n\n
sqlcmd -S server -d \u043c\u044d\u0434\u044d\u044d\u043b\u043b\u0438\u0439\u043d \u0441\u0430\u043d -U \u0445\u044d\u0440\u044d\u0433\u043b\u044d\u0433\u0447\u0438\u0439\u043d \u043d\u044d\u0440 -P \u043d\u0443\u0443\u0446 \u04af\u0433<\/p>\n\n\n\n
\u0416\u0438\u0448\u044d\u044d:<\/p>\n\n\n\n
sqlcmd -S SQLEXPRESS -d OFFICE_DB -U vs4 -P 123456qAz!<\/p>\n","protected":false},"excerpt":{"rendered":"
SQL Server Management Studio (SSMS) Object Explorer-\u0434 \u0441\u0435\u0440\u0432\u0435\u0440 \u0434\u044d\u044d\u0440 \u0445\u0443\u043b\u0433\u0430\u043d\u044b \u0431\u0430\u0440\u0443\u0443\u043d \u0442\u043e\u0432\u0447\u0438\u0439\u0433 \u0434\u0430\u0440\u0430\u0430\u0434 Properties-\u0433 \u0441\u043e\u043d\u0433\u043e\u043d\u043e \u0443\u0443. \u0410\u044e\u0443\u043b\u0433\u04af\u0439 \u0431\u0430\u0439\u0434\u043b\u044b\u043d \u0445\u0443\u0443\u0434\u0430\u0441\u043d\u044b \u0421\u0435\u0440\u0432\u0435\u0440\u0438\u0439\u043d \u043d\u044d\u0432\u0442\u0440\u044d\u043b\u0442 \u0442\u0430\u043d\u0438\u043b\u0442 \u0434\u043e\u043e\u0440\u043e\u043e\u0441 ‘SQL \u0431\u043e\u043b\u043e\u043d Windows \u0431\u0430\u0442\u0430\u043b\u0433\u0430\u0430\u0436\u0443\u0443\u043b\u0430\u043b\u0442\u044b\u043d \u0433\u043e\u0440\u0438\u043c’-\u044b\u0433 \u0441\u043e\u043d\u0433\u043e\u043e\u0434 OK-\u0433 \u0441\u043e\u043d\u0433\u043e\u043d\u043e \u0443\u0443. \u0422\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u044d\u044d \u0434\u0430\u0445\u0438\u043d \u044d\u0445\u043b\u04af\u04af\u043b\u044d\u0445 \u0445\u044d\u0440\u044d\u0433\u0442\u044d\u0439. \u0422\u0430 \u0442\u0443\u0448\u0430\u0430\u043b\u044b\u043d \u043c\u04e9\u0440\u04e9\u04e9\u0441 \u043c\u044d\u0434\u044d\u044d\u043b\u043b\u0438\u0439\u043d \u0441\u0430\u043d\u0434 \u0445\u0430\u043d\u0434\u0430\u0445\u044b\u0433 \u043e\u0440\u043e\u043b\u0434\u043e\u0436 \u0431\u043e\u043b\u043d\u043e: sqlcmd -S server -d \u043c\u044d\u0434\u044d\u044d\u043b\u043b\u0438\u0439\u043d \u0441\u0430\u043d -U \u0445\u044d\u0440\u044d\u0433\u043b\u044d\u0433\u0447\u0438\u0439\u043d \u043d\u044d\u0440 -P […]<\/p>\n","protected":false},"author":65283547,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[559],"tags":[765254636],"class_list":["post-237","post","type-post","status-publish","format-standard","hentry","category-559","tag-mssql--"],"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4CoHV-3P","jetpack-related-posts":[{"id":174,"url":"https:\/\/vkrastev1blog.com\/2022\/02\/08\/create-dump-from-oracle-schema-in-console-in-linux\/","url_meta":{"origin":237,"position":0},"title":"\u041b\u0438\u043d\u0443\u043a\u0441 \u0434\u044d\u044d\u0440 \u043a\u043e\u043d\u0441\u043e\u043b \u0434\u044d\u044d\u0440 Oracle \u0441\u0445\u0435\u043c\u044d\u044d\u0441 Dump \u04af\u04af\u0441\u0433\u044d\u0445","author":"vkrastev2014","date":"08.02.2022","format":false,"excerpt":"It is not easy to find the correct way to execute expdp command in console. There are some steps before you execute expdp command. First you have to create a directory on the computer where Oracle DB is, where you will put the dump files than you have to grant\u2026","rel":"","context":"In "\u0411\u0443\u0441\u0430\u0434"","block_context":{"text":"\u0411\u0443\u0441\u0430\u0434","link":"https:\/\/vkrastev1blog.com\/category\/%d0%b1%d1%83%d1%81%d0%b0%d0%b4\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":224,"url":"https:\/\/vkrastev1blog.com\/2022\/06\/01\/eclipse-problem-by-changing-git-password\/","url_meta":{"origin":237,"position":1},"title":"GIT \u043d\u0443\u0443\u0446 \u04af\u0433\u0438\u0439\u0433 \u04e9\u04e9\u0440\u0447\u043b\u04e9\u0445 \u0437\u0430\u043c\u0430\u0430\u0440 Eclipse-\u0438\u0439\u043d \u0430\u0441\u0443\u0443\u0434\u0430\u043b","author":"vkrastev2014","date":"01.06.2022","format":false,"excerpt":"I have had a problem by changing the GIT password in Eclipse. Eclipse could not change the password in the secure storage and I couldn't use GIT anymore. You schould do following: Eclipse go to Preferences -> General -> Security -> Secure storage and in Contents tab delete \"Default Secure\u2026","rel":"","context":"In "Java"","block_context":{"text":"Java","link":"https:\/\/vkrastev1blog.com\/category\/java\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":55,"url":"https:\/\/vkrastev1blog.com\/2014\/05\/11\/important-shell-script-commands-which-are-oft-used\/","url_meta":{"origin":237,"position":2},"title":"\u0418\u0445\u044d\u043d\u0445\u0434\u044d\u044d \u0430\u0448\u0438\u0433\u043b\u0430\u0434\u0430\u0433 Shell \u0441\u043a\u0440\u0438\u043f\u0442\u0438\u0439\u043d \u0447\u0443\u0445\u0430\u043b \u043a\u043e\u043c\u0430\u043d\u0434\u0443\u0443\u0434","author":"vkrastev2014","date":"11.05.2014","format":false,"excerpt":"Here is a list of some important shell commands: ---- Using Screen command screen -ls -- for a list of avaliable active screens screen -x .... - the Name from -ls output to join to this active screen Go out of the Screen with 'ctrl a+d' without stopping it ----\u2026","rel":"","context":"In "\u0411\u0443\u0441\u0430\u0434"","block_context":{"text":"\u0411\u0443\u0441\u0430\u0434","link":"https:\/\/vkrastev1blog.com\/category\/%d0%b1%d1%83%d1%81%d0%b0%d0%b4\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":167,"url":"https:\/\/vkrastev1blog.com\/2022\/02\/01\/sql-developer-execute-big-sql-files-scripts-in-sql-developer\/","url_meta":{"origin":237,"position":3},"title":"SQL Developer – SQL Developer \u0434\u044d\u044d\u0440 \u0442\u043e\u043c .sql \u0444\u0430\u0439\u043b\/\u0441\u043a\u0440\u0438\u043f\u0442\u04af\u04af\u0434\u0438\u0439\u0433 \u0430\u0436\u0438\u043b\u043b\u0443\u0443\u043b\u043d\u0430","author":"vkrastev2014","date":"01.02.2022","format":false,"excerpt":"SQL Developer - execute big .sql files\/scripts in SQL Developer Open SQL Developer than press Alt - F10 and it will show you a Choose Connection dialog. Choose a Connection and it opens a SQL Editor for that connection. Write in it just @C:\\Users\\KrastevV\\Project\\sql.sql Sign @ followed by the Path\u2026","rel":"","context":"In "\u0411\u0443\u0441\u0430\u0434"","block_context":{"text":"\u0411\u0443\u0441\u0430\u0434","link":"https:\/\/vkrastev1blog.com\/category\/%d0%b1%d1%83%d1%81%d0%b0%d0%b4\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2022\/02\/bild.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2022\/02\/bild.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2022\/02\/bild.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2022\/02\/bild.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":229,"url":"https:\/\/vkrastev1blog.com\/2022\/06\/03\/eclipse-tomcat-no-catalina-out-log\/","url_meta":{"origin":237,"position":4},"title":"Eclipse Tomcat \u044f\u043c\u0430\u0440 \u0447 catalina.out \u0431\u04af\u0440\u0442\u0433\u044d\u043b","author":"vkrastev2014","date":"03.06.2022","format":false,"excerpt":"In Eclipse you have already added Tomcat as Server than you do following: In the servers tab, double-click on the Tomcat Server. You will get a screen called Overview.Click on \"Open launch configuration\". Click on the \"Common\" tab.Towards the bottom of the screen you can check the \"Output File\" checkbox\u2026","rel":"","context":"In "Java"","block_context":{"text":"Java","link":"https:\/\/vkrastev1blog.com\/category\/java\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":194,"url":"https:\/\/vkrastev1blog.com\/2022\/03\/30\/java-configure-log4j2-in-your-project\/","url_meta":{"origin":237,"position":5},"title":"Java-\u0433 \u0422\u04e9\u0441\u04e9\u043b\u0434\u04e9\u04e9 Log4j2-\u0433 \u0442\u043e\u0445\u0438\u0440\u0443\u0443\u043b\u043d\u0430 \u0443\u0443","author":"vkrastev2014","date":"30.03.2022","format":false,"excerpt":"Log4j2 and SLF4j Binding DependenciesTo make Log4j2 work with SLF4J, we need to include the following 3 dependencies. log4j-slf4j-impl.jar \u2013 Log4j 2 SLF4J binding. It allows applications coded to the SLF4J API to use Log4j2 as the implementation.log4j-api.jar \u2013 provides the adapter components required for implementers to create a logging\u2026","rel":"","context":"In "Java"","block_context":{"text":"Java","link":"https:\/\/vkrastev1blog.com\/category\/java\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/posts\/237","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/users\/65283547"}],"replies":[{"embeddable":true,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/comments?post=237"}],"version-history":[{"count":4,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/posts\/237\/revisions"}],"predecessor-version":[{"id":241,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/posts\/237\/revisions\/241"}],"wp:attachment":[{"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/media?parent=237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/categories?post=237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/tags?post=237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}