Si te sale en siguiente mensaje al abrir un proyecto web en Visual Studio 2005:
Español:
No se puede abrir el archivo de proyecto 'archivo.csproj'.
El tipo de proyecto no es compatible con esta instalación.
English:
The project file 'file.csproj' cannot be opened.
The project type is not supported by this installation.
El problema se debe a que el proyecto fué creado con Visual Studio 2005 Service Pack 1, y tú no lo tienes instalado.
lunes, 14 de abril de 2008
Simular DESC TABLE de Oracle en SQL Server
USE MiBaseDeDatos
GO
SELECT T1.NAME AS [Tabla], T2.NAME AS [Campo], T3.NAME AS [Tipo], T3.LENGTH AS [Tamaño]
FROM SYS.OBJECTS AS T1
INNER JOIN SYS.COLUMNS AS T2 ON T1.OBJECT_ID = T2.OBJECT_ID
INNER JOIN SYS.SYSTYPES AS T3 ON T2.USER_TYPE_ID = T3.XUSERTYPE
WHERE T1.TYPE ='U'
ORDER BY T1.NAME
GO
SELECT T1.NAME AS [Tabla], T2.NAME AS [Campo], T3.NAME AS [Tipo], T3.LENGTH AS [Tamaño]
FROM SYS.OBJECTS AS T1
INNER JOIN SYS.COLUMNS AS T2 ON T1.OBJECT_ID = T2.OBJECT_ID
INNER JOIN SYS.SYSTYPES AS T3 ON T2.USER_TYPE_ID = T3.XUSERTYPE
WHERE T1.TYPE ='U'
ORDER BY T1.NAME
viernes, 11 de abril de 2008
Parametro tipo Tabla en SQL Server 2008
USE AdventureWorks;
GO
CREATE TYPE TipoTabla AS TABLE
(Nombre VARCHAR(50), Costo INT);
GO
CREATE PROCEDURE InsertaAreasDeProduccion
@ParametroTabla TipoTabla READONLY
AS
SET NOCOUNT ON
INSERT INTO [AdventureWorks].[Production].[Location]
([Name], [CostRate], [Availability], [ModifiedDate])
SELECT *, 0, GETDATE()
FROM @ParametroTabla;
GO
DECLARE @TablaLocation AS TipoTabla;
INSERT INTO @TablaLocation (Nombre, Costo)
SELECT [Name], 0.00
FROM [AdventureWorks].[Person].[StateProvince];
EXEC InsertaAreasDeProduccion @TablaLocation;
GO
GO
CREATE TYPE TipoTabla AS TABLE
(Nombre VARCHAR(50), Costo INT);
GO
CREATE PROCEDURE InsertaAreasDeProduccion
@ParametroTabla TipoTabla READONLY
AS
SET NOCOUNT ON
INSERT INTO [AdventureWorks].[Production].[Location]
([Name], [CostRate], [Availability], [ModifiedDate])
SELECT *, 0, GETDATE()
FROM @ParametroTabla;
GO
DECLARE @TablaLocation AS TipoTabla;
INSERT INTO @TablaLocation (Nombre, Costo)
SELECT [Name], 0.00
FROM [AdventureWorks].[Person].[StateProvince];
EXEC InsertaAreasDeProduccion @TablaLocation;
GO
jueves, 10 de abril de 2008
Como auditar con seguridad en SQL Server 2008
CREATE AUDIT SERVER PACKAGE MiPaquete
WITH SINK = MyWindowsSecurityLog
STATE = STARTED
ADD AUDIT GROUP SYS_FAILED_LOGIN,
ADD AUDIT GROUP SYS_DATABASE_OBJECT_MANAGEMENT
ON MiBaseDeDatos
ALTER AUDIT SERVER PACKAGE MiPaquete
ADD SINK = LocalFileSystemLogSink
WITH SINK = MyWindowsSecurityLog
STATE = STARTED
ADD AUDIT GROUP SYS_FAILED_LOGIN,
ADD AUDIT GROUP SYS_DATABASE_OBJECT_MANAGEMENT
ON MiBaseDeDatos
ALTER AUDIT SERVER PACKAGE MiPaquete
ADD SINK = LocalFileSystemLogSink
Cursor dinamico en Oracle
declare
TYPE tipoCursor IS REF CURSOR;
cursorDinamico tipoCursor;
tableName varchar(100) := 'ESQUEMA.TABLA';
campo1 varchar(200);
campo2 varchar(200);
begin
open cursorDinamico for
'SELECT campo1, campo2 FROM ' || tableName;
loop
fetch cursorDinamico into campo1, campo2;
exit when cursorDinamico%NOTFOUND;
dbms_output.put_line(campo1);
end loop;
close cursorDinamico;
end;
TYPE tipoCursor IS REF CURSOR;
cursorDinamico tipoCursor;
tableName varchar(100) := 'ESQUEMA.TABLA';
campo1 varchar(200);
campo2 varchar(200);
begin
open cursorDinamico for
'SELECT campo1, campo2 FROM ' || tableName;
loop
fetch cursorDinamico into campo1, campo2;
exit when cursorDinamico%NOTFOUND;
dbms_output.put_line(campo1);
end loop;
close cursorDinamico;
end;
miércoles, 9 de abril de 2008
Limpiar el LOG de transacciones de tus BD
DECLARE @sql nvarchar(4000)
SET @sql = '
IF ''?'' NOT IN (''tempdb'',''master'',''model'',''msdb'')
BEGIN
PRINT ''SHRINK LOG FILES FOR ?''
USE [?]
DECLARE @tsql nvarchar(4000) SET @tsql = ''''
DECLARE @LogFileId int
DECLARE LogFiles CURSOR FOR
SELECT fileid FROM sysfiles WHERE status & 0x40 = 0x40
OPEN LogFiles
FETCH next FROM LogFiles INTO @LogFileId
WHILE @@fetch_status = 0
BEGIN
SET @tsql = @tsql + ''DBCC SHRINKFILE('' + cast(@LogFileId AS varchar(5)) + '', 1)'' + CHAR(13) + CHAR(10)
FETCH next FROM LogFiles INTO @LogFileId
END
CLOSE LogFiles
DEALLOCATE LogFiles
SET @tsql = @tsql + ''BACKUP LOG [?] WITH TRUNCATE_ONLY'' + CHAR(13) + CHAR(10) + @tsql
EXEC(@tsql)
END'
EXEC sp_msforeachdb @sql
SET @sql = '
IF ''?'' NOT IN (''tempdb'',''master'',''model'',''msdb'')
BEGIN
PRINT ''SHRINK LOG FILES FOR ?''
USE [?]
DECLARE @tsql nvarchar(4000) SET @tsql = ''''
DECLARE @LogFileId int
DECLARE LogFiles CURSOR FOR
SELECT fileid FROM sysfiles WHERE status & 0x40 = 0x40
OPEN LogFiles
FETCH next FROM LogFiles INTO @LogFileId
WHILE @@fetch_status = 0
BEGIN
SET @tsql = @tsql + ''DBCC SHRINKFILE('' + cast(@LogFileId AS varchar(5)) + '', 1)'' + CHAR(13) + CHAR(10)
FETCH next FROM LogFiles INTO @LogFileId
END
CLOSE LogFiles
DEALLOCATE LogFiles
SET @tsql = @tsql + ''BACKUP LOG [?] WITH TRUNCATE_ONLY'' + CHAR(13) + CHAR(10) + @tsql
EXEC(@tsql)
END'
EXEC sp_msforeachdb @sql
lunes, 7 de abril de 2008
Controlar tu PDA desde la PC
Para hacerlo debes instalar: ActiveSync Remote Display
Si tu PDA tiene Windows Mobile 6, entonces debes ir a C:\Program Files\Windows Mobile Developer Power Toys\ActiveSync_Remote_Display\devices\wce400\armv4t
y copias a la carpeta \Windows de tu dispositivo los archivos:
cerdisp2.exe
KillProc.exe
Te marcara "The OS or CPU of this device is unknown to this application", dale en OK y en tu PDA le dices que si ejecute la aplicación y listo ya puedes controlar remotamente tu PDA =)
Otra opción es descargar este programa: My Mobiler
Si tu PDA tiene Windows Mobile 6, entonces debes ir a C:\Program Files\Windows Mobile Developer Power Toys\ActiveSync_Remote_Display\devices\wce400\armv4t
y copias a la carpeta \Windows de tu dispositivo los archivos:
cerdisp2.exe
KillProc.exe
Te marcara "The OS or CPU of this device is unknown to this application", dale en OK y en tu PDA le dices que si ejecute la aplicación y listo ya puedes controlar remotamente tu PDA =)
Otra opción es descargar este programa: My Mobiler
Suscribirse a:
Entradas (Atom)