Date: 05/28/06 (Asp Dot Net)    Keywords: css, database

My data presentation needs help. I have a simple SELECT to grab data from my database and that works well. The data I have being presented in a gridview needs something more. In my searching I can’t seem to find how to apply CSS to the gridview. Is that possible?
I want to have full control over the spacing, colors margins and padding, as well as the data inside. I wish to have the gridview in a more linier view and not locked to an excel looking horizontal display.

I'm making a simple blog so I want the format..

Subject

Body of the post

Time and date / username




thanks

Source: http://community.livejournal.com/aspdotnet/68808.html

Date: 05/31/06 (Asp Dot Net)    Keywords: software, xml, database

I’ve been challenged at my work to develop something on the order of a mobile helpdesk.
We run clientele as our helpdesk software, not that it’s important but it’s pretty popular.
Also my department just got new Windows Mobile devices and I’m been exploring different ways to use them and I’m looking into being able to view a database remotely.
Is it possible to extend a database view with ASMX is that what ASMX does, or should I be looking at straight XML for just simply viewing a remote database table.

Source: http://community.livejournal.com/aspdotnet/69025.html

Date: 05/31/06 (Web Development)    Keywords: cms, php, mysql, database, asp, sql, security, web

Hi all, a quick question.

I use PHP mostly because it's the only web language I know well enough to do what I need to do on a daily basis, but my place of employment is considering redesigning the web site - and letting me have control over how it's developed and in what languages, etc. Is there any advantage of using ASP over PHP, or any other language over another? I integrate a lot with a database (MySQL) (calendars, event listings, internship databases, video archive, etc) and currently run on a Sun box, but I also need to integrate (in the future) with a SQL database on an IIS server, which required me to develop in ASP. I didn't know ASP so we had to contract it out, and I'd rather avoid doing that again in the future - unless there's an added security benefit to asp or something like that. Opinions anyone, on what language to use vs another, or any opinions on a sort of "dream set up" (including CMS - I've never used a third party so recommendations would be interesting) I might be able to go after?

Thanks everyone!

Source: http://community.livejournal.com/webdev/325474.html

Date: 05/31/06 (WebDesign)    Keywords: html, database, java

So I have this simple function that swaps an image and its caption on an HTML page:

Source: http://community.livejournal.com/webdesign/1118592.html

Date: 05/31/06 (PHP Community)    Keywords: php, mysql, html, database, sql, microsoft

Alright guys, I'm having a bit of a problem. I'm in the process of writing this small document-tracking application for my mother's work and was writing it on my own site. It worked almost perfectly except for some functionality that I had yet to add.

But when I went to upload it to the server it was supposed to be on, I found out they were running an older version (4.4.1) than the one I had been writing for (5.1.2). So, I went in to go fix the problems (like removing Try-Catch statements), and I seem to have gotten most of them worked out, except one: for some reason the mail() function isn't actually sending any mail.

I've tried it with many different email addresses and no luck. Now, the server this is currently on (the server it will have to be run from as well) is using Microsoft Exchange which I don't really know much about. We've been looking at some of the other applications that are run on this server with working mail functionality and can't figure out why this application isn't running.

//File Name: docFunctions.php
//Author: Lisa Obenauf
//
//For use by Union Station of Kansas City (http://www.unionstation.org) only.

