<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-3026901918966367092</id><updated>2026-01-29T22:33:13.545-05:00</updated><category term="Sql Server"/><category term="Sql Server 2000"/><category term="Sql Server 2005"/><category term="Sql Server 2008"/><category term="Asp.Net"/><category term="MySQL"/><category term="SQL"/><category term="C# Net"/><category term="VB Net"/><category term="IE8"/><category term="Menu Asp.Net"/><category term="Mi menú ASP.NET no se ve en Internet Explorer 8"/><category term="PHP"/><category term="PHPList"/><category term="Solución Compatibilidad IE8"/><category term="Solución Menu internet explorer 8"/><category term="VB.NET"/><category term="VB.NET 2005"/><category term="VS 2005"/><title type='text'>Todo en Programación</title><subtitle type='html'>Todo en programación, trucos, soluciones, ejemplos, todo gratis, sql, sql server</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://progamaciongratis.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://progamaciongratis.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>18</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-3026901918966367092.post-5188376871624854015</id><published>2013-04-15T11:19:00.001-05:00</published><updated>2013-04-15T11:32:37.871-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2000"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2005"/><title type='text'>Renombrar tabla en SQL Server </title><content type='html'>&lt;div dir=&quot;ltr&quot;&gt;
Para poder renombrar una tabla en SQL Server se puede hacer por un procedimiento almacenado &quot;Stored Procedure&quot; que trae el motor de la base de datos, este cambio se realiza de la siguiente manera:&lt;br /&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;bgcode&quot; dir=&quot;ltr&quot;&gt;
&lt;span style=&quot;color: blue;&quot;&gt;EXEC &lt;/span&gt;&lt;span style=&quot;color: maroon;&quot;&gt;SP_RENAME &lt;/span&gt;&lt;span style=&quot;color: red;&quot;&gt;&#39;Nombre_Tabla_Actual&#39;&lt;/span&gt;, &lt;span style=&quot;color: red;&quot;&gt;&#39;Nuevo_Nombre_Tabla&#39; &lt;/span&gt;&lt;br /&gt;
&lt;/div&gt;
&lt;br /&gt;
La ejecución anterior como resultado nos debe mostrar algo como
&lt;br /&gt;
&lt;div class=&quot;bgcode&quot; dir=&quot;ltr&quot;&gt;
Caution: changing any part of an object name could break scripts and stored procedures.&lt;br /&gt;
The object was renamed to &#39;Nuevo_Nombre_Tabla&#39;&lt;br /&gt;
&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div dir=&quot;ltr&quot;&gt;
Este&amp;nbsp; mensaje nos confirma el cambio de nombre de la tabla pero adicional a esto nos indica que debemos tener cuidado con lo siguiente. Sí la tabla a la que le acabamos de cambiar el nombre la estamos usando desde procedimientos almacenados, funciones o desde una aplicación sería necesario validar si allá también es necesario&amp;nbsp;realizar&amp;nbsp;el cambio.&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://progamaciongratis.blogspot.com/feeds/5188376871624854015/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://progamaciongratis.blogspot.com/2013/04/renombrar-tabla-en-sql-server.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/5188376871624854015'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/5188376871624854015'/><link rel='alternate' type='text/html' href='http://progamaciongratis.blogspot.com/2013/04/renombrar-tabla-en-sql-server.html' title='Renombrar tabla en SQL Server '/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3026901918966367092.post-4433888146896420937</id><published>2012-11-02T09:16:00.001-05:00</published><updated>2012-11-02T12:17:11.839-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="PHP"/><category scheme="http://www.blogger.com/atom/ns#" term="PHPList"/><title type='text'>Solucción PHPList Mailer Error: Could not instantiate mail function.</title><content type='html'>En mi caso&amp;nbsp;sucedió&amp;nbsp;que necesitaba usar el PHPList para envió de correo usando el protocolo SMTP y en el archivo config.php lo configure de la siguiente manera&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;bgcode&quot;&gt;
&lt;span style=&quot;color: blue;&quot;&gt;$bounce_mailbox_host &lt;/span&gt;&lt;span style=&quot;color: #351c75;&quot;&gt;=&lt;/span&gt;&lt;span style=&quot;color: #93c47d;&quot;&gt; &#39;mail.server.com&#39;&lt;/span&gt;&lt;span style=&quot;color: #351c75;&quot;&gt;;


&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;$bounce_mailbox_user&lt;/span&gt; &lt;span style=&quot;background-color: white;&quot;&gt;&lt;span style=&quot;color: #674ea7;&quot;&gt;= &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: #93c47d;&quot;&gt;&#39;usuario&#39;&lt;/span&gt;&lt;span style=&quot;color: #351c75;&quot;&gt;;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;$bounce_mailbox_password&lt;/span&gt; &lt;span style=&quot;color: #351c75;&quot;&gt;= &lt;/span&gt;&lt;span style=&quot;color: #6aa84f;&quot;&gt;&#39;**********&#39;&lt;/span&gt;&lt;span style=&quot;color: #351c75;&quot;&gt;;&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
Lo que tengo entendido es que para poder enviar los correos y que sea por el protocolo SMTP se debe configurar el servidor en el archivo config.php pero en la siguiente linea&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;bgcode&quot;&gt;
&lt;span style=&quot;color: blue;&quot;&gt;define&lt;/span&gt;&lt;span style=&quot;color: #351c75;&quot;&gt;(&lt;/span&gt;&lt;span style=&quot;color: #6aa84f;&quot;&gt;&quot;PHPMAILERHOST&quot;&lt;/span&gt;&lt;span style=&quot;color: #351c75;&quot;&gt;,&lt;/span&gt;&lt;span style=&quot;color: #6aa84f;&quot;&gt;&#39;
mail.server.com&amp;nbsp;&#39;&lt;/span&gt;&lt;span style=&quot;color: #351c75;&quot;&gt;);&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;
No olviden dejar TEST en 0&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;bgcode&quot;&gt;
&lt;span style=&quot;color: blue;&quot;&gt;define &lt;/span&gt;&lt;span style=&quot;color: #351c75;&quot;&gt;(&lt;/span&gt;&lt;span style=&quot;color: #6aa84f;&quot;&gt;&quot;TEST&quot;&lt;/span&gt;&lt;span style=&quot;color: #351c75;&quot;&gt;,&lt;/span&gt;&lt;span style=&quot;color: #6aa84f;&quot;&gt;0&lt;/span&gt;&lt;span style=&quot;color: #351c75;&quot;&gt;);&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: #351c75;&quot;&gt;&lt;/span&gt;
&lt;/div&gt;

