Forum Replies Created

Viewing 15 posts - 3,346 through 3,360 (of 3,365 total)

  • RE: COMMIT in OPENXML????

    I am not sure because I think .NET XML classes are better but try this link read the article and click on figure one to fix your code.  Hope this...

  • RE: Collation

    Run a search for collation in the BOL(books online)  and you will get code to do per column collation for your langauges.  I  would also save the stored procs T-SQL as...

  • RE: Rethinking the RDBMS

    I don't know if this is relevant but in C# leaving flat file in memory for a long time comes out of the box, that is what was used to...

  • RE: My Biggest Gripe with the SSC Forums

    It is a known problem with web based editors the serialization is not stable. I use note pad to keep a copy until the post is live.  Hope this helps.

    Kind regards,

    Gift...

  • RE: rserroropeningconnection with oracle

    Irregular errors like this are usually Oracle TNS Names file related sometimes you can just copy your existing TNS Names file into note pad and delete and replace the existing file and...

  • RE: Month Chart

    Resporting Services in an Asp.net Application, if you create the charts in Excel  and save it, you can use the code in the link below to call your Excel file. ...

  • RE: Month Chart

    First OUTER JOIN default mathematically to a NULL so doing Time related calculations with OUTER JOIN is not a good idea.  Try these links to use Excel to create the chart...

  • RE: Using XP_smtp_sendmail with 64-bit SQL Server

    The question is your SQL Server Agent installed with a service account with enough permission to run SMTP?  Try the link below for more info.  I was a beta one...

  • RE: Renaming a table

    Next time look into ANSI SQL ALTER TABLE statement.  In the meantime try these links for good datagrid code the first link is two parts, but a datalist is more...

  • RE: SQL Server Agent Question

    The SQL Server Agent is useless on the local account and so many services depend on it.  In an Enterprise the SQL Server Agent needs a service Account with Domain...

  • RE: Transfer data from SQL Server 2000 to SQL Server 2000 continuosly

    You need DTS on xp_cmdshell with a scheduled Job it can run for four hours, the main requirement SQL Server Agent with Domain Admin permissions and the Server running all...

  • RE: MS SQL 2000 Query Analyzer and Full-Text Indexing Query?

    You cannot use ANSI SQL %LIKE% with FULL TEXT Index because your data is not table space based SQL Server creates an Arithmetic pointer to your data in the file...

  • RE: crazy requirements - SQL help..

    What you are trying to do is Time Interval Arithmetic, it is not implemented in SQL Server only Oracle and PostgreSQL have it implemented. But Microsoft have resources that can...

  • RE: importing xml file

    Try the link below for sample code using OPENXML and you can use both Excel and Word and save the file  as XML.   Hope this helps.

    http://msdn.microsoft.com/msdnmag/issues/05/06/DataPoints/default.aspx

    Kind regards,

    Gift Peddie

  • RE: 70-229 Exam

    Try this link 70-229 is one of the exams coverd, the site have linked all the requirements to MSDN tutorials.  Hope this helps.

    http://www.codeclinic.com/certification.htm

Viewing 15 posts - 3,346 through 3,360 (of 3,365 total)