function generateEmail()
  {
    //MYSQL DB Connection and Table selection removed for privacy puroses//
    
    //Verify the connections to the Database and Table
    if (!$email_connect || !$db_select)
    { 
      die("Problem connecting or selecting a database."); 
    } //end if

    //initialize variables
    $sender = $_POST['docFrom'];
    $attachment = $_FILES['docAttachment']['name'];

    $headers = "From:" . $_POST['docFrom'] . "\r\n";
    $headers .= "Reply-To:" . $_POST['docFrom'] . "\r\n";
    $headers .= "Content-Type: text/html;\r\n charset=\"iso-8859-1\"\r\n";

    $body = "    
      
        
      

      
        

          File: " . $_FILES['docAttachment']['name'] . "

          Respond By:" . $_POST['docDue'] . "
        
        

          " . $_POST['docDescription'] . "
        
      
    ";
    
    //Verifies that a recipient has been selected.  If not, an error is displayed.
    if ($_POST['docTo1'] === "")
    {
      die("Please choose someone to receive the attached document.");
    } //end if
    else
    {
      //Initialization of the $query statement for INSERT
      $query = "INSERT INTO `doc_tracking` ( `doc_id` , `doc_from` , ";
      $query .= "`doc_to_1` , `doc_to_2` , `doc_to_3` , `doc_to_4` , `doc_to_5` , `doc_to_6` , `doc_to_7` , `doc_to_8` , `doc_to_9` , `doc_to_10` , ";
      $query .= "`doc_route` , `doc_distribution` , `doc_due` , `doc_action_1` , `doc_action_2` , `doc_action_3` , `doc_action_4` , `doc_action_5` , ";
      $query .= "`doc_action_6` , `doc_action_7` , `doc_action_8` , `doc_action_9` , `doc_action_10` , `doc_description` , `doc_attach` ) ";
      
      $query .= "VALUES (NULL , '" . $_POST['docFrom'] . "', '" . $_POST['docTo1'] . "', ";

      //Sets the recipient of the email
      $recipient = $_POST['docTo1'];

      //if there are more recipients, they are added to $recipient for use in mass mailing.  
      //The $query variable is also augmented with either the person's email address or NULL if no address was selected.
      if ($_POST['docTo2'] === "")
        $query .= "NULL ,";
      else
      {
        $query .= "'" . $_POST['docTo2'] . "', ";
        $recipient .= ", " . $_POST['docTo2'];
      } //end else

      if ($_POST['docTo3'] === "")
      $query .= "NULL ,";
      else
      {
        $query .= "'" . $_POST['docTo3'] . "', ";
        $recipient .= ", " . $_POST['docTo3'];
      } //end else
    
      if ($_POST['docTo4'] === "")
        $query .= "NULL ,";
      else
      {
        $query .= "'" . $_POST['docTo4'] . "', ";
        $recipient .= ", " . $_POST['docTo4'];
      }  //end else
    
      if ($_POST['docTo5'] === "")
        $query .= "NULL ,";
      else
      {
        $query .= "'" . $_POST['docTo5'] . "', ";
        $recipient .= ", " . $_POST['docTo5'];
      } //end else

      if ($_POST['docTo6'] === "")
        $query .= "NULL ,";
      else
      {
        $query .= "'" . $_POST['docTo6'] . "', ";
        $recipient .= ", " . $_POST['docTo6'];
      } //end else
    
      if ($_POST['docTo7'] === "")
        $query .= "NULL ,";
      else
      {
        $query .= "'" . $_POST['docTo7'] . "', ";
        $recipient .= ", " . $_POST['docTo7'];
      }  //end else
    
      if ($_POST['docTo8'] === "")
        $query .= "NULL ,";
      else
      {
        $query .= "'" . $_POST['docTo8'] . "', ";
        $recipient .= ", " . $_POST['docTo8'];
      }  //end else
    
      if ($_POST['docTo9'] === "")
        $query .= "NULL ,";
      else
      {
        $query .= "'" . $_POST['docTo9'] . "', ";
        $recipient .= ", " . $_POST['docTo9'];
      }  //end else
    
      if ($_POST['docTo10'] === "")
        $query .= "NULL ,";
      else
      {
        $query .= "'" . $_POST['docTo10'] . "', ";
        $recipient .= ", " . $_POST['docTo10'];
      }  //end else
      
      //Initialization of the "Respond By" information
      $dueBy = $_POST['docYear'] . "-" . $_POST['docMonth'] . "-" . $_POST['docDay'];

      //Continuation and conclusion of the INSERT statement
      $query .= "'" . $_POST['docRoute'] . "', 'all' , '" . $dueBy . "', NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , '" . $_POST['docDescription'] . "', '" . $attachment . "');";

      //Email Information to be displayed to the user.  Contains the information sent in the email.
      echo "Document Number: " . $_POST['docID'] . "

";
      echo "From: " . $_POST['docFrom'] . "
";
      echo "To: " . $recipient . "

";
      echo "Attachment: " . $_FILES['docAttachment']['name'] . "

";
      echo "Respond By: " . $_POST['docMonth'] . "-" . $_POST['docDay'] . "-" . $_POST['docYear'] . "
";
      echo $_POST['docDescription'];

      //Inserts information into the Database
      $result = mysql_db_query("test", $query);

      //Checks to see if the email needs to be sent to each person Sequentially or all at once.  
      //If sequentially, then the e-mail is just sent to the first recipient, and will be sent to the rest of the recipients.
      //through confirmation via a different form.
      if ($_POST['docDistribution'] === "all")
        mail($recipient, "", $description, $headers);
      else
        mail($_POST['emailTo1'], "File: " . $_POST['docAttach'], $body, $headers);
     
      //verifies the successful insertion of the information into the database.
      if (!$result)
      {
        die("
Invalid Query: " . mysql_error() . "
");
      } //end if
      else
      {
        echo "
Insert successful.
";
      } //end else
    } //end else
    mysql_close();
  } //end generateEmail()

Source: http://community.livejournal.com/php/455409.html

Date: 05/31/06 (Javascript Community)    Keywords: html, database, java

So I have this simple function that swaps an image and its caption on an HTML page:

Source: http://community.livejournal.com/javascript/100742.html

Date: 06/02/06 (C Sharp)    Keywords: database, asp

Hi All,
As I was doing this tutorial on VS 2005 , at the very end of part one I have encountered a problem, When I dragged and dropped the stored procedure onto the Dataset design view, and then went to modify the partial class for the dataset the following code gave me an error when translated to C#:

VB.Net
Public Function SubmitRating(ByVal LinkID As Integer, ByVal NewRating As Integer) As Long
Dim AvgRating As Long = 0 'output parameter returned
AvgRating = taSP.LinkRatingVote(LinkID, NewRating, AvgRating)
'update the avg rating in dataset
Dim row As LinkRow = Link.FindByLinkID(LinkID)
row.AvgRating = AvgRating
row.EndEdit()
row.AcceptChanges() 'no need to pass to the database
End Function

C#
public long SubmitRating(int LinkID, int NewRating)
{
long AvgRating = 0;
AvgRating = = taSP.LinkRatingVote(LinkID, NewRating, AvgRating)(LinkID, NewRating, AvgRating); Argument 3 cannot convert from long to ref int
LinkRow row = Link.FindByLinkID(LinkID);
row.AvgRating = AvgRating;
row.EndEdit();
row.AcceptChanges();

}

please help, what whould the correct code look like?
Update: - I tried changing AvgRating to an int, and called LinkRatingVote as follows :- taSP.LinkRatingVote(LinkID, NewRating, ref
AvgRating) I still had the same error saying the arguments aren't correct.

Source: http://community.livejournal.com/csharp/64406.html

Date: 06/02/06 (SQL Server)    Keywords: database, sql

Okay, so we finally got SQL Server 2005 installed on my machine. (Wiped and started from scratch. Took a week to get it done right. Don't ask.) First thing I have to do: a vendor is changing table structures on me, so I need to go in and change the tables. Simple enough matter. Most of the tables change fine. Two of them, however... when I hit "save," I get a warning box: "saving definition changes to tables with large amounts of data..." then it bleeds off the side of the screen, but in essence it's a warning that the table will be locked. I hit OK, and about a minute and a half later, I get a timeout expired error.

Is there any way to do this without stripping the data, copying the table structure, or anything like that? (In other words, is there any way to save definition changes to a large, heavily populated database table as is?)

Source: http://community.livejournal.com/sqlserver/49376.html

Date: 06/06/06 (PHP Community)    Keywords: mysql, database, sql

this has been driving me mad for several hours now :(

how on earth do I convert cyrillic characters into something that can be safely stored and retrieved from a mysql database?

From playing around with wordpress etc, I know I need to do this:

привет -> привет

but I have no idea what function(s) to use. Thanks :)

Source: http://community.livejournal.com/php/458161.html

Date: 06/08/06 (Application Development)    Keywords: database

DB2 9, an update to Big Blue's database due next month, heaps on features aimed at stealing market share.

Source: http://news.zdnet.com/2100-9593_22-6080999.html

Date: 06/09/06 (Asp Dot Net)    Keywords: database, asp, sql, web

My struggles continue.





Ok so I've been assigned the daunting task of setting up our documents to be sent to our new content management system from our current one which was written by a bunch of dumb brits who stole 80% of their code from Wrox. I need to bring out all the current and old documents. They are housed
in 1 database in 2 tables. All the current documents are in 1 table, and all their old versions are in the other. They use keys to communicate with each other, so every versioned document references the id of its current document. Also, not every current document has more than one version, so not every document in the current table has a corresponding record in the old table (the information in these tables is not totally consistent either, but that's a whole other issue that I'm not delving into now.)

The problem I'm having is that while my query will return all versioned records and current records WITHOUT any subsequent versions, it does NOT return the most current record of the versions. What I mean is that if there is four versions of a document, 3 of the documents are in the old table and 1 (the current version) is in the current table. My query only returns the 3 from the old table, and not the most recent one which resides on the current table.

My query looks like this. Some of the information is extraneous. The bold part is the main function I feel refers to this.

SELECT d.mdItemID AS CurrentID, d.mdFileDescription AS CurrentFile, d.mdFileName as CurrentFileName, d.mdCreatedByUser AS Creator, d.mdCreatedDate AS SubmittedDate,
tblMics_Docs_Versions.mvSubItemID AS OldID, tblMics_Docs_Versions.mvVersionedDate AS VersionedDate,
tblMics_Docs_Versions.mvFileName as OldFileName, tblMics_Docs_Versions.mvNotes AS VersionNotes,
tblDepartment.dpNAME AS DepartmentName FROM tblMics_Docs AS d INNER JOIN
tblDepartment ON d.mdDepartmentID = tblDepartment.dpID LEFT OUTER JOIN tblMics_Docs_Versions ON
d.mdItemID = tblMics_Docs_Versions.mvItemID
WHERE d.mdArchived = 0 ORDER BY mdItemID ASC, VersionedDate ASC

tblMics_Docs is the current table, tblMics_Docs_Versions is the old table.

People have suggested using temp tables or a UNION command to fix this issue, but the problem is that I got a 2.5 in SQL in college and its not my strong suit.


This is for a program that's being written in C# and binding to a datagrid (the webform version, NOT the ASP.Net version.) I figured this would be a good place to ask this question. If anyone could help me with this it would be greatly appreciated. Thanks.

Source: http://community.livejournal.com/aspdotnet/70280.html

Date: 06/12/06 (C Sharp)    Keywords: database, sql

I’m currently working with C# and SQLExpress 2005, and I’m doing some database stuff.

I have a table that has two columns, [Index] and Descriptor. It looks like:

0 Inactive
1 Active
etc.



Relevant code:

DataSet DS2 = new DataSet();

//cbostatus is a combo box containing a list of descriptors that the user can choose from

string getstat = "SELECT [Index] FROM status WHERE Descriptor = '" + cboStatus.Text + "';";

conn.Open();
SqlDataAdapter stat = new SqlDataAdapter(getstat, conn);
stat.Fill(DS2);

//The stat.Fill command should return a single value, since the sql query only returns 1 value

int status = Convert.ToInt32((DS2.Tables[0].Rows[0]));

// This is where I get an error, and the error is "InvalidCastException was unhandled Unable to cast object of type 'System.Data.DataRow' to type 'System.IConvertible'."

conn.Close();


Any ideas on how I can get this to return an int, or convert the dataset element to an int?

Thanks!

Source: http://community.livejournal.com/csharp/65023.html

Date: 06/12/06 (IT Professionals)    Keywords: database, microsoft

I was recently approached by my boss for suggestions on storing our company's system account/passwords and other information in some secure fashion. Right now, most of the information is kept in a password protected excel spreadsheet on the boss's laptop.

I can create a small database that I can lock down and put on the network, but I would prefer an out of box solution. I know that there are plenty of personal password managers out there, but I would like to find something that we can install onto our network so that multiple people can access the information, if given permissions. Something that would tie into Microsoft AD would be great. Does anyone have any suggestions?

Source: http://community.livejournal.com/itprofessionals/39173.html

Date: 06/15/06 (MySQL Communtiy)    Keywords: database

Thanks for the responses to my last post, I now have a better understanding regarding primary keys and natural/foreign keys.

Now, after reading online about the topic, I don't see any clear explanation on how the keys are produced. For instance, say I have a foreign key, auto-increment, if I want to enter a song in the database, and it already has the artist entered previously, will it automatically know to give it the right artists_id key if I tell it the name of the artist? Does that make sense? I would assume if the artist isn't already in the database, it will add it and increment the primary key (artist_id), and if it is, it'll just use the primary key that already exists for that artist.

Source: http://community.livejournal.com/mysql/97191.html

Date: 06/17/06 (MySQL Communtiy)    Keywords: database, sql

I am looking for work in the Atlanta area and I have been taking skills tests for the last two weeks. One of the companies that I went to had this strange(to me) concept of a super id. All their tables in all their databases had an auto incrementing id plus a superId that was unique through the database. They told me to only use the superID to deal with the data. They had some functions that would handle the superID and I just had to pass them SQL. The functions also kept track of date created and date modified for each record. Each table would look something like this:

superID | date_modified | date_created | table_id |~ fields for the table ~|

I get that its easier to use in some ways but they could not really explain the concept to me. Has anyone ever heard of this or done it?

Source: http://community.livejournal.com/mysql/97788.html

Date: 06/19/06 (WebDesign)    Keywords: php, mysql, database, sql, web

Hi
I recently asked your opinions on my site, groovescapeonline.net!
Well, I really don't think this is the place to do it, and i'll just delete the post once I get in trouble for it (if this isn't in fact the place for it)-- But would anybody here be willing to help me in creating some sort of database that users upload information to? I've looked all around the net, looked at all sorts of scripts (some worked, some didn't, and then-- ahhhh).

There's a thing on this website ( http://ddrfreak.com ) -- If you go to "machine locations", users submit locations of machines and they go up in an organized fashion. (I'm not looking for something that complicated or as complicated---) OR-- like a site like www.bemanistyle.com -- how users are able to submit "simfiles" (a zip file, i guess), which posts itself in a searchable database.

I just wanted some tips or maybe somebody's assistance on how I would create something like this. I have a MySQL database thing for my forum (phpbb)-- and I just want to make a database of some sort, that users could either submit files to a searchable extent-- OR just to submit locations (for another site of mine: http://piuzone.com . there's been a promised 'locations database' that I still haven't done because I just can't figure it out.)

Thanks, and I apologize if this is the wrong place for this, and i'll go about deleting the post if that's the case. :)

(P.S: I changed the links to pink to match the banner uptop. Good? :D )

Source: http://community.livejournal.com/webdesign/1126476.html

Date: 06/20/06 (PHP Community)    Keywords: php, database, java

I have a question about which is more expensive: writing to a file, or saving to a database. We're talking about an average of 450 characters (when the array is serialized). The usage is always read frequent, but it varies between write frequent and write infrequent.

The PHP script is an interface for a couple people, connected via AJAX. The script gets called oncy every 5 seconds (by each person via JavaScript) to make sure they're all on the same page. Right now I'm using the filesystem - I know that, should by some miracle I get more servers in the future, using files won't be an option. But, right now I'm on one and probably staying on only one.

I want to know where to save this information. What is worse - running file_get_contents() and unserialize() every 5 seconds, or calling a database every 5 seconds? I've heard bad things about both, and I'm wondering what your opinions are.

Source: http://community.livejournal.com/php/462018.html

Date: 06/20/06 (C Sharp)    Keywords: programming, database, sql, web

I'm writing a program in C# 1.1 that extracts documents from our current database to be then transferred into our new content manager/collaborator or whatever. Anyways I have basically written the program and it successfully extracts the documents that I tell it to, but the problem is that its a major memory hog, and when I monitor the memory and the heap size it is just staggering. The problem is that I basically have loops that are going and grabbing sometimes hundreds of documents at a time, and when the documents are over 1mb in size it almost starts to get scary. I should also point out that I've never written a program like this before and I have learned more about programming and memory management than I ever cared to know. I don't know if there's anything I'm programming wrong, or if I'm not releasing resources correctly. My "expertise" is more in Web development than this, and it doesn't help that not alot of people at my company know C#. Anyways below is the code I have for grabbing multiple documents.

{
con.Open();

SqlDataAdapter da = new SqlDataAdapter("Select * FROM tblMics_Docs_Versions WHERE mvItemID = " + number + " ORDER BY mvVersionedDate DESC", con);

int i = 0;
int j = 1;

byte[] MyData = new byte[0];

da.Fill(ds.Tables[1]);
da.Dispose();

DataRow myRow;

for (i = 0; i <= ds.Tables[1].Rows.Count - 1; i++)
{

myRow=ds.Tables[1].Rows[i];
MyData = (byte[])myRow["mvContent"];

string thefile;

string theid;

thefile = myRow["mvFileName"].ToString();

theid = myRow["mvItemID"].ToString();

int ArraySize = new int();
ArraySize = MyData.GetUpperBound(0);

string s=System.IO.Path.Combine(dept, "ID " + theid + " Version " + j + " " + thefile);
DirectoryInfo di = Directory.CreateDirectory(@"c:\BMS Old\" + dept);
FileStream fs = new FileStream(@"C:\BMS Old\"+ s, FileMode.OpenOrCreate, FileAccess.Write);
fs.Write(MyData, 0,ArraySize);

fs.Close();



myRow = null;
MyData = null;
j++;
s = null;
di = null;
thefile = null;
theid = null;

}
ds.Dispose();
ds.Tables[1].Dispose();
ds.Tables[1].Clear();

con.Close();

//con.Dispose();
//con = null;
}

I'm sure this code isn't great, but at the very least it WORKS. Now I need to clean it up so we can run this in a production environment. Thank you.

Source: http://community.livejournal.com/csharp/65808.html

Date: 06/20/06 (SQL Server)    Keywords: software, database, sql, security

Please email me directly: jason@froebe.net

these are permanent positions (sorry, no H1B visas) to be filled within a couple weeks. (Second job description is for MS SQL Server)

The group description didn't mention if job postings were allowed or not. Please let me know if they are ok or not.


Job posting #1:
===============
Sybase Database Administrator
Description
The database administrator for Sybase ensures the control and security of data and efficient use of system resources. Provides technical assistance to users. Develops methods to improve operational and production functions. Assists in the install of complex system software.

Essential Duties and Responsibilities
Sybase Replication Server – ongoing maintenance and setup for new servers as needed
As needed - SQL tuning advisory consulting and hand on trouble shooting for development team. Assists in new product development, implementation or enhancements.
Ongoing operational Sybase admin support for various applications
Sybase device and database performance and disk space allocation/ monitoring
Familiarity with DBArtsian for Sybase
Performs Disaster Recovery planning and testing.
Perform Sybase ASE 12.5.X Server installations, and version/patch upgrades
Experience, knowledge as SQL Server and/ or Oracle DBA is preferred.
On-call support as required (rotational)
Proactive attitude and passion for process improvement; scripting; issue resolution for internal and external customers
Able to take direction, switch priorities, and have tenacity to follow through on issues and see through resolution.
Reports to Team Leader on plans, projects, and problems.

Job Requirements
To perform this job successfully, an individual must be able to perform each essential duty. The requirements listed are representative of the knowledge, skill, and/or ability required
Experience with ASE performance tuning and monitoring.
Experience with Sybase ASE 12.X. and ASE 12.5.X versions and its new features

Education
Bachelor's Degree in Computer Science or equivalent. Minimum 4 years experience in data processing.


Job posting #2:
===============
SQL Server Database Administrator
Description
The database administrator for SQL Server ensures the control and security of data and efficient use of system resources. Provides technical assistance to users. Develops methods to improve operational and production functions.

Essential Duties and Responsibilities
SQL server replication – ongoing maintenance and setup for new servers as needed
As needed - SQL tuning advisory consulting and hand on trouble shooting for development team. Assists in new product development, implementation or enhancements.
Ongoing operational & development DBA support for various applications
Database performance and disk space allocation/ monitoring
Familiarity with DBArtsian, SQL Enterprise, etc.
Assists in the install of complex system software at client sites – as needed
Performs Disaster Recovery planning and testing.
Perform SQL 2000, 2005 SQL Server installations, and version/patch upgrades
Experience, knowledge as Sybase Server and/ or Oracle DBA is preferred.
Be able to travel (approx aggregated 1-3 weeks/ year)
On-call support as required (rotational)
Proactive attitude and passion for process improvement; scripting; issue resolution for internal and external customers
Able to take direction, switch priorities, and have tenacity to follow through on issues and see through resolution.
Reports to Team Leader on plans, projects, and problems.

Job Requirements
To perform this job successfully, an individual must be able to perform each essential duty. The requirements listed are representative of the knowledge, skill, and/or ability required
Experience with SQL Server performance tuning and monitoring.
Experience with SQL Server 2000, 2005 versions and its new features

Education
Bachelor's Degree in Computer Science or equivalent. Minimum 4 years experience in data processing.

Source: http://community.livejournal.com/sqlserver/49739.html

Date: 06/21/06 (SQL Server)    Keywords: database, sql, microsoft

Hi folks. Anyone know if TEXTCOPY is still a viable utility in SQL Server 2005?

I've just installed SQL Server 2005 for the first time and I'm trying to populate a database using the same scripts and batch files that work fine for me in SQL2K. The batch files I use to insert BLOB and CLOB data use TEXTCOPY...and fail. On searching the SQL2005 folder hierarchy, I see no evidence of TEXTCOPY at all. I've tried general Googling, but have found no explicit mention on SQL2005 and TEXTCOPY (on way or the other) and, of course, TEXTCOPY is an undocumented utility to begin with :)

UNDER SQL2K: c:\program files\microsoft sql server\mssql\binn\textcopy
UNDER SQL2005: ???

If TEXTCOPY is no more, perhaps someone can recommend an alternate straightforward method of populating BLOB/CLOB data in SQL2005?

Cheers.

Source: http://community.livejournal.com/sqlserver/50041.html