User Profile

Collapse

Profile Sidebar

Collapse
eflatunn
eflatunn
Last Activity: Sep 27 '07, 07:12 AM
Joined: May 7 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • eflatunn
    started a topic Turkish character problem in stored procedure

    Turkish character problem in stored procedure

    Hi all,

    I use a stored procedure to insert values. But turkish characters are not inserted correctly.
    Collation of the database is true (Turkish_CI_AS) . Anyway there is no problem when I run the same insert script on SQL Query Analyzer.

    I would be grateful if someone can help me...
    See more | Go to post

  • eflatunn
    replied to Automatic Database Backup
    I included SQL-DMO library in my application. Using SQL-DMO objects, I create a job in SQL Server Agent and assign a schedule so that back up can be done periodically.
    See more | Go to post

    Leave a comment:


  • Thank you for your advice. I already tried this but it didn't help. But my problem is solved:) (I don't know how) I just wrote the SProc all over from the beginning....
    See more | Go to post

    Leave a comment:


  • Write a Script as Varchar Parameter in Stored Procedure

    Hi all,

    I paid 3 hours for it but couldn't get succeed.
    I'm writing a stored procedure to get a data entry in a table. The problem is that I can't simply use commands "SELECT" or "CASE" directy. First I have to declare a varchar parameter and put all of this in this parameter. (The reason is that the stored procedure is not unique for a table. Year and month, which are parts of the table name are also parameters...
    See more | Go to post

  • eflatunn
    replied to Automatic Database Backup
    Thank you. But, what I want to do is to realize it programmaticall y. I don't want that the user has to set up anything in Enterprise Manager. All the back up procedure must be organized during the installation of my application program.

    An idea is to define a scheduled job on server agent by using SQL-DMO library. So, the job will back up the database periodically. But I am not sure if it is the best choice.
    Any other ide...
    See more | Go to post

    Leave a comment:


  • eflatunn
    started a topic Automatic Database Backup

    Automatic Database Backup

    Hi all,

    I have written an application in C# .NET which will run on another PC. The database required for the application will be created during the installation. How can I provide that the application backups the database periodically? Can I generate an SQL script which will run at installation and then backup the database automatically?

    I really need advices.
    Thank you...
    Burcu
    See more | Go to post

  • I think you can use remoting if you won't have many clients.
    See more | Go to post

    Leave a comment:


  • eflatunn
    replied to C#, Application does not terminate
    in .NET
    Thank you george, but it is exactly what I do.
    It works on my computer. But a thread continues working when I test my application on another computer. There is no .NET framework on that computer. But I put the framework in setup project. May the problem depends on it ??

    Thank you kenobewan. But I don't see the point in using application unload event. Can yo explain it please?
    See more | Go to post

    Leave a comment:


  • eflatunn
    started a topic C#, Application does not terminate
    in .NET

    C#, Application does not terminate

    Hi all,

    my problem is that the application doesn't terminate when I close the form using the close box on the caption bar. Actually it seems as if the program is closed but task manager's process list shows that it is not.
    There is one thread that I manully create and start in forms load event. But I set the IsBackground property of the thread to true. So, it should terminate while exiting the application.
    There are...
    See more | Go to post
No activity results to display
Show More
Working...