Forum Replies Created
Viewing 15 posts - 6,046 through 6,060 (of 7,505 total)
-
RE: Cannot add a data file Error 1105 because ''''PRIMARY'''' filegroup is full
...but existing objects could not make use of the secondary filegroup?...
- If you don't alter existing objects (tables or indexes), they will not use the new filegroup ! You have...
-
RE: Cannot add a data file Error 1105 because ''''PRIMARY'''' filegroup is full
- and off course there should be space at disk-level
- your db already has a filegroup named 'secondary'
choose another name. contact your...
-
RE: Cannot add a data file Error 1105 because ''''PRIMARY'''' filegroup is full
- use xp_fixeddrives to check out your current freespace at the "local" drives.
(this proc may be secured)
- there may be file-latency when extending a datafile (from your primary filegroup)...
-
RE: INSERT & UPDATE not working all of sudden
how about (b)locking issues, long running requests,...
sp_who2, sp_lock may help out
-
RE: sp_detach_db works, re-attaching it doesn''''t!
in that case also copy the path to the ldf file from explorer.
maybe the best way is to rightclick and hold and drag to the run window
(start\run) clear the...
-
RE: Single/Double quote in [A-MSG] token
with SET @Msg = 'Error: [A-ERR]' + CHAR(10) + 'Severity: [A-SEV]' + CHAR(10) + 'Date: [STRTDT]' + CHAR(10) + 'Time: [STRTTM]' + CHAR(10) + 'Database: [A-DBN]' + CHAR(10) + 'Message:
-
RE: sp_detach_db works, re-attaching it doesn''''t!
Check your cluster service settings for sqlserver !
I suspect you didn't create a dependency for your sqlserver instance with the R-drive ! Therefor sqlserver cannot reach the drive !
-
RE: Performance changed with OS update... now more blocking...
I forgot to mention you only defrag the indexes.
Defrag only does index-level-optimisation.
Check BOL.
After every upgrade, sp, restore, attatch_db it is advisable
to perform full dbmaintenance.
dbcc dbreindex (or configure a maintenanceplan)
sp_updatestats
dbcc updateusage(0)...
-
RE: Performance changed with OS update... now more blocking...
just a shot in the dark ...
- did you format the volumes with blocksize to max in stead of default (4k) ?
- maybe your clustering index isn't the right one...
-
RE: Replication Fails after removing BUILTIN\Administrators
... Also if there is a way for me to see how the login is linked through a group I would be interested to know how. ...
EXEC master..xp_logininfo @acctname =...
-
RE: Copy database - data only?
if your volume is not that high, you may even use the tablediff.exe
you can find it at
"C:\Program Files\Microsoft SQL Server\90\COM\tablediff.exe"
October 25, 2006 at 1:49 am
-
RE: Job Step Duration
I've just copy/pasted the script and added the last inner-join-part.
It returned rows. (with sql2000 and with sql2005)
This is the full script, copy/paste it and run. It should give results if...
-
RE: constraint: enforce unique key on subset of rows
just to add to the other replies :
you could use triggers to enforce this check constraint.
Although its better to avoid ....
CREATE TRIGGER mytrigger _IU ON mytable
FOR insert, update
AS
BEGIN
if exists...
-
RE: Job Step Duration
or maybe even replace the complete where clause with
inner join
( select job_id, max(run_date) as Max_run_date
from msdb.dbo.sysjobhistory
group by job_id ) jhMAX
on jh.job_id = jhMAX.job_id
and jh.run_date = jhMAX.Max_run_date
Viewing 15 posts - 6,046 through 6,060 (of 7,505 total)