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 Rhinorhino 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: glewc
  • Order by date
  1. glewc

    SQL7 DTS package does not run in SQL2000

    I discovered that problem was that although I had installed SQL2000 on the server I had not installed any service bug and there was a bug which was resolved by SP1. Once I installed the SP then I was able to resave the package using 2000 tools (and adding an owner password) and reschedule it...
  2. glewc

    SQL7 DTS package does not run in SQL2000

    Since installing a SQL2000 instance and client tools on my server I am having problems running a DTS package on the SQL7 instance. The package runs fine when from my PC, from the command prompt on the server or using xp_cmdshell in Query Analyser. The scheduled job does nothing and returns...
  3. glewc

    How to Upgrade 7.0 Enterprice Manager to 2K ?

    You need to install the SQL2000 client tools on the server
  4. glewc

    Logins default database

    A user was getting an error 'login failed' it turned out that for the login she was using the 'default database' column was blank and this turned out to have been caused by the copy database wizard when it had detached this database temporarily when making a copy of it. Has anyone else ever...
  5. glewc

    Append sql result to a mail

    Could you store the result in a table on the database and then send it using xp_sendmail with the @query parameter = select * from table
  6. glewc

    @@servername returns NULL

    I have had this problem where a server had somehow 'lost' its @@servername, but I found that running 'sp_addserver 'pro26', local' and restarting SQL server resolved the problem
  7. glewc

    automation of a query and output the query to a file

    You need to execute master.dbo.xp_cmdshell
  8. glewc

    restore the database

    Hi, Your problem is that you are creating the database first before restoring it and you cannot restore directly from SQL7 to SQL2000. I assume you have got the SQL7 .bak file on the server somewhere, what you need to do is in Enterprise Manager, right click on databases, all tasks, restore...

Part and Inventory Search

Back
Top