Are you running out of space for the data file? Or, is your log file growing too large?

We have seen a lot of posts recently about the transaction log...

If you can't get it to work with the changes GSquared has outlined, I would rethink this approach. Based upon what you have shown to this point, it appears...

I run this by calling it from an SSIS job, and it throws these errors:

Message: Executing the query "exec sp_ODSExportDelete ?,?,?,?" failed with the following error: "The multi-part identifier "PLODS_DEV.ODS_S1.dbo.TRANS_RESULTS.SERVER_NM"...

Glad I could help, now for future reference - please read the following article:

Best Practices: http://www.sqlservercentral.com/articles/Best+Practices/61537/

This article will show you how to post your questions so it is much easier...

obarahmeh (7/9/2008)

---

Thanks for ur Comments and reply,

First: I have two columns; one for the 'DayTransDate' like (2008/08/09) which is stored in the Data base as a Decimal= 20080709, and...

ltoso (7/8/2008)

---

Hi,

we are using ms sql server express 2005 and we are getting the error

The transaction log for database 'database' is full. To find out why space in the...

chazcross (7/8/2008)

---

Im having some trouble writing a query to return results the way i would like it.

The results are going to be used in a query that does data paging...

Wow, can't say I have seen so much complaining about an article in a long time.

I have to work with all sorts of individuals who have no idea...

Hugo,

That is what I thought it meant, thanks for the confirmation.

So, I got this wrong also - was going to go with STATIC, but noooooooooo - I read BOL and changed my answer :w00t:

Anyways, I really can't test this myself...

--===== This query is simplified from the original, where the 2 tables

-- reside in 2 sperate databases.

DELETE

...

Judy Scheinuk (7/7/2008)

---

We have identified our problem. A purge is being run through the application on Monday mornings at 1:00 AM. The person in charge of the application...

Ivanna Noh (7/7/2008)

---

how about creating a trigger on 'myTable' for inserts, and creating a separate 'audit' table

When a new row is inserted into 'myTable', insert a row into the audit...

Why shrink the database in the first place if it is just going to grow again over the next week?...

SQLServerLifer (7/7/2008)

---

ok, 3rd time's a charm...

update table

set {column name} =

replace( replace( {column name}, '!', ''), '''','')

where

charindex( '!', {column...