Viewing 15 posts - 5,446 through 5,460 (of 6,678 total)
balbirsinghsodhi (4/7/2009)
using following command.
ALTER INDEX ALL ON DBO.TABLENAME
...
April 7, 2009 at 7:49 pm
Here are a couple of links that might lead you to a solution. If so, let us know how it works out:
http://windowsitpro.com/articles/print.cfm?articleid=101451
http://blog.usepowershell.com/page/2/
I have the same issue and will be...
April 7, 2009 at 2:04 pm
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...
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...
April 6, 2009 at 10:29 pm
Grant Fritchey (4/6/2009)
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...
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...
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...:)
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...
April 6, 2009 at 1:39 pm
ppcx (4/6/2009)
Jeffrey Williams (3/26/2009)
April 6, 2009 at 1:27 pm
Krishna Potlakayala (4/2/2009)
EdVassie (4/2/2009)
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...
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...
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,...
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.
April 1, 2009 at 10:33 am
Viewing 15 posts - 5,446 through 5,460 (of 6,678 total)