No Logging

Gurus,
Is there a way to disable database logging while dropping
tables in SQL Server 6.5? In fact, is there a way to
disable logging completely? I realize this is no way to
run a production database, but sometimes extreme problems
call for extreme actions!
Will greatly appreciate any suggestions!
Thanks,
ChetChet
Turn the database option truncate log on checkpoint to on.
(In EM double click on the database you want and you will
find it under the options tab, just tick it)
Regards
John|||No you cannot completely turn off logging. You can set Trunc. log on Chkpt
and SELECT Into/Bulk Copy to true. What are your reasons for wanting to do
this "extreme problems"
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Chet" <chet.hodgins@.verizon.net> wrote in message
news:009801c351f3$71fcedd0$a101280a@.phx.gbl...
> Gurus,
> Is there a way to disable database logging while dropping
> tables in SQL Server 6.5? In fact, is there a way to
> disable logging completely? I realize this is no way to
> run a production database, but sometimes extreme problems
> call for extreme actions!
> Will greatly appreciate any suggestions!
> Thanks,
> Chet|||Thanks for the replies! This is a SAP development
database. We have 4 SAP tables that are have 2541, 2504
and 2543 errors. The data in these 4 tables are not
important. I have copied the tables to new customer
defined tables in SAP. Now want to drop the problem tables
and re-create them. Keep running out of log space (4GB)
before i can get to my first checkoint. Suggestions are
always appreciated!
Thanks,
Chet
>--Original Message--
>No you cannot completely turn off logging. You can set
Trunc. log on Chkpt
>and SELECT Into/Bulk Copy to true. What are your reasons
for wanting to do
>this "extreme problems"
>--
>--
>Allan Mitchell (Microsoft SQL Server MVP)
>MCSE,MCDBA
>www.SQLDTS.com
>I support PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>
>"Chet" <chet.hodgins@.verizon.net> wrote in message
>news:009801c351f3$71fcedd0$a101280a@.phx.gbl...
>> Gurus,
>> Is there a way to disable database logging while
dropping
>> tables in SQL Server 6.5? In fact, is there a way to
>> disable logging completely? I realize this is no way to
>> run a production database, but sometimes extreme
problems
>> call for extreme actions!
>> Will greatly appreciate any suggestions!
>> Thanks,
>> Chet
>
>.
>

No dbo in the database!

Hi All
I have a database where there is no dbo user. There seems
to be some login mismatch that I can't fix up.
The master shows sa (in fact sa is the dbo in another db
on the same server) but sa, dbo does not appear in one of
the other databases and I can't add it.
I've checked out KB 305711 but it doesn't help.
Thanks
JIn Query Analyzer,
USE the database and issue this command:
EXEC sp_changedbowner 'sa'
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"J" <anonymous@.discussions.microsoft.com> wrote in message
news:000501c3af13$941724d0$a001280a@.phx.gbl...
> Hi All
> I have a database where there is no dbo user. There seems
> to be some login mismatch that I can't fix up.
> The master shows sa (in fact sa is the dbo in another db
> on the same server) but sa, dbo does not appear in one of
> the other databases and I can't add it.
> I've checked out KB 305711 but it doesn't help.
> Thanks
> J

Newby Stupid question

Okay, so this is probably me just being stupid and not understanding.

I have a dimensional database that I populated using SSIS. One fact table has about 78,000 records. When I build a cube on top of the database, I get no results for the measures on the fact table.

What would be a typical reason for something like this occurring?

Thanks
JimProbably you didn't design the Dimension Usage.