Viewing 15 posts - 5,506 through 5,520 (of 6,676 total)
Are you on SQL Server 2005?
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
March 25, 2009 at 11:52 am
You are welcome - glad it worked. I just wish MS would expose those settings in the configuration instead of having to find it in the config file. ...
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
March 25, 2009 at 11:45 am
You are going to have to use triggers - there really is no other way. As long as the application is sending a value that is valid, that value...
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
March 25, 2009 at 11:11 am
Find and edit the file rsreportserver.config. Locate the section for the Report Server Email extension. Modify the default host name and permitted host name sections and add your...
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
March 25, 2009 at 10:45 am
To add to what Flo has given you, what you would do is create the synonym dynamically based upon the server passed in and use that synonym in your query.
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
March 25, 2009 at 10:32 am
Backing up the transaction log does not shrink the file. Now that you have a regular schedule in place, you can perform a one time shrink down to an...
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
March 24, 2009 at 4:24 pm
There have been several items report on Connect about these kinds of issues. In some cases, users wanted a dialog box on every connection - others wanted connections to...
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
March 24, 2009 at 3:52 pm
CountCet (3/24/2009)
I have a @SearchWord variable and I search...
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
March 24, 2009 at 1:55 pm
Maxim is correct - as soon as you include a column from the outer table in the where clause - it is the same as using an inner join.
Move that...
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
March 24, 2009 at 1:31 pm
Michael Valentine Jones (3/23/2009)[hrMy understanding is that Cache does not support transactions. If so, I see that as a huge drawback. I need my ACID.
Not true - Cache...
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
March 23, 2009 at 5:22 pm
If the ldf is not corrupted, and the database was in full recovery - it might be possible to get a tail log backup of the log. Then, you...
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
March 23, 2009 at 5:11 pm
Why don't you put the code using the CROSS APPLY in a database that is in 90 compatibility and use three-part naming?
I would also recommend that you read the article...
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
March 23, 2009 at 5:08 pm
Steve,
I was hoping you might try and get past the marketing hype and actually take a look at the product itself. One of the nice features in Intersystems Cache...
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
March 23, 2009 at 5:01 pm
Differential backup in their own sub-plan\maintenance plan.
Transaction log backup in their own sub-plan\maintenance plan.
Yes - only user databases. No reason to do anything else with system databases other than...
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
March 23, 2009 at 3:47 pm
JamesNZ (3/23/2009)[/bVery good point. Just to check my thinking, if I'm taking a full backup every night at 9pm, I can delete all differential and transaction log backups that are...
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
March 23, 2009 at 3:32 pm
Viewing 15 posts - 5,506 through 5,520 (of 6,676 total)