Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: KRISF
  • Order by date
  1. KRISF

    Automation of SQL Scripts

    Depending on the version of SQL Server, you can use SQL-DMO to schedule it see http://www.swynk.com/sqlscripts/misc7.asp (sp_createscriptjobsjob.sql)
  2. KRISF

    Loss of SQL Server Services

    Definitely the NT and SQL Server logs are the place to start. If you can use SQL Profiler, it can become an invaluable tool for detecting errors.
  3. KRISF

    It seems that no people know about analysis Services

    My company uses the Analysis Server to a large degree. I find many useful examples and code with SQL Server Magazine (http://www.sqlmag.com)
  4. KRISF

    SQL Sever log file

    If the database is non-essential - set the database to truncate the log on checkpoint. This will keep the log very small if your transactions are small.
  5. KRISF

    Exporting columns in a text file with a precise layout.

    Use the CHAR data type to enforce the specific sizes and use BCP to export it. Very quick and no concatenation required.
  6. KRISF

    another question about stored procedures!!

    By default, SQL Server will insert all records or nothing. SQL Server will create an implicit transaction for the procedure and if there is an error on the second to last record - the entire transaction will be rolled back (which can be problematic). If you want those records that can be...
  7. KRISF

    searching for CR or LF ot TAB

    CHARINDEX will also work.
  8. KRISF

    Arithmetic overflow error converting expression to data type float.

    Good comment. If that does not fix it, the SET command can be used to prevent the stored procedure from bombing.
  9. KRISF

    Displaying table column name and description only

    sp_help is the best. Micorsoft does not recommend referenceing the sys tables. Instead use any of the INFORMATION_SCHEMA views for this purpse.
  10. KRISF

    delete all records from a table?

    Make sure you do not have a 'set rowcount 10000' or jsut issue a 'set rowcount 0' at the beginning of the stored procedure.
  11. KRISF

    Repopulating a table without dropping & recreating it ??

    Using DTS's Data Driven Query Task, the logic of UPDATE or INSERT could be contained (if you are more familiar with DTS). Otherwise a custom solution could be made with a stored procedure that does the UPDATE or INSERT depending on presense of a key value. The DTS Wizard does not have this...

Part and Inventory Search

Back
Top