Viewing 15 posts - 2,716 through 2,730 (of 3,061 total)
Bruce W Cassidy (2/12/2009)
February 13, 2009 at 2:32 am
Sudiendra (2/12/2009)
SELECT O.name AS , O.name AS [Index Name],
I.rowmodctr AS [Rows...
February 13, 2009 at 2:26 am
Assuming you are talking about converting Oracle "SQL*Loader control files" into something SQL Server would understand to help you run ETL processes... as far as I know, No.
You are...
February 12, 2009 at 10:53 am
Is that the old-n-good example taken from BOL -AdventureWorks?
Your answers are: Yes, Yes.
February 12, 2009 at 10:48 am
... and here is when you are going to find out how serious is the IT operation in your Company, go and ask for documentation.
Just tell us which face better...
February 12, 2009 at 4:42 am
GUI and related tools are nice to have features yet I script everything.
All changes applied to production MUST be scripted not done on a GUI therefore and since you have...
February 12, 2009 at 2:10 am
rockingadmin (2/11/2009)
using this query i can able to see the tables of that user.
select *
from dba_tables
where owner = 'ACCOUNT"
;
but i try to get the data using...
February 11, 2009 at 3:52 am
rameshnkl (2/11/2009)
Sorry. Actually i mean, 'Master' is a example database name.No probs. Take my database name is 'Something'.
Got it. You may want to check this http://www.mssqltips.com/tip.asp?tip=1620
February 11, 2009 at 2:45 am
rameshnkl (2/10/2009)
I have a Database with the name of 'Master'.
:w00t: Shall we understand you manage to create a "master" database in your SQL Server environment or happens that you have...
February 11, 2009 at 1:24 am
rockingadmin (2/10/2009)
i have checked the user. i can see the data in that user. but the problem is i cant able to use a query
how can i see that...
February 10, 2009 at 11:29 am
guptaajay1985 (2/10/2009)
How to script the constraints?
Have you scripted your tables?
Look closely, constraints are there.
February 10, 2009 at 5:22 am
guptaajay1985 (2/10/2009)
How the data willl come in tables in other DB,if we only script and create the tables in other DB.Thx
It doesn't. You have to move the data.
February 10, 2009 at 5:16 am
rockingadmin (2/10/2009)
I had sucessfully migrated(tables with data) from sqlserver2005 to oralce10g. now i am getting the error.
in oracle10g,after executing the below query::
>>select count(*) from policy;
ERROR at line...
February 10, 2009 at 5:14 am
rockingadmin (2/10/2009)
I had sucessfully migrated(tables with data) from sqlserver2005 to oralce10g. now i am getting the error.
in oracle10g,after executing the below query::
>>select count(*) from policy;
ERROR at line 1:
ORA-00942: table...
February 10, 2009 at 5:12 am
I would script the constraints then apply the script.
February 10, 2009 at 4:11 am
Viewing 15 posts - 2,716 through 2,730 (of 3,061 total)