SQL Server Performance

Search Results

Search Again
  1. rgregor6

    XP_FILEEXIST Help !!!

    Thread by: rgregor6, Aug 5, 2005, 4 replies, in forum: T-SQL Performance Tuning for Developers
    Hi,<br /><br />I have been trying to use XP_FILEEXIST to determine if a directory exists. I know I can run it against a file i.e (exec xp_fileexist...
  2. rgregor6

    TSQL User Input

    Thread by: rgregor6, Jul 14, 2005, 4 replies, in forum: T-SQL Performance Tuning for Developers
    When running a TSQL file is there any way of requesting the user to enter a value for a variable ?
  3. rgregor6

    Relocate Entire Instance

    Thread by: rgregor6, Jun 23, 2005, 7 replies, in forum: General DBA Questions
    Hi, I have just installed SQL Server 2000 and the default database directory is "c:sqldatafilessystemMSSQLdata". Is there an easy way to move the...
  4. rgregor6

    sp_changedbowner Advice

    Thread by: rgregor6, Nov 30, 2004, 4 replies, in forum: General DBA Questions
    Hi, Some databases that I support have owner of the user that created them originally instead of sa. These databases are production and have...
Showing results 1 to 4 of 4
Search Again