https://www.tntware.com/donorwise/faqs/en/how-can-i-run-a-sql-command-against-my-donorwise-database.aspxen-USCommunityServer 2008.5 SP2 (Debug Build: 40407.4157)https://www.tntware.com/donorwise/faqs/en/how-can-i-run-a-sql-command-against-my-donorwise-database.aspxWed, 27 Aug 2014 19:54:30 GMTde06579a-5120-4393-a24b-6f68f5e7a3ec:22Troy Wolbrinkhttps://www.tntware.com/donorwise/faqs/en/how-can-i-run-a-sql-command-against-my-donorwise-database/comments.aspxCurrent revision posted to Frequently Asked Questions by Troy Wolbrink on 8/27/2014 7:54:30 PM<br /> <h2>How can I run a SQL command against my DonorWise database?</h2> <p><a href="/donorwise/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/en/7607.sql-studio-as-admin.png"></a>First you need to launch &quot;SQL Server Management Studio&quot;.&nbsp; If it&#39;s installed, you&#39;ll find it in your Start Menu \ Programs.&nbsp; For example:</p> <p><a href="/donorwise/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/en/2063.sql-studio-a.png"><img src="/donorwise/cfs-filesystemfile.ashx/__key/CommunityServer.Components.ImageFileViewer/CommunityServer.Wikis.Components.Files.en/2063.sql-studio-a.png_2D00_550x0.png" border="0" alt="" /></a></p> <p>When you launch it, choose &quot;Windows Authentication&quot;:</p> <p><a href="/donorwise/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/en/5483.sql-studio.jpg"><img src="/donorwise/cfs-filesystemfile.ashx/__key/CommunityServer.Components.ImageFileViewer/CommunityServer.Wikis.Components.Files.en/5483.sql-studio.jpg_2D00_550x0.jpg" border="0" alt="" /></a></p> <p>Then click &quot;New Query&quot;.&nbsp; Chose your DonorWise database.&nbsp; Then paste your query into the editor and click &quot;Execute&quot;:</p> <p><a href="/donorwise/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/en/6557.sql-studio-2.png"><img src="/donorwise/cfs-filesystemfile.ashx/__key/CommunityServer.Components.ImageFileViewer/CommunityServer.Wikis.Components.Files.en/6557.sql-studio-2.png_2D00_550x0.png" border="0" alt="" /></a></p> <p><a href="/donorwise/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/en/2063.sql-studio-a.png"></a></p> <p>&nbsp;<span style="background: SpringGreen;">If</span> <span style="background: SpringGreen;">you</span> <span style="background: SpringGreen;">get</span> <span style="background: SpringGreen;">an</span> <span style="background: SpringGreen;">error</span> <span style="background: SpringGreen;">about</span> <span style="background: SpringGreen;">permissions</span><span style="background: SpringGreen;">,</span> <span style="background: SpringGreen;">you</span> <span style="background: SpringGreen;">may</span> <span style="background: SpringGreen;">need</span> <span style="background: SpringGreen;">to</span> <span style="background: SpringGreen;">run</span> <span style="background: SpringGreen;">it</span> <span style="background: SpringGreen;">&quot;As</span> <span style="background: SpringGreen;">Administrator</span><span style="background: SpringGreen;">&quot;.&nbsp;</span> <span style="background: SpringGreen;">To</span> <span style="background: SpringGreen;">do</span> <span style="background: SpringGreen;">this</span><span style="background: SpringGreen;">,</span> <span style="background: SpringGreen;">close</span> <span style="background: SpringGreen;">SQL</span> <span style="background: SpringGreen;">Server</span> <span style="background: SpringGreen;">Management</span> <span style="background: SpringGreen;">Studio</span><span style="background: SpringGreen;">,</span> <span style="background: SpringGreen;">then</span> <span style="background: SpringGreen;">right-click</span> <span style="background: SpringGreen;">on</span> <span style="background: SpringGreen;">the</span> <span style="background: SpringGreen;">icon</span> <span style="background: SpringGreen;">and</span> <span style="background: SpringGreen;">choose</span> <span style="background: SpringGreen;">&quot;Run</span> <span style="background: SpringGreen;">as</span> <span style="background: SpringGreen;">administrator</span><span style="background: SpringGreen;">&quot;:</span></p> <p>&nbsp;<a href="/donorwise/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/en/7607.sql-studio-as-admin.png"><span style="background: SpringGreen;"><img src="/donorwise/cfs-filesystemfile.ashx/__key/CommunityServer.Components.ImageFileViewer/CommunityServer.Wikis.Components.Files.en/7607.sql-studio-as-admin.png_2D00_550x0.png" border="0" alt="" /></span></a></p> <p>&nbsp;</p>https://www.tntware.com/donorwise/faqs/en/how-can-i-run-a-sql-command-against-my-donorwise-database/revision/1.aspxWed, 27 Aug 2014 19:52:31 GMTde06579a-5120-4393-a24b-6f68f5e7a3ec:29Troy Wolbrinkhttps://www.tntware.com/donorwise/faqs/en/how-can-i-run-a-sql-command-against-my-donorwise-database/comments.aspxRevision 1 posted to Frequently Asked Questions by Troy Wolbrink on 8/27/2014 7:52:31 PM<br /> <p>First you need to launch &quot;SQL Server Management Studio&quot;.&nbsp; If it&#39;s installed, you&#39;ll find it in your Start Menu \ Programs.&nbsp; For example:</p> <p><a href="/donorwise/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/en/2063.sql-studio-a.png"><img src="/donorwise/cfs-filesystemfile.ashx/__key/CommunityServer.Components.ImageFileViewer/CommunityServer.Wikis.Components.Files.en/2063.sql-studio-a.png_2D00_550x0.png" border="0" alt="" /></a></p> <p>When you launch it, choose &quot;Windows Authentication&quot;:</p> <p><a href="/donorwise/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/en/5483.sql-studio.jpg"><img src="/donorwise/cfs-filesystemfile.ashx/__key/CommunityServer.Components.ImageFileViewer/CommunityServer.Wikis.Components.Files.en/5483.sql-studio.jpg_2D00_550x0.jpg" border="0" alt="" /></a></p> <p>Then click &quot;New Query&quot;.&nbsp; Chose your DonorWise database.&nbsp; Then paste your query into the editor and click &quot;Execute&quot;:</p> <p><a href="/donorwise/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/en/6557.sql-studio-2.png"><img src="/donorwise/cfs-filesystemfile.ashx/__key/CommunityServer.Components.ImageFileViewer/CommunityServer.Wikis.Components.Files.en/6557.sql-studio-2.png_2D00_550x0.png" border="0" alt="" /></a></p> <p><a href="/donorwise/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/en/2063.sql-studio-a.png"></a></p> <p>&nbsp;</p> <p>&nbsp;</p>