Espero les haya servido.</content><link rel='replies' type='application/atom+xml' href='http://progamaciongratis.blogspot.com/feeds/4433888146896420937/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://progamaciongratis.blogspot.com/2012/11/soluccion-phplist-mailer-error-could.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/4433888146896420937'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/4433888146896420937'/><link rel='alternate' type='text/html' href='http://progamaciongratis.blogspot.com/2012/11/soluccion-phplist-mailer-error-could.html' title='Solucción PHPList Mailer Error: Could not instantiate mail function.'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3026901918966367092.post-4980250817291294609</id><published>2012-08-02T12:54:00.001-05:00</published><updated>2012-08-02T12:54:10.008-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="MySQL"/><title type='text'>Como Crear una Tabla en MySQL</title><content type='html'>Con el siguiente ejemplo vamos a ver como se crea una tabla en MySQL.&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;bgcode&quot;&gt;
&lt;b&gt;&lt;span style=&quot;color: #00b050;&quot;&gt;CREATE TABLE&lt;/span&gt;&lt;/b&gt; NOM_TABLA_NUEVA(&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ID_NOM_TABLA &lt;span style=&quot;color: #00b050;&quot;&gt;&lt;b&gt;INT NOT NULL&lt;/b&gt;&lt;/span&gt;,&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;NOMBRE_CAMPO1 &lt;span style=&quot;color: #00b050; font-weight: bold;&quot;&gt;VARCHAR(&lt;/span&gt;&lt;span style=&quot;color: #7f6000;&quot;&gt;20&lt;/span&gt;&lt;span style=&quot;color: #00b050; font-weight: bold;&quot;&gt;) NULL&lt;/span&gt;&lt;b&gt;,&lt;/b&gt;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;NOMBRE_CAMPO2 &lt;span style=&quot;color: #00b050; font-weight: bold;&quot;&gt;NUMERIC(&lt;/span&gt;&lt;span style=&quot;color: #7f6000;&quot;&gt;18,2&lt;/span&gt;&lt;span style=&quot;color: #00b050; font-weight: bold;&quot;&gt;) NOT NULL&lt;/span&gt;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; );&lt;br /&gt;
&lt;br /&gt;
En el ejemplo anterior se crea una tabla en MySQL llamada&amp;nbsp;NOM_TABLA_NUEVA con sus respectivos campos.&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://progamaciongratis.blogspot.com/feeds/4980250817291294609/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://progamaciongratis.blogspot.com/2012/08/como-crear-una-tabla-en-mysql.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/4980250817291294609'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/4980250817291294609'/><link rel='alternate' type='text/html' href='http://progamaciongratis.blogspot.com/2012/08/como-crear-una-tabla-en-mysql.html' title='Como Crear una Tabla en MySQL'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3026901918966367092.post-7340024155932007971</id><published>2011-09-30T19:23:00.000-05:00</published><updated>2011-09-30T19:23:23.610-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="MySQL"/><title type='text'>Buscar si una vista existe en MySQL</title><content type='html'>&lt;br /&gt;
&lt;div style=&quot;margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;
Está es una manera para buscar si una vista existe en una base de datos de MySQL.&lt;/div&gt;
&lt;div style=&quot;margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;
Para hacerlo ejecute la siguiente&amp;nbsp;instrucción:&lt;/div&gt;
&lt;div style=&quot;margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;bgcode&quot;&gt;
&lt;div style=&quot;margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;
&lt;b&gt;&lt;span style=&quot;color: #00b050;&quot;&gt;SELECT&lt;/span&gt;&lt;/b&gt;&amp;nbsp;TABLE_SCHEMA&amp;nbsp;&lt;b&gt;&lt;span style=&quot;color: #00b050;&quot;&gt;AS&lt;/span&gt;&lt;/b&gt;&amp;nbsp;BD, TABLE_NAME&amp;nbsp;&lt;b&gt;&lt;span style=&quot;color: #00b050;&quot;&gt;AS&lt;/span&gt;&lt;/b&gt;&amp;nbsp;NOMBRE_VISTA&lt;/div&gt;
&lt;div style=&quot;margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;
&lt;b&gt;&lt;span style=&quot;color: #00b050;&quot;&gt;FROM&lt;/span&gt;&lt;/b&gt;&amp;nbsp;information_schema.tables&lt;/div&gt;
&lt;div style=&quot;margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;
&lt;b&gt;&lt;span style=&quot;color: #00b050;&quot;&gt;WHERE&lt;/span&gt;&lt;/b&gt;&amp;nbsp;table_name&amp;nbsp;&lt;b&gt;&lt;span style=&quot;color: #00b050;&quot;&gt;like&lt;/span&gt;&amp;nbsp;&lt;span style=&quot;color: #ffc000;&quot;&gt;&#39;%my_vista%&#39;&lt;/span&gt;&lt;/b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: #00b050;&quot;&gt;&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/span&gt;&lt;b&gt;&lt;span style=&quot;color: #00b050;&quot;&gt;ORDER BY&lt;/span&gt;&lt;/b&gt;&amp;nbsp;table_name&amp;nbsp;&lt;b&gt;&lt;span style=&quot;color: #00b050;&quot;&gt;DESC&lt;/span&gt;&lt;/b&gt;;&lt;/div&gt;
&lt;/div&gt;
&lt;div style=&quot;margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;div style=&quot;margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;div style=&quot;margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;
Tener en cuenta que esta consulta buscara en todas las base de datos de nuestro motor de MySQL. Si se quiere hacer la consulta para una base de datos especifica es solo agregar en la condición&amp;nbsp;&lt;span style=&quot;color: #00b050;&quot;&gt;&lt;b&gt;WHERE&lt;/b&gt;&amp;nbsp;&lt;/span&gt;TABLE_SCHEMA =&amp;nbsp;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: #ffc000;&quot;&gt;&lt;b&gt;&#39;nombre_base_datos&#39;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: #ffc000;&quot;&gt;&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://progamaciongratis.blogspot.com/feeds/7340024155932007971/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://progamaciongratis.blogspot.com/2011/09/buscar-si-una-vista-existe-en-mysql.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/7340024155932007971'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/7340024155932007971'/><link rel='alternate' type='text/html' href='http://progamaciongratis.blogspot.com/2011/09/buscar-si-una-vista-existe-en-mysql.html' title='Buscar si una vista existe en MySQL'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3026901918966367092.post-8327530565613178207</id><published>2011-09-29T12:21:00.000-05:00</published><updated>2011-09-30T08:04:18.103-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="MySQL"/><title type='text'>Buscar si una tabla existe en MySQL</title><content type='html'>Está es una manera para buscar si una tabla existe en una base de datos de MySQL.&lt;br /&gt;
&lt;br /&gt;
Para hacerlo ejecute la siguiente&amp;nbsp;instrucción:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;bgcode&quot;&gt;
&lt;b style=&quot;mso-bidi-font-weight: normal;&quot;&gt;&lt;span style=&quot;color: #00b050;&quot;&gt;SELECT&lt;/span&gt;&lt;/b&gt; TABLE_SCHEMA &lt;b style=&quot;mso-bidi-font-weight: normal;&quot;&gt;&lt;span style=&quot;color: #00b050;&quot;&gt;AS&lt;/span&gt;&lt;/b&gt; BD, TABLE_NAME &lt;b style=&quot;mso-bidi-font-weight: normal;&quot;&gt;&lt;span style=&quot;color: #00b050;&quot;&gt;AS&lt;/span&gt;&lt;/b&gt;
NOMBRE_TABLA, CREATE_TIME &lt;b style=&quot;mso-bidi-font-weight: normal;&quot;&gt;&lt;span style=&quot;color: #00b050;&quot;&gt;AS&lt;/span&gt;&lt;/b&gt; FECHA_CREACION, &lt;b style=&quot;mso-bidi-font-weight: normal;&quot;&gt;&lt;span style=&quot;color: #00b050;&quot;&gt;ENGINE&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;b style=&quot;mso-bidi-font-weight: normal;&quot;&gt;&lt;span style=&quot;color: #00b050;&quot;&gt;FROM&lt;/span&gt;&lt;/b&gt;
information_schema.tables&lt;br /&gt;
&lt;b style=&quot;mso-bidi-font-weight: normal;&quot;&gt;&lt;span style=&quot;color: #00b050;&quot;&gt;WHERE&lt;/span&gt;&lt;/b&gt;
table_name &lt;b style=&quot;mso-bidi-font-weight: normal;&quot;&gt;&lt;span style=&quot;color: #00b050;&quot;&gt;like&lt;/span&gt;
&lt;span style=&quot;color: #ffc000;&quot;&gt;&#39;%my_tabla%&#39;&lt;/span&gt;&lt;/b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: #00b050;&quot;&gt;&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/span&gt;
&lt;b style=&quot;mso-bidi-font-weight: normal;&quot;&gt;&lt;span style=&quot;color: #00b050;&quot;&gt;ORDER BY&lt;/span&gt;&lt;/b&gt;&amp;nbsp;table_name &lt;b style=&quot;mso-bidi-font-weight: normal;&quot;&gt;&lt;span style=&quot;color: #00b050;&quot;&gt;DESC&lt;/span&gt;&lt;/b&gt;;&lt;/div&gt;
&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
Tener en cuenta que esta consulta buscara en todas las base de datos de nuestro motor de MySQL. Si se quiere hacer la consulta para una base de datos especifica es solo agregar en la condición&amp;nbsp;&lt;span style=&quot;color: #00b050;&quot;&gt;&lt;b&gt;WHERE&lt;/b&gt;&amp;nbsp;&lt;/span&gt;TABLE_SCHEMA =&amp;nbsp;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: #ffc000;&quot;&gt;&lt;b&gt;&#39;nombre_base_datos&#39;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;</content><link rel='replies' type='application/atom+xml' href='http://progamaciongratis.blogspot.com/feeds/8327530565613178207/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://progamaciongratis.blogspot.com/2011/09/buscar-si-una-tabla-existe-en-mysql.html#comment-form' title='2 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/8327530565613178207'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/8327530565613178207'/><link rel='alternate' type='text/html' href='http://progamaciongratis.blogspot.com/2011/09/buscar-si-una-tabla-existe-en-mysql.html' title='Buscar si una tabla existe en MySQL'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3026901918966367092.post-1510741799799046091</id><published>2011-09-26T12:38:00.000-05:00</published><updated>2011-09-30T22:04:11.184-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2000"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2005"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2008"/><title type='text'>Como saber si una tabla existe en SQL Server</title><content type='html'>Para buscar un tabla en una Base de Datos de SQL Server 2000/2005/2008 se realiza con la siguiente instrucción:&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;bgcode&quot;&gt;
&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&lt;/span&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;SELECT &lt;/span&gt;&lt;span style=&quot;font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;*&lt;/span&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;FROM&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;color: green; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;INFORMATION_SCHEMA.TABLES&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: green; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&lt;/span&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;WHERE&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;TABLE_NAME&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;LIKE&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&#39;%Nombre_Tabla_Buscar%&#39;&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;
Ingresamos el nombre de nuestra Tabla, ejecutamos la consulta y listo nos&amp;nbsp;traerá&amp;nbsp;las como resulta las tablas que coincidan con el nombre.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;</content><link rel='replies' type='application/atom+xml' href='http://progamaciongratis.blogspot.com/feeds/1510741799799046091/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://progamaciongratis.blogspot.com/2011/09/como-saber-si-una-tabla-existe-en-sql.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/1510741799799046091'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/1510741799799046091'/><link rel='alternate' type='text/html' href='http://progamaciongratis.blogspot.com/2011/09/como-saber-si-una-tabla-existe-en-sql.html' title='Como saber si una tabla existe en SQL Server'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3026901918966367092.post-8441897293171455127</id><published>2011-09-26T12:30:00.000-05:00</published><updated>2011-09-30T22:05:58.608-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2000"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2005"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2008"/><title type='text'>Como saber si un campo existe en SQL Server</title><content type='html'>&lt;b&gt;Como saber si un campo existe en SQL Server.&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
Para saber si un campo existe o no en nuestra base de datos de SQL Server 2000/2005/2008. Lo primero que debemos hacer es ubicarnos en la base de datos que queremos encontrar el campo y copiamos la siguiente&amp;nbsp;sentencia:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;bgcode&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;&quot;&gt;
&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;SELECT&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;*&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&lt;/span&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;FROM&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: green; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;INFORMATION_SCHEMA.COLUMNS&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: green; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&lt;/span&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;WHERE&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; COLUMN_NAME &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;LIKE&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&#39;%Nombre_Campo_a_Buscar%&#39;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;&quot;&gt;
&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;&quot;&gt;
&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: 0.0001pt;&quot;&gt;
Al ejecutar la consulta anterior nos&amp;nbsp;traerá&amp;nbsp;todas las tablas que contienen el nombre que estamos buscando y tener en cuenta que estamos usando la condición &lt;b&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;LIKE&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/b&gt;con el&amp;nbsp;&lt;b&gt;% &lt;/b&gt;la cual nos&amp;nbsp;traerá las tablas en donde el campo coincida con parte del testo mencionado. Si se quiere buscar el campo exacto quitar &lt;b&gt;% &lt;/b&gt;o mejor cambiar&amp;nbsp;&lt;b&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;LIKE&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/b&gt;el por &lt;b&gt;=&lt;/b&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://progamaciongratis.blogspot.com/feeds/8441897293171455127/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://progamaciongratis.blogspot.com/2011/09/como-saber-si-un-campo-existe-en-sql.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/8441897293171455127'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/8441897293171455127'/><link rel='alternate' type='text/html' href='http://progamaciongratis.blogspot.com/2011/09/como-saber-si-un-campo-existe-en-sql.html' title='Como saber si un campo existe en SQL Server'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3026901918966367092.post-4971274135566583328</id><published>2011-09-20T13:52:00.000-05:00</published><updated>2012-08-14T09:23:55.867-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2000"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2005"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2008"/><title type='text'>Como agregar un usuario del Dominio o Grupo a SQL Server</title><content type='html'>Para agregar un usuario de nuestro domino de red o grupo a nuestra instancia de SQL Server 2000/2005/2008 se realiza de la siguiente manera:&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;bgcode&quot;&gt;
&lt;code&gt;
&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;exec&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt; sp_grantlogin @loginame&lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;=&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;&#39;Nombre_Dominio_Grupo\Nombre_Usuario&#39;&lt;/span&gt;&lt;/code&gt;&lt;/div&gt;
&lt;code&gt;
&lt;/code&gt;
&lt;code&gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&lt;/code&gt;&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;code&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: x-small;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;line-height: 14px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/code&gt;&lt;/div&gt;
&lt;code&gt;
&lt;/code&gt;&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;code&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: x-small;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;line-height: 14px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: black; font-family: &#39;Times New Roman&#39;; font-size: small; line-height: normal;&quot;&gt;Tener en cuenta que el nombre de usuario, debe existir creado en nuestro dominio o grupo.&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/code&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: x-small;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;line-height: 14px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: black; font-family: &#39;Times New Roman&#39;; font-size: small; line-height: normal;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: x-small;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;line-height: 14px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: black; font-family: &#39;Times New Roman&#39;; font-size: small; line-height: normal;&quot;&gt;&lt;b&gt;Nota:&lt;/b&gt;&amp;nbsp;Tener en cuenta que para poder ejecutar esta instrucción anterior se debe de tener permisos de&amp;nbsp;&lt;b&gt;SA&amp;nbsp;&lt;/b&gt;o&lt;b&gt;&amp;nbsp;ALTER ANY LOGIN&amp;nbsp;&amp;nbsp;&lt;/b&gt;en el servidor de la base de datos.&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://progamaciongratis.blogspot.com/feeds/4971274135566583328/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://progamaciongratis.blogspot.com/2011/09/como-agregar-un-usuario-del-dominio-o.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/4971274135566583328'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/4971274135566583328'/><link rel='alternate' type='text/html' href='http://progamaciongratis.blogspot.com/2011/09/como-agregar-un-usuario-del-dominio-o.html' title='Como agregar un usuario del Dominio o Grupo a SQL Server'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3026901918966367092.post-7728902590975992703</id><published>2011-09-20T13:38:00.000-05:00</published><updated>2012-08-14T09:00:38.820-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2000"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2005"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2008"/><title type='text'>Como Crear un usuario en SQL Server</title><content type='html'>Para crear un usuario en SQL Server 2000/2005/2008 &amp;nbsp;se hace ejecutando la siguiente instrucción&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;bgcode&quot;&gt;
&lt;code&gt;
&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;exec&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt; sp_addlogin&amp;nbsp; @loginame &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;=&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;&#39;Nombre_Usuario&#39;&lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;,&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;@passwd &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;=&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;&#39;Password_Usuario&#39;&lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;,&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;@defdb &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;=&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;&#39;Nombre_Base_Datos_Predeterminada&#39;&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/code&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;/div&gt;
&lt;ul&gt;
&lt;li&gt;&lt;b&gt;@loginame:&lt;/b&gt; Es el nombre de usuario que se va a crear.&lt;/li&gt;
&lt;li&gt;&lt;b&gt;@passwd:&lt;/b&gt; Contraseña que se va asignar.&lt;/li&gt;
&lt;li&gt;&lt;b&gt;@defdb:&lt;/b&gt;&amp;nbsp;Base de datos predeterminada cuando el usuario inicia sección, Si no va asignar una base de datos por Default puede omitir este&amp;nbsp;parámetro.&lt;/li&gt;
&lt;/ul&gt;
&lt;b&gt;Nota:&lt;/b&gt; Tener en cuenta que para poder ejecutar esta instrucción anterior se debe de tener permisos de &lt;b&gt;SA&amp;nbsp;&lt;/b&gt;o&lt;b&gt; ALTER ANY LOGIN&amp;nbsp;&amp;nbsp;&lt;/b&gt;en el servidor de la Base de Datos.&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: black; font-family: &#39;Times New Roman&#39;; font-size: small; line-height: normal;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: black; font-family: &#39;Times New Roman&#39;; font-size: small; line-height: normal;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://progamaciongratis.blogspot.com/feeds/7728902590975992703/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://progamaciongratis.blogspot.com/2011/09/como-crear-un-usuario-en-sql-server.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/7728902590975992703'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/7728902590975992703'/><link rel='alternate' type='text/html' href='http://progamaciongratis.blogspot.com/2011/09/como-crear-un-usuario-en-sql-server.html' title='Como Crear un usuario en SQL Server'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3026901918966367092.post-8798847437013199049</id><published>2011-09-19T13:43:00.000-05:00</published><updated>2011-09-30T22:38:41.582-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SQL"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2000"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2005"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2008"/><title type='text'>Cambiar Password en SQL Server</title><content type='html'>&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;span style=&quot;color: black; font-family: &#39;Times New Roman&#39;, serif; font-size: 12pt;&quot;&gt;Para cambiar la contraseña (Password) &amp;nbsp;de inicio de sección en SQL
Server 2000/2005/2008 se realiza ejecutando la siguiente Instrucción.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;bgcode&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;code&gt;
&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;exec&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;sp_password @old&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;=&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&#39;Contraseña_Anterior&#39;&lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;,&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: x-small;&quot;&gt;&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; @new&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;=&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&#39;Contraseña_Nueva&#39;&lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;,&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: x-small;&quot;&gt;&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; @loginame&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;=&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&#39;Nombre_Login&#39;&lt;/span&gt;&lt;span style=&quot;color: blue; font-family: &#39;Times New Roman&#39;, serif; font-size: 12pt; font-weight: bold;&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/code&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Times New Roman&#39;, serif;&quot;&gt;Ya con esto el Password quedará cambiado.&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://progamaciongratis.blogspot.com/feeds/8798847437013199049/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://progamaciongratis.blogspot.com/2011/09/cambiar-password-en-sql-server.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/8798847437013199049'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/8798847437013199049'/><link rel='alternate' type='text/html' href='http://progamaciongratis.blogspot.com/2011/09/cambiar-password-en-sql-server.html' title='Cambiar Password en SQL Server'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3026901918966367092.post-4993710713824491531</id><published>2011-09-12T11:35:00.000-05:00</published><updated>2013-09-27T17:51:38.005-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2000"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2005"/><title type='text'>Saber si una Tabla, Procedimiento Almacenado o Vista Existe en Sql Server</title><content type='html'>&lt;span style=&quot;font-size: small;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;font-size: small;&quot;&gt;Maneras de Saber si una Tabla, Procedimiento Almacenado o Vista existe en Sql Server&amp;nbsp; (Table, Stored Procedure or View)&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: small;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-size: small;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;font-size: small;&quot;&gt;&lt;/span&gt;Lo primero que debemos hacer es ubicarnos en la base de datos donde queremos validar si existe el objeto&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;bgcode&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;&quot;&gt;
&lt;br /&gt;
&lt;span style=&quot;font-size: small;&quot;&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;U&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;SE&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;NombreBaseDatos&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: small;&quot;&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
En el siguiente código vamos a encontrar la manera de realizar la ejecución.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Sql Server 2000, 2005&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style=&quot;font-size: small;&quot;&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;bgcode&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;&quot;&gt;
&lt;span style=&quot;font-size: small;&quot;&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;IF&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;EXISTS&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;(&lt;/span&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;SELECT&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;*&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;FROM&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: green; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;sysobjects&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;WHERE&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; id &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;=&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: magenta; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;OBJECT_ID&lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;(&lt;/span&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;N&#39;[dbo].[NombreObjeto]&#39;&lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;)&lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;)&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: small;&quot;&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 13px;&quot;&gt;BEGIN&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 13px;&quot;&gt;&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;&lt;/span&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;select&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&#39;El objeto existe&#39;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 13px;&quot;&gt;END&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 13px;&quot;&gt;&lt;/span&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;IF&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: magenta; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;OBJECT_ID&lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;(&lt;/span&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&#39;dbo.NombreObjeto&#39;&lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;)&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;IS&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;NOT&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;NULL&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 13px;&quot;&gt;BEGIN&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 13px;&quot;&gt;&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;&lt;/span&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;select&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&#39;El objeto existe&#39;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 13px; line-height: 14px;&quot;&gt;END&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;span style=&quot;font-size: small;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;br /&gt;
&lt;b&gt;Sql Server 2005&lt;/b&gt;&lt;br /&gt;
&lt;span style=&quot;font-size: small;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;bgcode&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;&quot;&gt;
&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;IF&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;EXISTS&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;(&lt;/span&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;SELECT&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;*&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;FROM&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: green; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;sys.objects&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;WHERE&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: magenta; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;object_id&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;=&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: magenta; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;OBJECT_ID&lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;(&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;N&lt;/span&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&#39;[dbo].[NombreObjeto]&#39;&lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;)&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;AND&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;type&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;in&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;(&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;N&lt;/span&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&#39;P&#39;&lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;,&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; N&lt;/span&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&#39;PC&#39;&lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;))&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 13px;&quot;&gt;BEGIN&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 13px;&quot;&gt;&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;&lt;/span&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;select&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&#39;El objeto existe&#39;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 13px;&quot;&gt;END&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 13px;&quot;&gt;&lt;/span&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;IF&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: magenta; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;OBJECT_ID&lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;(&lt;/span&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&#39;dbo.NombreObjeto&#39;&lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;)&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;IS&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;NOT&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;NULL&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: grey; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 13px;&quot;&gt;BEGIN&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 13px;&quot;&gt;&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;select&lt;/span&gt;&lt;span style=&quot;color: maroon; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&#39;El objeto existe&#39;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 10pt;&quot;&gt;&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 13px; line-height: 14px;&quot;&gt;END&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;span style=&quot;color: blue; font-family: &#39;Courier New&#39;; font-size: 10pt; line-height: 115%;&quot;&gt;Nota:&amp;nbsp;&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: red; font-family: &#39;Courier New&#39;; font-size: 13px;&quot;&gt;NombreObjeto &lt;/span&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Courier New&#39;;&quot;&gt;Es el &lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Courier New&#39;;&quot;&gt;nombre &lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Courier New&#39;;&quot;&gt;de la&amp;nbsp;&lt;/span&gt;Tabla, Procedimiento Almacenado o Vista que estamos validando si existe en la base de datos de Sql Server&amp;nbsp; (Table, Stored Procedure or View)&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
&lt;br /&gt;
Espero que le haya servido.&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://progamaciongratis.blogspot.com/feeds/4993710713824491531/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://progamaciongratis.blogspot.com/2011/09/saber-si-una-tabla-procedimiento.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/4993710713824491531'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/4993710713824491531'/><link rel='alternate' type='text/html' href='http://progamaciongratis.blogspot.com/2011/09/saber-si-una-tabla-procedimiento.html' title='Saber si una Tabla, Procedimiento Almacenado o Vista Existe en Sql Server'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3026901918966367092.post-8033505808289912524</id><published>2011-06-17T16:54:00.000-05:00</published><updated>2011-10-07T08:51:00.143-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2000"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2005"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2008"/><title type='text'>Obtener nombre de la base de datos Actual en sql Server 2000, 2005, 2008</title><content type='html'>Con la siguiente instrucción &lt;span style=&quot;color: blue;&quot;&gt;DB_NAME &lt;/span&gt;&lt;b style=&quot;color: blue;&quot;&gt;(&lt;/b&gt;&lt;b style=&quot;color: blue;&quot;&gt;) &lt;/b&gt;podemos ver el nombre de la base de datos actual. Sintaxis de uso &lt;span style=&quot;color: blue;&quot;&gt;DB_NAME &lt;/span&gt;&lt;b style=&quot;color: blue;&quot;&gt;(database_id&lt;/b&gt;&lt;b style=&quot;color: blue;&quot;&gt;).&lt;/b&gt;&lt;br /&gt;
&lt;b style=&quot;color: blue;&quot;&gt;&amp;nbsp; &lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;b&gt;Ejemplo: &lt;/b&gt;Supongamos que para este ejemplo estamos ubicado en una base de datos que se llama&lt;b&gt;&amp;nbsp;&lt;/b&gt;&lt;/span&gt;&lt;/span&gt;&lt;b&gt;Mi_Base_Datos&lt;/b&gt;&lt;br /&gt;
&lt;b style=&quot;color: blue;&quot;&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
&lt;div class=&quot;bgcode&quot;&gt;
&lt;b style=&quot;color: blue;&quot;&gt;SELECT &lt;span style=&quot;color: magenta;&quot;&gt;DB_NAME()&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&lt;span style=&quot;color: magenta;&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;Si la base de datos existe el regultado seria&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;bgcode&quot;&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&lt;span style=&quot;color: magenta;&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;-------------&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: blue;&quot;&gt;&lt;span style=&quot;color: magenta;&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;--------&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: blue;&quot;&gt;&lt;span style=&quot;color: magenta;&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;b style=&quot;color: blue;&quot;&gt;&lt;span style=&quot;color: magenta;&quot;&gt;&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;b style=&quot;color: blue;&quot;&gt;&amp;nbsp;&lt;/b&gt;&lt;span style=&quot;color: blue;&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;Mi_Base_Datos&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;/div&gt;
&lt;br /&gt;
&lt;b style=&quot;color: blue;&quot;&gt;&amp;nbsp;&lt;/b&gt;&lt;span style=&quot;color: blue;&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;Otra manera de usarlo es indicando el database_id.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;b&gt;Ejemplo: &lt;/b&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;bgcode&quot;&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;b style=&quot;color: blue;&quot;&gt;SELECT &lt;span style=&quot;color: magenta;&quot;&gt;DB_NAME(&lt;/span&gt;&lt;/b&gt;&lt;b style=&quot;color: black;&quot;&gt;1&lt;/b&gt;&lt;b style=&quot;color: blue;&quot;&gt;&lt;span style=&quot;color: magenta;&quot;&gt;)&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;-------------------&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;master&lt;/span&gt;&lt;/span&gt;&lt;b style=&quot;color: blue;&quot;&gt;&lt;span style=&quot;color: magenta;&quot;&gt;&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;b style=&quot;color: blue;&quot;&gt;&lt;span style=&quot;color: magenta;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;/div&gt;
&lt;b style=&quot;color: blue;&quot;&gt;&lt;span style=&quot;color: magenta;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: blue;&quot;&gt;&lt;span style=&quot;color: magenta;&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;La manera de obtener el database_id es realizando una consulta de la siguiente manera en la tabla &lt;b style=&quot;color: #38761d;&quot;&gt;sysdatabases&lt;/b&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;b style=&quot;color: blue;&quot;&gt;&lt;span style=&quot;color: magenta;&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;span style=&quot;color: #38761d;&quot;&gt; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;b style=&quot;color: blue;&quot;&gt;&lt;span style=&quot;color: magenta;&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;span style=&quot;background-color: black;&quot;&gt;&lt;span style=&quot;background-color: white;&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
&lt;div class=&quot;bgcode&quot;&gt;
&lt;span style=&quot;color: blue;&quot;&gt;USE &lt;/span&gt;master&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;SELECT &lt;/span&gt;dbid, &lt;span style=&quot;color: magenta;&quot;&gt;DB_NAME&lt;/span&gt;(dbid) &lt;span style=&quot;color: blue;&quot;&gt;AS &lt;/span&gt;&lt;span style=&quot;color: magenta;&quot;&gt;DB_NAME&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;FROM &lt;/span&gt;&lt;span style=&quot;color: #38761d;&quot;&gt;sysdatabases&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;ORDER BY&lt;/span&gt; dbid&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
Arrojando un resultado como el siguiente:&lt;br /&gt;
&lt;br /&gt;
dbid&amp;nbsp;&amp;nbsp; DB_NAME&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;br /&gt;
------ ---------------------&lt;br /&gt;
1&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; master&lt;br /&gt;
2&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; tempdb&lt;br /&gt;
3&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; model&lt;br /&gt;
4&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; msdb&lt;br /&gt;
5&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Mi_Base_Datos&lt;br /&gt;
6&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Mi_Base_Datos1
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://progamaciongratis.blogspot.com/feeds/8033505808289912524/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://progamaciongratis.blogspot.com/2011/06/obtener-nombre-de-la-base-de-datos.html#comment-form' title='1 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/8033505808289912524'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/8033505808289912524'/><link rel='alternate' type='text/html' href='http://progamaciongratis.blogspot.com/2011/06/obtener-nombre-de-la-base-de-datos.html' title='Obtener nombre de la base de datos Actual en sql Server 2000, 2005, 2008'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3026901918966367092.post-132936251137705381</id><published>2011-06-17T10:55:00.000-05:00</published><updated>2011-09-30T08:32:09.861-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server"/><title type='text'>Uso del object_id Sql Server 2000</title><content type='html'>&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: large;&quot;&gt;object_id Sql Server&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: large;&quot;&gt;&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
En Sql Server 2000 Devuelve el número de identificador de un objeto en una base de datos.&lt;br /&gt;
&lt;br /&gt;
Ejemplo: ejecutamos esto en nuestra base de datos&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;bgcode&quot;&gt;
&lt;code&gt;
&lt;span style=&quot;color: blue;&quot;&gt;USE&lt;/span&gt; Nombre_Base_Datos&lt;br /&gt;&lt;span style=&quot;color: blue;&quot;&gt;SELECT&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;color: magenta;&quot;&gt;OBJECT_ID&lt;/span&gt;(N&lt;span style=&quot;color: red;&quot;&gt;&#39;MiTabla&#39;&lt;/span&gt;)&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;/code&gt;&lt;/div&gt;
&lt;br /&gt;
Si la tabla existe en la base de datos arrojaria un resultado como el siguiente&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;bgcode&quot;&gt;
&lt;code&gt;
---------------- &lt;br /&gt;
484281713&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Si la tabla no exite nos arrojaria un&lt;br /&gt;
---------------- &lt;br /&gt;
NULL&lt;br /&gt;
&lt;br /&gt;
&lt;/code&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://progamaciongratis.blogspot.com/feeds/132936251137705381/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://progamaciongratis.blogspot.com/2011/06/uso-del-objectid-sql-server-2000.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/132936251137705381'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/132936251137705381'/><link rel='alternate' type='text/html' href='http://progamaciongratis.blogspot.com/2011/06/uso-del-objectid-sql-server-2000.html' title='Uso del object_id Sql Server 2000'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3026901918966367092.post-854512879340976873</id><published>2010-12-13T12:10:00.000-05:00</published><updated>2011-10-04T09:12:18.357-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Asp.Net"/><title type='text'>GridView y SqlDatasource1 Tanto DataSource como DataSourceID</title><content type='html'>&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: red;&quot;&gt;Tanto DataSource como DataSourceID están definidos en &#39;GridView1&#39;. Quite una definición.&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
La solución para el problema que se esta presentando es la Siguiente:&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;/div&gt;
&lt;div class=&quot;bgcode&quot; style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;b&gt;GridView1.&lt;/b&gt;&lt;b&gt;DataSourceID&lt;/b&gt;&lt;b&gt; = &lt;/b&gt;&lt;b&gt;Nothing&lt;/b&gt;&lt;br /&gt;
&lt;b&gt;&lt;/b&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;GridView1.DataSource = dt &#39;Selección de los datos&lt;br /&gt;
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;GridView1.DataBind()&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Espero les sirva.&lt;/div&gt;
&lt;br /&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://progamaciongratis.blogspot.com/feeds/854512879340976873/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://progamaciongratis.blogspot.com/2010/12/gridview-y-sqldatasource1-tanto.html#comment-form' title='5 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/854512879340976873'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/854512879340976873'/><link rel='alternate' type='text/html' href='http://progamaciongratis.blogspot.com/2010/12/gridview-y-sqldatasource1-tanto.html' title='GridView y SqlDatasource1 Tanto DataSource como DataSourceID'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>5</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3026901918966367092.post-657092747876488132</id><published>2010-10-19T11:03:00.000-05:00</published><updated>2011-10-04T09:11:03.517-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SQL"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server"/><title type='text'>Como Actualizar un campo  text, ntext o image</title><content type='html'>&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: x-large;&quot;&gt;Como Actualizar un campo &amp;nbsp;text, ntext o image&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: x-large;&quot;&gt;&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Acá explicare con un ejemplo como actualizar un campo de tipo text, ntext o image en &lt;a href=&quot;http://es.wikipedia.org/wiki/Microsoft_SQL_Server&quot;&gt;Sql Server&lt;/a&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;b&gt;Ejemplo:&amp;nbsp;&lt;/b&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;bgcode&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue;&quot;&gt;DECLARE &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;/span&gt;@&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: black;&quot;&gt;varVariable&amp;nbsp;&lt;/span&gt;VARBINARY&lt;/span&gt;(16) &lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue;&quot;&gt;SELECT &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;/span&gt;@varVariable = &lt;span class=&quot;Apple-style-span&quot; style=&quot;color: magenta;&quot;&gt;TEXTPTR&lt;/span&gt;(campo_text )&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue;&quot;&gt;FROM &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;/span&gt;Nombre_Tabla_Actualizar&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue;&quot;&gt;WHERE &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;/span&gt;Campo_Condición = Alguna Condición&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue;&quot;&gt;UPDATETEXT &amp;nbsp;&lt;/span&gt;Nombre_Tabla_Actualizar.campo_text&amp;nbsp;@&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-weight: normal;&quot;&gt;varVariable&amp;nbsp;&lt;/span&gt;0 0&lt;/b&gt; &#39;Texto que se va agregar&#39;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Un poco sobre la sentencia:&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;/div&gt;
&lt;ul&gt;
&lt;li&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue;&quot;&gt;&lt;b&gt;&lt;a href=&quot;http://msdn.microsoft.com/es-es/library/ms189466.aspx&quot;&gt;UPDATETEXT&lt;/a&gt;&lt;/b&gt; &amp;nbsp;&lt;/span&gt;Actualiza un campo text, ntext o image existente; Se usa si se quiere remplazar una parte del texto.&lt;br /&gt;
&lt;/li&gt;
&lt;li&gt;&lt;b&gt;Nombre_Tabla_Actualizar.campo_text&lt;/b&gt;&amp;nbsp;nombre de la tabla y nombre del &amp;nbsp;campo que estamos actualizando.&lt;br /&gt;
&lt;/li&gt;
&lt;li&gt;&lt;b&gt;@&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-weight: normal;&quot;&gt;&lt;b&gt;varVariable&lt;/b&gt;&amp;nbsp;variable que contiene el texto que se va actualizar&lt;br /&gt;
&lt;/span&gt;&lt;/b&gt;&lt;/li&gt;
&lt;li&gt;&lt;b&gt;0 &lt;/b&gt;Este 0 inicial nos indica en que&amp;nbsp;posición&amp;nbsp;se va a iniciar a insertar el texto. Ejemplo: si tenemos &quot;&lt;b&gt;Hola&lt;/b&gt;&quot; y el valor del 0 se cambia por &lt;b&gt;5&lt;/b&gt; y queremos insertar &quot;&lt;b&gt;Mundo&quot;&amp;nbsp;&lt;/b&gt;el&amp;nbsp;haría&amp;nbsp;la inserción de la siguiente manera &quot;&lt;b&gt;Hola Mundo&lt;/b&gt;&quot; &lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue;&quot;&gt;UPDATETEXT &amp;nbsp;&lt;/span&gt;Nombre_Tabla_Actualizar.campo_text&amp;nbsp;@&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-weight: normal;&quot;&gt;varVariable&amp;nbsp;&lt;/span&gt;5 0&lt;/b&gt;&amp;nbsp;&#39;Texto que se va agregar&#39;&lt;br /&gt;
&lt;/li&gt;
&lt;li&gt;&lt;b&gt;0&lt;/b&gt;&amp;nbsp;Este&amp;nbsp;segundo&amp;nbsp;0 en la instrucción indica cuantos caracteres se van a borrar después de la inserción del texto. Ejemplo Tengo en el campo text el Texto &lt;b&gt;&quot;Hola Prueba&quot;&lt;/b&gt; y voy a insertar &quot;&lt;b&gt;Mundo &quot;&amp;nbsp;&lt;/b&gt;en la posición 5 Quedando &lt;b&gt;&quot;Hola Mundo Prueba&quot;&lt;/b&gt; pero en el quiero borrar el texto que le sigue en este caso es &lt;b&gt;Prueba &lt;/b&gt;entonces en vez del cero pongo &lt;b&gt;6 &lt;/b&gt;Quedando el texto&amp;nbsp;&lt;b&gt;Hola Mundo&lt;/b&gt;&quot;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue;&quot;&gt;UPDATETEXT &amp;nbsp;&lt;/span&gt;Nombre_Tabla_Actualizar.campo_text&amp;nbsp;@&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-weight: normal;&quot;&gt;varVariable&amp;nbsp;&lt;/span&gt;5 6&lt;/b&gt;&amp;nbsp;&#39;Texto que se va agregar&#39;&lt;br /&gt;
&lt;/li&gt;
&lt;li&gt;&lt;b&gt;&#39;Texto que se va agregar&#39; &lt;/b&gt;Texto que se va adicionar al que ya existe en nuestro campo&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Cualquier duda o Sugerencia no dude en comentar&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://progamaciongratis.blogspot.com/feeds/657092747876488132/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://progamaciongratis.blogspot.com/2010/10/como-actualizar-un-campo-text-ntext-o.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/657092747876488132'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/657092747876488132'/><link rel='alternate' type='text/html' href='http://progamaciongratis.blogspot.com/2010/10/como-actualizar-un-campo-text-ntext-o.html' title='Como Actualizar un campo  text, ntext o image'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3026901918966367092.post-654608834697852133</id><published>2010-05-28T14:21:00.000-05:00</published><updated>2012-08-01T12:43:08.689-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="SQL"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2000"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2005"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server 2008"/><title type='text'>Como encriptar un Procedimiento almacenado (Stored Procedure) en Sql Server 2000/2005/2008</title><content type='html'>Acá dejo un ejemplo para Encriptar nuestros procedimientos almacenados (&lt;a href=&quot;http://es.wikipedia.org/wiki/Procedimiento_almacenado&quot;&gt;stored procedure&lt;/a&gt;) en Sql Server 2000/2005/2008&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot;&gt;
Con esta sentencia&amp;nbsp;podemos Encriptar o cifrar nuestros procedimientos
almacenados en SQL Server&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;bgcode&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue;&quot;&gt;Create Procedure &lt;/span&gt;dbo.usp_a_Encriptar&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue;&quot;&gt;WITH ENCRYPTION&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue;&quot;&gt;AS&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue;&quot;&gt;BEGIN&lt;/span&gt;&lt;br /&gt;
&amp;nbsp;&amp;nbsp; &amp;nbsp;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue;&quot;&gt;Select &lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: red;&quot;&gt;&#39;Este SP ya esta Encriptado&#39;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: blue;&quot;&gt;END&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
Tener en cuenta: &amp;nbsp;Realizar copia del SP antes de compilarlo por que cuando se compile los usuario que no tengan privilegios para entrar a las tablas del sistema no&amp;nbsp;podrán&amp;nbsp;recuperar.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Espero les haya sido de Ayuda.</content><link rel='replies' type='application/atom+xml' href='http://progamaciongratis.blogspot.com/feeds/654608834697852133/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://progamaciongratis.blogspot.com/2010/05/como-encriptar-un-procedimiento.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/654608834697852133'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/654608834697852133'/><link rel='alternate' type='text/html' href='http://progamaciongratis.blogspot.com/2010/05/como-encriptar-un-procedimiento.html' title='Como encriptar un Procedimiento almacenado (Stored Procedure) en Sql Server 2000/2005/2008'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3026901918966367092.post-3794627392143567999</id><published>2009-11-09T18:39:00.000-05:00</published><updated>2009-11-25T00:28:09.490-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Asp.Net"/><category scheme="http://www.blogger.com/atom/ns#" term="C# Net"/><category scheme="http://www.blogger.com/atom/ns#" term="Solución Compatibilidad IE8"/><category scheme="http://www.blogger.com/atom/ns#" term="VB Net"/><category scheme="http://www.blogger.com/atom/ns#" term="VB.NET"/><category scheme="http://www.blogger.com/atom/ns#" term="VB.NET 2005"/><category scheme="http://www.blogger.com/atom/ns#" term="VS 2005"/><title type='text'>Solucion de Compatibilidad Asp.net (C#, VB) Internet explorer 8</title><content type='html'>&lt;div style=&quot;text-align: center;&quot;&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Solución de Compatiblidad en Asp.Net (C#, VB) para internet explorer 8&lt;/span&gt; &lt;span style=&quot;font-weight: bold;&quot;&gt;(IE8)&lt;/span&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;text-align: center;&quot;&gt;&lt;br /&gt;
&lt;div align=&quot;justify&quot;&gt;En el siguiente texto vamos a ver como solucionar alguna incompatiblidad de nuestros sitios web creados en &lt;a href=&quot;http://asp.net/&quot;&gt;asp.net&lt;/a&gt;&amp;nbsp;que a la hora de ejecutarlos en &lt;a href=&quot;http://www.microsoft.com/latam/windows/internet-explorer/&quot;&gt;intener explorer 8 &lt;/a&gt;no se visualiza como queremos.&lt;br /&gt;
&lt;/div&gt;&lt;br /&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;Buenas, unos días antes agregue sobre como solucionar el menú en interenet exploer 8 (IE8) de nuestra programación de VS 2005 (&lt;a href=&quot;http://www.asp.net/&quot;&gt;Asp.Net&lt;/a&gt;), hoy pondré la solución en general para nuestras aplicaciones hechas VB, C# que acabara con el problema de nuestras páginas por problemas de compatibilidad.&lt;br /&gt;
&lt;br /&gt;
El problema radica en que por ciertas razones el explorador de &lt;a href=&quot;http://www.microsoft.com/latam/windows/internet-explorer/&quot;&gt;IE8&lt;/a&gt; trae por defectos unos valores los cuales el no puede interpretar de nuestras aplicaciones. lo que debemos hacer es agregar el siguiente meta tag &lt;span style=&quot;font-weight: bold;&quot;&gt;&amp;lt;meta equiv=&quot;X-UA-COMPATIBLE&quot; content=&quot;IE=EmulateIE7&quot;&amp;gt;&lt;/span&gt; a nuestras aplicaiones como se muestra en la siguiente figura.&lt;br /&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMWUPWVpGRLmfqqXqNmaqqre1e0sF-KrmI944q_-TaQ5RiaCD1MmHRas5_uLJd1miN470eEwhXqp23MxjCfmaFFKeVf7SQt8S-2YyhhWsD0OwGrd211zs6S2jBTazwMRIqTOPWmzHu8YJp/s1600-h/Compatiblidad+IE8.PNG&quot; onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; id=&quot;BLOGGER_PHOTO_ID_5402256802796495570&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMWUPWVpGRLmfqqXqNmaqqre1e0sF-KrmI944q_-TaQ5RiaCD1MmHRas5_uLJd1miN470eEwhXqp23MxjCfmaFFKeVf7SQt8S-2YyhhWsD0OwGrd211zs6S2jBTazwMRIqTOPWmzHu8YJp/s400/Compatiblidad+IE8.PNG&quot; style=&quot;cursor: pointer; display: block; height: 187px; margin: 0px auto 10px; text-align: center; width: 592px;&quot; /&gt;&lt;/a&gt;&lt;br /&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;Solo espero que esto les pueda servir de ayuda y asi seguir motivandome ne nuevas cosas....&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;text-align: justify;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://progamaciongratis.blogspot.com/feeds/3794627392143567999/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://progamaciongratis.blogspot.com/2009/11/solucion-de-compatibilidad-aspnet.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/3794627392143567999'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/3794627392143567999'/><link rel='alternate' type='text/html' href='http://progamaciongratis.blogspot.com/2009/11/solucion-de-compatibilidad-aspnet.html' title='Solucion de Compatibilidad Asp.net (C#, VB) Internet explorer 8'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMWUPWVpGRLmfqqXqNmaqqre1e0sF-KrmI944q_-TaQ5RiaCD1MmHRas5_uLJd1miN470eEwhXqp23MxjCfmaFFKeVf7SQt8S-2YyhhWsD0OwGrd211zs6S2jBTazwMRIqTOPWmzHu8YJp/s72-c/Compatiblidad+IE8.PNG" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-3026901918966367092.post-8296026622926748596</id><published>2009-10-26T17:12:00.000-05:00</published><updated>2009-11-18T09:25:16.877-05:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Asp.Net"/><category scheme="http://www.blogger.com/atom/ns#" term="C# Net"/><category scheme="http://www.blogger.com/atom/ns#" term="IE8"/><category scheme="http://www.blogger.com/atom/ns#" term="Menu Asp.Net"/><category scheme="http://www.blogger.com/atom/ns#" term="Mi menú ASP.NET no se ve en Internet Explorer 8"/><category scheme="http://www.blogger.com/atom/ns#" term="Solución Menu internet explorer 8"/><category scheme="http://www.blogger.com/atom/ns#" term="VB Net"/><title type='text'>Solución - Mi menú ASP.NET no se ve en Internet Explorer 8</title><content type='html'>&lt;div style=&quot;text-align: left;&quot;&gt;En el siguiente texto vamos a ver como solucionar la compatiblidad de nuestro menú creado en &lt;a href=&quot;http://asp.net/&quot;&gt;asp.net&lt;/a&gt;&amp;nbsp;para que se pueda visualizar sin problemas en la versión de &lt;a href=&quot;http://www.microsoft.com/latam/windows/internet-explorer/&quot;&gt;Internet Explorer 8&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Para las personas que tienen problemas con el menú de &lt;a href=&quot;http://www.asp.net/&quot;&gt;&lt;b&gt;A&lt;/b&gt;&lt;/a&gt;&lt;a href=&quot;http://www.asp.net/&quot;&gt;SP.NET&lt;/a&gt;&lt;b&gt;&lt;/b&gt; en &lt;a href=&quot;http://www.microsoft.com/latam/windows/internet-explorer/&quot;&gt;&lt;b&gt;Internet Explorer 8&lt;/b&gt;&lt;/a&gt;&lt;b&gt;&lt;/b&gt;(&lt;b&gt;IE8&lt;/b&gt;) por vista de compatibilidad deben de seguir los siguientes pasos para la solución&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;&lt;div style=&quot;text-align: center;&quot;&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; id=&quot;BLOGGER_PHOTO_ID_5397042819087554658&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEqsvFiSxZuZe4dSjwUVBXcKCix26xtfZmwp7d7txwfaytqznXaGdVCPg2Y1UXRjcPiOZO9ryX9MMZyXHC18uP6pLTILC5FWMlQ0_hYz5yxeVaHd1h3A09uLN3CwU2aGWokti1KEAvxvox/s320/MenuMalo.PNG&quot; style=&quot;cursor: hand; display: block; height: 203px; margin: 0px auto 10px; text-align: center; width: 222px;&quot; /&gt;&lt;br /&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;b&gt;Solución:&lt;/b&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;text-align: center;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;Creamos el siguiente clase &lt;a href=&quot;http://www.w3.org/Style/CSS/&quot;&gt;&lt;b&gt;CSS&lt;/b&gt;&lt;/a&gt;&lt;b&gt; &lt;/b&gt;en nuestra página de &lt;a href=&quot;http://www.asp.net/&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-weight: bold;&quot;&gt;ASP.NET&lt;/span&gt;&lt;/a&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;b&gt;&lt;br /&gt;
&lt;/b&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;div style=&quot;text-align: center;&quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; id=&quot;BLOGGER_PHOTO_ID_5397044580147310706&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh25uEUfT2jcI5gvy_6BEYv8aVrPgsX7pUfn-21whyphenhyphen4SYyGaTowFtFrp_FEAqQ-VZB9PG8RuHCbspUnAUNiWWoFXVLAJVGuaqprqdfiqVF1kreewlEBZ92whdiNmqOKAibDQAZPWMRDHKT-/s320/ClaseCSS.PNG&quot; style=&quot;cursor: hand; display: block; height: 135px; margin: 0px auto 10px; text-align: center; width: 287px;&quot; /&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;text-align: center;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;El Siguiente paso es ubicar la propiedad &lt;b&gt;DynamicMenuStyle &lt;/b&gt;de nuestro menú y en la propiedad &lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;text-align: center;&quot;&gt;&lt;br /&gt;
&lt;img alt=&quot;&quot; border=&quot;0&quot; id=&quot;BLOGGER_PHOTO_ID_5397044582087492914&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirN4MYtonCY-_0yNeTrPfQyeMVBBRK21c6mB365cQ7_sLA0PdHdF96sAs45ouI6WZa59W_fWR1O0M-Iu_HIz_xxOpVDXpAzdgkB0UYe0fkaDpgRrRt6Vc8p-_ORrMXtYL25pgJT2zmKckR/s320/Propiedad.PNG&quot; style=&quot;cursor: hand; display: block; height: 271px; margin: 0px auto 10px; text-align: center; width: 269px;&quot; /&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;En este momento nuestro menú ya se verá.&lt;br /&gt;
&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; id=&quot;BLOGGER_PHOTO_ID_5397046396726576514&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0mUaDtu5G3hIrz8-iQhkF8Xbf6BcTntLPYr8b9ib48xxT65yreG-i5lFfsY31cnAD1FmiVEJUcIxLB4S-Wf6qdNN4sLWuwVryUuWBwdFau-Uc7XkFLUAUl_9mDI_eA36VuTzilyHBsc9B/s320/MenuBueno.PNG&quot; style=&quot;cursor: hand; display: block; height: 183px; margin: 0px auto 10px; text-align: center; width: 167px;&quot; /&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/div&gt;&lt;br /&gt;
Espero que les haya servido y cualquier cosa no se les olvide comentar, gracias.</content><link rel='replies' type='application/atom+xml' href='http://progamaciongratis.blogspot.com/feeds/8296026622926748596/comments/default' title='Enviar comentarios'/><link rel='replies' type='text/html' href='http://progamaciongratis.blogspot.com/2009/10/mi-menu-aspnet-no-se-ve-en-internet.html#comment-form' title='0 comentarios'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/8296026622926748596'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/3026901918966367092/posts/default/8296026622926748596'/><link rel='alternate' type='text/html' href='http://progamaciongratis.blogspot.com/2009/10/mi-menu-aspnet-no-se-ve-en-internet.html' title='Solución - Mi menú ASP.NET no se ve en Internet Explorer 8'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEqsvFiSxZuZe4dSjwUVBXcKCix26xtfZmwp7d7txwfaytqznXaGdVCPg2Y1UXRjcPiOZO9ryX9MMZyXHC18uP6pLTILC5FWMlQ0_hYz5yxeVaHd1h3A09uLN3CwU2aGWokti1KEAvxvox/s72-c/MenuMalo.PNG" height="72" width="72"/><thr:total>0</thr:total></entry></feed>