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 strongm 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: *

  1. dafdba

    Using Bulk Insert without administrator privileges

    We have an application running on SQL Server 2000 where all users occasionally have to run a stored procedure which does a bulk insert from a text-file. According to Microsoft article Q302621(http://support.microsoft.com/default.aspx?scid=%2fservicedesks%2fbin%2fkbsearch.asp%3fArticle%3d302621)...
  2. dafdba

    Best way to grant create table permissions in sp

    If an object which is called by a stored procedure, not exists at the moment the stored procedure is created, this object wil not be added in the sysdepends table. In that case you won't have permissions on that object when you run the stored procedure.
  3. dafdba

    restoring master db on Clusted SQL Server

    I think you should stop the SQL Server cluster resource (unmark the restart option to prevent a switch of nodes when you stop SQL Server) and stop the SQL Server service on the active node. Now it should be possible to start SQL Server on the active node in single user mode and restore the...
  4. dafdba

    Best way to grant create table permissions in sp

    Just give the user permissions to execute the stored procedure. It is not necessary to give separate permissions to create and drop temp tables within that stored procedure.
  5. dafdba

    Setting up a Proxy account

    You can set the proxy account in the Enterprise Manager in the properties of SQL Server Agent (under Management) under the Job System tab. Unmark the "Only users with sysadmin..." under Non-SysAdmin job step proxy account. You will get a box to fill in a Username and password. You must...
  6. dafdba

    Stored Procedure Calling Batch File

    You can use the extended stored procedure xp_cmdshell in the master database for this.
  7. dafdba

    LINKING A SYBASE DATABASE ON MS SQL SERVER

    Create a ODBC link (System DSN) to the Sybase database on the server where SQL server runs. Create a linked server within SQL server (Enterprise Manager: Server -> Security -> Linked Servers -> Linked server) which points to this ODBC. General tab: Linked server: <name you want to use to call...
  8. dafdba

    DBBACKUP does not work from scheduler

    The script is running on the same server as the instance is running
  9. dafdba

    DBBACKUP does not work from scheduler

    I created a script which makes an online backup of a SQL Anywhere 5.5 database on a Windows NT4.0 server. This script runs fine when it's started from the commandline on the server. When I start the script from the scheduler AND nobody is logged on to the server it fails with the error message...
  10. dafdba

    Executing a DTS from a stored procedure

    You can schedule the DTS-job and remove the schedule from the job in SQL Server Agent. From the stored procedure you start the job using sp_start_job. You need to have the public role of the msdb database to do this.

Part and Inventory Search

Back
Top