Help on ANSI

Hi all!!!!!!
My requirement is to write DDL and DML scripts which are ANSI complient, so that it can run on MS SQL server 7.0 & 2000, Oracle 8i & 9i, DB@. and Sybase.
So could U plz tell me where can I find ANSI Standards for this.Originally posted by sameer_mehta198
Hi all!!!!!!

My requirement is to write DDL and DML scripts which are ANSI complient, so that it can run on MS SQL server 7.0 & 2000, Oracle 8i & 9i, DB@. and Sybase.

So could U plz tell me where can I find ANSI Standards for this.

How about:

http://webstore.ansi.org/ansidocstore/default.asp

a little google will do ya...

Help needed on Full text Search

Hello,
we got a requirement where i hvae to implement a full text search in SQL
Server 2000/2005. Can some one help me Where/How to start ? Any links for
the articles is also good.
Thanks in Advance
Srinivas
have a look at the links in indexserverfaq.com for sql fts.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Srinivas Kollipara" <skollipara@.stratasolutions.com> wrote in message
news:eweiaU9FGHA.516@.TK2MSFTNGP15.phx.gbl...
> Hello,
> we got a requirement where i hvae to implement a full text search in SQL
> Server 2000/2005. Can some one help me Where/How to start ? Any links for
> the articles is also good.
> Thanks in Advance
> Srinivas
>

Help needed on Full text Search

Hello,
we got a requirement where i hvae to implement a full text search in SQL
Server 2000/2005. Can some one help me Where/How to start ? Any links for
the articles is also good.
Thanks in Advance
Srinivashave a look at the links in indexserverfaq.com for sql fts.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Srinivas Kollipara" <skollipara@.stratasolutions.com> wrote in message
news:eweiaU9FGHA.516@.TK2MSFTNGP15.phx.gbl...
> Hello,
> we got a requirement where i hvae to implement a full text search in SQL
> Server 2000/2005. Can some one help me Where/How to start ? Any links for
> the articles is also good.
> Thanks in Advance
> Srinivas
>

Help needed on Full text Search

Hello,
we got a requirement where i hvae to implement a full text search in SQL
Server 2000/2005. Can some one help me Where/How to start ? Any links for
the articles is also good.
Thanks in Advance
Srinivashave a look at the links in indexserverfaq.com for sql fts.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Srinivas Kollipara" <skollipara@.stratasolutions.com> wrote in message
news:eweiaU9FGHA.516@.TK2MSFTNGP15.phx.gbl...
> Hello,
> we got a requirement where i hvae to implement a full text search in SQL
> Server 2000/2005. Can some one help me Where/How to start ? Any links for
> the articles is also good.
> Thanks in Advance
> Srinivas
>

Help Needed ! , Data Migration from MS Access2003 to SQL Express 2005

Hi ,

I have a requirement to migrate the data from an existing MS Access database to a newly designed SQL Express 2005 database . Need less to say the table structures in both are totally different.I would like to know how can i handle a scenerio where i want to map table A in access to table B in SQL express (the schema of both different and the number of columns can vary too) , how do i migrate the data from table A in Access to Table B in SQL express using SSMA?

Also i would appreciate if some one can tell me is SSMA the right tool for this , or should i use the upsizing wizard of MS Access.If there is no change in schema between source and destination databases (more of upsizing) then the process is pretty straight forward , The constraint here is that the data needs to be migrated to a new schema where the column names and number of columns can vary between the source table and destination table.. I just need to migrate data only and no other objects.

Need Help!

Thanks

Mahesh

Hi Mahesh,

SSMA is a right tool for migration

http://www.microsoft.com/downloads/details.aspx?familyid=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en and refer discussion at TechNet for troubleshooting http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.sqlupsizing&cat=en_us_FB980B1A-C148-9C19-560F-548B843A67AB&lang=en&cr=us

and refer this thread too http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1033679&SiteID=1

Hemantgiri S. Goswami