microsoft.public.br.sqlserver
  Home FAQ Contact Sign in
microsoft.public.br.sqlserver only
 
Advanced search
January 2008
motuwethfrsasuw
 123456 1
78910111213 2
14151617181920 3
21222324252627 4
28293031    5
2008
 Jan   Feb   Mar   Apr 
 May   Jun   Jul   Aug 
 Sep   Oct   Nov   Dec 
2008 2007 2006  
total
microsoft.public.br.sqlserver Profile…
RELATED GROUPS

POPULAR GROUPS

more...

 Up
  Arquitetura de centralização de dados         


Author: Fabio Hemylio
Date: Jan 31, 2008 09:02

Oi Pessoal,

Eu tenho em mãos o seguinte cenário: um escritório central com um
datacenter e cerca de 200 filiais espalhadas. Cada uma das filiais tem um SQL
Server que abriga as bases de dados de 9 sistemas....
Show full article (1.51Kb)
2 Comments
  nome da tabela no insert ou update         


Author: marcelo
Date: Jan 22, 2008 17:36

Boa tarde Galera,

Agradeço desde já a contribuição de todos.

Estou fazendo um processo de auditoria de banco de dados, para gravar nome
do usuário, data, hora, qual campo alterado, qual tabela, etc.
Existe alguma forma fácil de obter o nome dos campos que foram alterados, os
valores antigos e os novos valores?
1 Comment
  Backup SQL EXPRESS 20005         


Author: Visual Sistemas
Date: Jan 21, 2008 12:24

Existe alguma solucao similar o AGENT SERVER do sql 2005, necessito de
backup automatico no sql express, como nao existe o agent, estou usnado o
agendador de tarefas
do windows, executando o .bat para automatizar o processo..
alquem ja desenvolveu ou tem solucao melhor?

obrigado

--
Ericson Galassi
---------------
Visual Sistemas
(67) 84125966
no comments
  Linked Server         


Author: Dúvida
Date: Jan 8, 2008 11:31

Senhores,

Estou tentando fazer um Linked Server do Sql2005 para o Oracle e estou
recebendo o seguinte erro:

The OLE Database provider "SQL Server" for linked server "(null)" reported
an
error. One or more arguments were reported invalid by the provider.
Cannot obtain the schema rowset "DBSCHEMA_CATALOGS" for OLE Database
provider
"SQL
Server" for linked server "(null)". The provider supports the interface,
but
returns a failure code when it is used. (Microsoft SQL Server, Error:
7399)

Algu
no comments
  Camouflage de dados em Qualquer tipo de Banco de Dados         


Author: Adriana
Date: Jan 7, 2008 05:57

Somos representantes de um software Canadense que faz mascaramento em tabelas de banco de dados. Maiores informações favor entrar em contato.
Obrigada
The Data Privacy Solution
Camouflage is the only enterprise-level software built from the ground-up to mask or de-identify copies of production data for use in non-production databases. The software enforces 'need to know access' to personally identifiable information, ensuring that only those individuals who absolutely require production data have the associated privileges. For those individuals who work with non-production data, Camouflage provides realistic but de-identified information that maintains the properties and behavior of the underlying production data.

The software is both highly configurable and flexible, enabling it to meet the data masking requirements of any organization. Camouflage was built for platform and database independence, supporting a wide range of operating systems and database types. The masking software comes delivered with a variety of prepackaged masking transformers, allowing clients to mask their data in countless ways, while also maintaining relational integrity at the database, application, and integrated database levels. Combined with the software's robust scripting capability, Camouflage is capable of transforming data in many unique ways, thus protecting sensitive information the best way possible.

Common Uses
While countless barriers and security measures protect production databases, many unprotected copies of this information exist across IT networks, leaving information exposed and vulnerable to data theft. Camouflage is used to mask these copies of production information and to create realistic and fully functional data for use in a variety of non-production environments. The usability of Camouflage is quite comprehensive, the most common uses for the software including:

a.. Software and Application Development
b.. Implementation Testing
c.. Quality Assurance
d.. Data Mining
e.. Training
f.. Outsourcing
g.. Offshoring

While Camouflage is commonly used in the above environments, the software is ideal for any situation in which clients need realistic and fully functional data to undertake their job, but do not require access to real production data.

Features
Camouflage's unique features combine to deliver a comprehensive and enterprise-wide data masking solution to protect organizations from the inside out against information theft.

Platform and Database Independence
As an enterprise-wide solution, Camouflage is built on the open standards of Java, JDBC, and XML. This allows Camouflage to be deployed in a wide variety of environments and to connect to a wide range of database types. The software can connect to any database where Java Runtime Environment (JRE) 1.5.0 and JDBC are supported. As an enterprise-wide solution, Camouflage also has support for flat files. The software exports data in flat file structure, intelligently masks the information, and then reassembles the data in its original flat file format.
Show full article (6.51Kb)
no comments
  O que é DTS no SQL Server?         


Author: Roger
Date: Jan 3, 2008 04:59

Estou com essa dúvida.

Obrigado.
1 Comment
  Novo no Grupo!         


Author: Roger
Date: Jan 3, 2008 04:53

Bom dia, meu nome é Roger, sou programador Delphi utilizando banco de dados
DBISam a trê anos.
Trabalho para a insdústria, estamos migrando para SQL Server 2005, como
ainda não estou fazendo curso, vou ter que fazer diversas perguntas a vocês
pois não conheço muito o SQL Server.
no comments