User Profile

Collapse

Profile Sidebar

Collapse
vecs
vecs
Last Activity: Aug 7 '09, 06:19 AM
Joined: Apr 13 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • vecs
    replied to determining if an SQL database exists, etc.
    in SQL Server
    List all accessible databases on server:
    Code:
    EXEC master..sp_databases
    List all system tables, tables, views in current database:
    Code:
    EXEC sp_tables
    List all tables with given name in specific database:
    Code:
    USE [I]database_name[/I]
EXEC sp_tables @table_name = '_user'
    See more | Go to post

      Leave a comment:

    • vecs
      replied to Working with word documents in asp.net
      in ASP .NET
      Yes of course. Office automation highly not recommended on server side. So I suggest to reject .DOT templates and use alternative ways. But I can tolerate this in some cases (small-sized intranet WEB-applications, with reports richer than simple RTF).
      Here you can find official comprehensive information about the subject on Microsoft KB....
      See more | Go to post

        Leave a comment:

      • vecs
        replied to Working with word documents in asp.net
        in ASP .NET
        The only way to work with .DOT files is to use MS Word automation via COM Interop.
        However, it is not good idea to use Word automation on server-side especially when server may have many simultaneous calls to Word.
        Alternative ways:
        * Generate RTF files instead of .DOC (see this article for example).
        * Generate .DOCX files (see this article for example). But this forced users to use Word 2007 to open this files.
        ...
        See more | Go to post

          Leave a comment:

        No activity results to display
        Show More
        Working...