Viewing 15 posts - 6,376 through 6,390 (of 6,676 total)
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"...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 9, 2008 at 11:17 am
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 9, 2008 at 11:08 am
obarahmeh (7/9/2008)
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 9, 2008 at 9:41 am
ltoso (7/8/2008)
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 8, 2008 at 10:17 pm
chazcross (7/8/2008)
The results are going to be used in a query that does data paging...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 8, 2008 at 10:00 pm
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 8, 2008 at 9:20 pm
Hugo,
That is what I thought it meant, thanks for the confirmation.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 8, 2008 at 5:25 pm
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 8, 2008 at 1:57 pm
--===== This query is simplified from the original, where the 2 tables
-- reside in 2 sperate databases.
DELETE
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 8, 2008 at 1:43 pm
Judy Scheinuk (7/7/2008)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 7, 2008 at 8:44 pm
Ivanna Noh (7/7/2008)
When a new row is inserted into 'myTable', insert a row into the audit...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 7, 2008 at 4:30 pm
sqlservercenter (7/7/2008)
when the weekend shrink job runs, include the reindex job.
Why shrink the database in the first place if it is just going to grow again over the next week?...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 7, 2008 at 4:09 pm
SQLServerLifer (7/7/2008)
update table
set {column name} =
replace( replace( {column name}, '!', ''), '''','')
where
charindex( '!', {column...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 7, 2008 at 4:07 pm
Matt Miller (7/7/2008)
Giya (7/7/2008)
The user is choosing the date range from calendar control and it displays in mm/dd/yyyy format as 06/01/2008. Is there any way around?
If you pass this stuff...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 7, 2008 at 3:26 pm
tbeadle (7/7/2008)
When requesting a date range, one must remember the time part of the date.
So whenever requesting a date range use code like this :
select *
from tablexyz
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 7, 2008 at 3:06 pm
Viewing 15 posts - 6,376 through 6,390 (of 6,676 total)