I seem to remember getting that error on an older version. I ended up using the SSMS plug in, setting it up for the deletion I wanted and then...

SELECT ...

FROM table1 t1

LEFT JOIN table1 t2 ON t2.key = t1.key AND t2.ID_SET_STATUS_TYPE = 3

WHERE t1.ID_SET_STATUS_TYPE = 1;

Need to identify the key column(s) for...

DEL D:\backup\data\SPProd_Cfg _10-19-2008.bak

The above has a space following Cfg. Don't know what else I can say other than the command you have posted has that space in it which...

Davroche (10/21/2008)

---

Thank you Jeffrey. I have used your solution in a number of my queries. How can I change the folowing codes to relate to the current month? ...

Okay, I think I know where the problem is - however, you are going to have to determine how to fix it. The easiest way to find the problem...

You have a space after Cfg and before the underscore which is causing the command to fail. Remove the extra space and it should work.

Yeah, doesn't sound like simple is going to work. And yes, you need to truncate the transaction log before it will shrink. When you perform a transaction log...

Okay, the transaction log on the source system needs to be managed. To start, what is the recovery model for that database? And, how often are you backing...

How large is the transaction log on the system where you took the backup? Not only do you need space for the database (*.mdf), but you need space for...

For Litespeed, you can either use 'xp_procedure' or 'xp_slssqlmaint'. I use 'xp_slssqlmaint' and set it up as:

Execute master.dbo.xp_slssqlmaint '-MAINTDEL -DELFOLDER "%backupDirectory%%database% -DELEXTENSION "%extension%" -DELUNIT "%minutes%" -DELUNITTYPE "minutes" -DELUSEAGE';

Replace the...

You can create a non-clustered index on the column(s) you want indexed. You don't need to drop the clustered index.

This is a simple group by query:

Select cpp.Service

,Sum(cpp.PhaseValue -(cpp.PhaseIPT + cpp.Supplier1Charge + cpp.Supplier2Charge)) As Total

From yourTable cpp

Where CPP.PhaseStartDate >=...

nilmov (10/19/2008)

---

i slightly differ on that...if it is full logged and your disk is getting full, shrink is the option left. Not regularly but when have a downtime try...

Just to...

Leo (10/19/2008)

---

Hi Gila,

Sorry, I get back to you a bit late. I am not fully understanding about Transaction Log. Let say I switched my DB Model to 'SIMPLE'. I don't...