Viewing 15 posts - 5,746 through 5,760 (of 6,676 total)
interfac (12/30/2008)
SELECT master.id, master.field1, child.field1
FROM master INNER JOIN child on master.id = child.masterID
WHERE child.id =...
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
December 30, 2008 at 3:27 pm
One thing you can try - might work, is to prefix all calls to the system views with the database and run the script from within the context of a...
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
December 30, 2008 at 2:26 pm
No - once a database has been upgraded, it cannot be restored or attached to an older version. This was true from 2000 to 2005 and is still true...
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
December 30, 2008 at 11:39 am
This is a classis UNPIVOT process. You can review UNPIVOT in Books Online to see how to use it to get what you want. Another option you could...
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
December 30, 2008 at 2:05 am
You can use VARCHAR(MAX) - but I have to ask why you are using dynamic SQL in the first place, and especially a dynamic SQL string that exceeds 8000 characters.
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
December 30, 2008 at 1:59 am
Posting the full code doesn't make any difference here. You have a cursor, inside a cursor looping through who knows how many rows - creating multiple temp tables for...
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
December 30, 2008 at 1:42 am
Yeah, I know what you mean - but, I think I have it a bit harder than you do. If you have ever worked with any flavor of Mumps...
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
December 30, 2008 at 1:27 am
Yeah - I can see that. Thanks for the pointer to the bug article - I knew I had seen something like that also, but since I no longer...
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
December 30, 2008 at 1:07 am
Jeff Moden (12/30/2008)
http://www.sqlservercentral.com/articles/SSIS/64766/
All I can say is "Good Grief"... it took this person...
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
December 30, 2008 at 12:59 am
Gail, thanks for the test. It is interesting that the OP is getting the same error that you would get if you tried to perform a diff before ever...
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
December 30, 2008 at 12:44 am
RBarryYoung (12/29/2008)
Chirag (12/2/2008)
i think i got this from some code written by Jeff Modem 🙂BeeeeeeeeeeeeBoooooooooooShshshshshshhhhhhhhhh....
😀
Hey, I was just wondering if he's 9600, 14400 or 19200.
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
December 29, 2008 at 9:31 pm
AFAIK - the QFX format is proprietary and banks actually have to pay Intuit for the specs. Not sure you are going to find anything available that is free.
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
December 29, 2008 at 3:32 pm
Okay, I am still not clear what you are trying to say. If you have replication enabled between two databases and these objects which you have created synonyms for...
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
December 29, 2008 at 3:17 pm
GilaMonster (12/29/2008)
Jeffrey Williams (12/29/2008)
This could also...
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
December 29, 2008 at 3:12 pm
Changing the recovery model from full to simple will invalidate the backup chain - causing differential backups to fail with the error you are getting.
This could also be caused (I...
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
December 29, 2008 at 11:55 am
Viewing 15 posts - 5,746 through 5,760 (of 6,676 total)