Database change tracking software

Does anyone know of software that tracks changes to a database? For
example, it would track anytime an SP or view was recompiled, or if
you added or deleted a column to a database?"Matt Karp" <mattkarp@.hotmail.com> wrote in message
news:f23a0aff.0410140909.772fbb37@.posting.google.c om...
> Does anyone know of software that tracks changes to a database? For
> example, it would track anytime an SP or view was recompiled, or if
> you added or deleted a column to a database?

You could do that with Profiler, or there are are many third-party tools for
MSSQL monitoring.

Simon

Database Authentication Error in FrontPage

Hi,
I am trying to add a Data view to a sharepoint site. When I try to create a
connection to the SQL database I get an Authentication error.
I have tried both the Windows Authentication and a Username. I am a DB
administrator and have full access to the database and its server.
Thanks!Please see the reply in
microsoft.public.sqlserver.connect
-Sue
On Fri, 14 Oct 2005 13:04:04 -0700, "Slim"
<Slim@.discussions.microsoft.com> wrote:

>Hi,
>I am trying to add a Data view to a sharepoint site. When I try to create a
>connection to the SQL database I get an Authentication error.
>I have tried both the Windows Authentication and a Username. I am a DB
>administrator and have full access to the database and its server.
>Thanks!

Database Authentication Error in FP

Hi,
I am trying to add a Data view to a sharepoint site. When I try to create a
connection to the SQL database I get an Authentication error.
I have tried both the Windows Authentication and a Username. I am a DB
administrator and have full access to the database and its server.
Thanks!
It's hard to say without detailed error information. But try
turning on failure audits in SQL Server and check the SQL
Server log to see what account is failing. That should help
you track it down. You also want the entire error message -
there are different types of authentication errors that can
point to different problems.
-Sue
On Fri, 14 Oct 2005 13:04:02 -0700, "Slim"
<Slim@.discussions.microsoft.com> wrote:

>Hi,
>I am trying to add a Data view to a sharepoint site. When I try to create a
>connection to the SQL database I get an Authentication error.
>I have tried both the Windows Authentication and a Username. I am a DB
>administrator and have full access to the database and its server.
>Thanks!

Database Authentication Error in FP

Hi,
I am trying to add a Data view to a sharepoint site. When I try to create a
connection to the SQL database I get an Authentication error.
I have tried both the Windows Authentication and a Username. I am a DB
administrator and have full access to the database and its server.
Thanks!It's hard to say without detailed error information. But try
turning on failure audits in SQL Server and check the SQL
Server log to see what account is failing. That should help
you track it down. You also want the entire error message -
there are different types of authentication errors that can
point to different problems.
-Sue
On Fri, 14 Oct 2005 13:04:02 -0700, "Slim"
<Slim@.discussions.microsoft.com> wrote:

>Hi,
>I am trying to add a Data view to a sharepoint site. When I try to create a
>connection to the SQL database I get an Authentication error.
>I have tried both the Windows Authentication and a Username. I am a DB
>administrator and have full access to the database and its server.
>Thanks!

Database Architecture for keep tera byte of data

Hi

we are keeping five yeare of data which can be gone up to terabyte in size . when we are retreaving the data it will take more time to view the report .please send us the database architectur or way of keeping data to speeded up the reporting.

We have indexed the table.

Thanks

Pubudu

I recommend the Fast Terrabyte Database Architecture (patent applied for but declined) methodology. This architecture is known to be the fastest in the world. I have witnessed retrieval times faster than selecting a single record from a row of 5!! Also this method requires no indexing what-so-ever.

Unfortunately, the secret to this architecture died with it's inventor, C.J. Time. So I now recommend the Database Tuning Advisor. As for architecture, if you could provide a few more details, I'll bet some better advice would be forthcoming.

|||

Hi

I can give u a details about the database.

Thats having 25 tables.It uses for Point of Sales (pos) system.Data is comming from more than 100 branches.Therefore there can be

more than 10000 records for a day per outlet.From those all outlets data is comming to the head office database.So we are taking the

reports using centraldata base management desision making purposes.

Thanks

Pubudu

|||

10,000 records per day per outlet x 100 outlets is 1 million records per day x 220 business days per year x 5 years is ~ a billion records.

My approach would be to roll up into a data warehouse daily for analysis.

Data type change in SQL view

I've created a SQL View in SQL 2000 using a table that has columns
defined as Numeric data type. In the view, I am grouping and summing.
When I link the view via ODBC to Access, all of the data types are
changed to text. If I link the original table which the views are
created from to Access, the data types are correct. So this problem
obviously happens when I change the view to Group. Is there a way
around this? I want the data types to be correct in Access when I
link to the views.

thanks,

jimMR71 (mr71@.yahoo.com) writes:
> I've created a SQL View in SQL 2000 using a table that has columns
> defined as Numeric data type. In the view, I am grouping and summing.
> When I link the view via ODBC to Access, all of the data types are
> changed to text. If I link the original table which the views are
> created from to Access, the data types are correct. So this problem
> obviously happens when I change the view to Group. Is there a way
> around this? I want the data types to be correct in Access when I
> link to the views.

Not that I know anything about the Access part of this, but it
could help if you post the CREATE TABLE statements for your tables
and the CREATE VIEW statement.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp