Forum Replies Created
Viewing 15 posts - 6,376 through 6,390 (of 7,489 total)
-
RE: Large LDF file of an inactive DB
"Change your recovery option to Simple this will prevent the log from capturing all the data and filling up" ....
Nop.
It will depend on your...
-
RE: Large LDF file of an inactive DB
Log files will only shrink up to the last active log chunk.
so it may be needed to run the shrink-file x-times.
-- Shrink_TrxLog.SQL
--INF:...
-
RE: Find erratic jobs
Maybe you'll find some script a the SSC-scripts section.
Here's one I install by default for dev-support :
-- it uses the msdb-tables and will...
-
RE: What happens after UPDATE statement?
aha, the trigger issue
That's exactly the reason why one should always evaluate if a "procedure" should _always_ be executed when modifying data for...
-
RE: Using Parameters with Stored Procedures
... I love stuff like this. Maybe you should submit it to the script library! ...
Done
-
RE: Self-blocking
select
sum(BalAmt), -- sum does not use columns that have a null-status
sum(BalIntRate)
from DebtCurrBal c with(nolock)
join DebtBase d with(nolock)
on c.DebtBaseKey =...
-
RE: What happens after UPDATE statement?
check your execution plan !
I presume sqlserver in scanning
your full table and suffers a bunch of waits !"RowId is unique index" Is...
-
RE: Running 2000 Ent. Manager alongside 2005
I've reinstalled my test-dekstop with winxp sp2, added sql2000 client (no sp) and then sql2005 client.
Everithing works fine.
SQL2005 client is being instaled with these options :
ADDLOCAL=Client_Components,Connectivity,SQL_Tools90
,SQL_WarehouseDevWorkbench,SDK,SQLXML,Tools_Legacy
,SQL_Documentation,SQL_BooksOnline,SQL_Samples
-
RE: Linked server Out-of-Process
if this connection is to be used frequently , maybe enabling connection pooling is an option
control panel\data sources\connection pooling ....
This way your connection is kept alive (after the application...
-
RE: Linked server Out-of-Process
So apparently the problem is related to the speed of building a connection
or it might even be a connectionpooling problem. 
-
RE: Linked server Out-of-Process
Do you use a domain service account for sqlserver ?
0x80004005 is always an access problem
-
RE: Deduping Data in SQL Server 2005
nice example
Here is another :
WITH
cteEmployeeOrderedByMyRowNumber AS
(SELECT ROW_NUMBER()
-
RE: Job History entries clearing down by itself
check your sqlagent properties/ jobsystem and raise the jobhistory lines.
afaik there is no way of stating that each job should retain at least the last month or n-days of execution...
-
RE: [SQLSTATE 42000] (Error 3140)
What's DBCC CHECKDB stating ?
Also check out : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=197066
and http://www.portsense.com/ng/microsoft.public.sqlserver.server/2004/March/22/314579.cfm
-
RE: Windows scheduled tasks for OSQL
Just a wild shot :
What (type of) account is serving Scheduled Task ? Maybe it does not have the authority to access the batch or osql
Viewing 15 posts - 6,376 through 6,390 (of 7,489 total)