Viewing 15 posts - 5,446 through 5,460 (of 6,676 total)
The only reason the master database is not set to 90 compatibility during an upgrade is specifically when there are user objects in that database.
In that case, 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
April 7, 2009 at 9:31 am
Lynn Pettis (4/6/2009)
Then we have a user having a problem with a restore, and they post this and this instead of what the real problem is.
Yes, and Saint Lynn is...
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
April 6, 2009 at 10:29 pm
Grant Fritchey (4/6/2009)
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
April 6, 2009 at 10:01 pm
Joseph (4/6/2009)
thanks Steve... could you tell me the reason for cannot changing back to 80.
Can you explain why you think you need to do this?
FWIW - I would think it...
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
April 6, 2009 at 9:34 pm
peleg k (4/6/2009)
again!i lnow that solution,but i dont want to use it,
i was lookin to get the same result,but in another way if possible
Sorry - what other way were 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
April 6, 2009 at 3:23 pm
In SQL Server 2005 SP2 and greater, you can always run the report 'Disk Usage by Table' to get the results you are looking for.
Just a thought...:)
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
April 6, 2009 at 2:17 pm
peleg k (4/6/2009)
the view is like this :select col1 from tbl1
union all
select col1 from tbl2
......
If your view is a union all view like the above, then all you need 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
April 6, 2009 at 1:39 pm
ppcx (4/6/2009)
Jeffrey Williams (3/26/2009)
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
April 6, 2009 at 1:27 pm
Krishna Potlakayala (4/2/2009)
EdVassie (4/2/2009)
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
April 2, 2009 at 8:17 pm
And now that you have a backup running, you need to follow up and perform a transaction log backup. I am going to guess that your database is set...
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
April 1, 2009 at 2:22 pm
Use SSIS to extract/load data instead of using linked server (is that what you are using?).
Other options:
Create procedures in Progress, call procedures through linked server instead of queries.
Create views in...
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
April 1, 2009 at 11:31 am
My question would be why are you using dynamic SQL? That is why you are having a problem with quotes and Gail has given you the solution for 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
April 1, 2009 at 11:19 am
A quick search found this: http://uda.openlinksw.com/odbc/mt/odbc-ingres-mt/
It does not look free - but they say they have a version that works on x64.
Good luck.
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
April 1, 2009 at 10:33 am
BTW - why are you even using telnet? I would not even enable telnet on any of my SQL Servers in the first place.
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
April 1, 2009 at 10:22 am
If your cluster is setup correctly, you should be able to RDP or Telnet to the VirtualIP address which will direct you to the node that is currently hosting 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
April 1, 2009 at 10:20 am
Viewing 15 posts - 5,446 through 5,460 (of 6,676 total)