too late, David

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=17912&FORUM_ID=9&CAT_ID=1&Topic_Title=HELP%21+HOWTO+Create+new+tables+from+a+sql+text+file&Forum_Title=General

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Following Mr. Dise posts is always something special and refreshing

Frank

http://www.insidesql.de

http://www.familienzirkus.de

you should see a trash can icon above the post.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

I don't know, but I thought you're developing an SQL Server application. In this case your client needs a license of SQL Server anyway. And so he should have both...

What about using isql or osql utilities that come with SQL Server?

They are explained in BOL

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Do you mean you have a file containing all DDL statements and you're looking for a way to execute this file?

If so, open it with Query Analyzer, point to the...

Thanks Ferguson for this detailed explanation!

Frank

http://www.insidesql.de

http://www.familienzirkus.de

There is a *flaw* in ADO, in that you should place binary columns at the last position in a SELECT statement. Can't find the relevant Knowledgebase article right now. Apart...

Hm... not really related to the above post.

It might be my lack of american management hierachies, so please correct me if I'm wrong.

Apparently american companies do...

In addition to what has been mentioned above, this might also be of some help

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=17632

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Thanks SQLBill, I couldn't figure that out from BOL. Seems pretty useful

Frank

http://www.insidesql.de

http://www.familienzirkus.de

do you mean something like

SELECT 

sysFile.groupid AS GroupID, SUBSTRING(sysFile.groupname,1,30) AS FilegroupName,



SUBSTRING(sysObj.name,1,30) AS ObjectName



FROM sysobjects sysObj 



INNER JOIN sysindexes sysIdx 

ON sysObj.id = sysIdx.id



INNER JOIN sysfilegroups sysFile...

I guess that's what spiders or crawlers do all the time.

I am inclined to suggest you take a look at some hacking sites for relevant source code. of course, stricly...

quote:

---

DECLARE record_cursor CURSOR FOR

SELECT TOP <B>40</B> company_name

FROM tblAddress

WHERE country_code='GB'

ORDER BY address_id

OPEN record_cursor

..

How do I replace the TSQL script above substituting 40 for...

umph...it definitely takes too much time for me to answer

Frank

http://www.insidesql.de

http://www.familienzirkus.de