<?xml version="1.0" encoding="UTF-8"?>
<!-- generator="wordpress/2.2.1" -->
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	>

<channel>
	<title>1-2Remember</title>
	<link>http://www.1-2remember.nl/blog</link>
	<description>The blog about IT, Music and much more.</description>
	<pubDate>Fri, 29 Jun 2007 06:31:28 +0000</pubDate>
	<generator>http://wordpress.org/?v=2.2.1</generator>
	<language>en</language>
			<item>
		<title>Upgrade from Sql 2000 to SQL 2005 creates unwanted schemas</title>
		<link>http://www.1-2remember.nl/blog/?p=14</link>
		<comments>http://www.1-2remember.nl/blog/?p=14#comments</comments>
		<pubDate>Thu, 28 Jun 2007 13:18:40 +0000</pubDate>
		<dc:creator>admin</dc:creator>
		
		<category><![CDATA[SQL Server 2005]]></category>

		<guid isPermaLink="false">http://www.1-2remember.nl/blog/?p=14</guid>
		<description><![CDATA[During an upgrade of Microsoft SQL 2000 to Microsoft SQL server 2005, SQL Server will create a schema for each user in the database. These schema&#8217;s need to be cleaned up afterwards. This article helps you in cleaning up these schema&#8217;s
]]></description>
		<wfw:commentRss>http://www.1-2remember.nl/blog/?feed=rss2&amp;p=14</wfw:commentRss>
		</item>
		<item>
		<title>Execute CmdExec / sp_cmdExec by non-SysAdmin</title>
		<link>http://www.1-2remember.nl/blog/?p=7</link>
		<comments>http://www.1-2remember.nl/blog/?p=7#comments</comments>
		<pubDate>Wed, 27 Jun 2007 14:11:36 +0000</pubDate>
		<dc:creator>admin</dc:creator>
		
		<category><![CDATA[SQL Server 2005]]></category>

		<guid isPermaLink="false">http://www.1-2remember.nl/blog/?p=7</guid>
		<description><![CDATA[In SQL Server 2000, a single configuration was available for the SQL Server Agent Proxy account.  With SQL Server 2005, now 11 different proxies are available for each of the SQL Server Agent subsystems.  This offers a great deal of flexibility and greater security for each of these subsystems for logins and roles that do [...]]]></description>
		<wfw:commentRss>http://www.1-2remember.nl/blog/?feed=rss2&amp;p=7</wfw:commentRss>
		</item>
		<item>
		<title>Run SQL job by a non-Sysadmin user.</title>
		<link>http://www.1-2remember.nl/blog/?p=3</link>
		<comments>http://www.1-2remember.nl/blog/?p=3#comments</comments>
		<pubDate>Wed, 27 Jun 2007 11:40:40 +0000</pubDate>
		<dc:creator>admin</dc:creator>
		
		<category><![CDATA[SQL Server 2005]]></category>

		<guid isPermaLink="false">http://www.1-2remember.nl/blog/?p=3</guid>
		<description><![CDATA[Jobs which run for a specific application should be executed by an account of that application. This will probably be a function account. The following steps should be taken in order to let a non-SysAdmin execute a job.
1. Open the Management Studio and connect to the database instance your job is running on.
2. Select the “Properties” of [...]]]></description>
		<wfw:commentRss>http://www.1-2remember.nl/blog/?feed=rss2&amp;p=3</wfw:commentRss>
		</item>
	</channel>
</rss>
