Top.Mail.Ru
? ?
SQL Server's Journal

> recent entries
> calendar
> friends
> microsoft.com/sql
> profile

Tuesday, January 3rd, 2006
9:42a - Calling ASP2 applications
How do I instance an ASP2 application from a client machine from within the firewall? Despite that, I wrote it in Visual Studio 2005 Professional Edition, whenever I attempt, it tried to read it as if I wrote it for .Net framework 1.1 and not 2.0. I am calling it over HTTP (i.e., HTTP://pjohnson/website1/default.aspx) where the application resides in a folder in WWWRoot.

(7 comments |comment on this)

11:15a - Hello World and a question
Just joined. Looks like a nice comm.

Quick question:

I have a production database that is about 1 GB in size. I have been tasked to script that baby out into sql files. The tables, procedures, etc. should be little problem (thanks to the database scripting wizard), but the data is eluding me. How can I (relatively automated) script table data into a series of INSERT statements?

Is there any way to avoid manually typing:
"INSERT INTO tbl_WHATEVER (ID, FIELD1, FIELD2, ...) VALUES (1, 1, 1, ...)"?

Thanks in advance!

(8 comments |comment on this)


<< previous day [calendar] next day >>
> top of page
LiveJournal.com
Image