We have set up a new system with Windows 2000 and MSSQL 2000. The system log in the Event Viewer reports the following error when the system is started after being set up i.e. moved, completely powered down:
2/19/2001 3:33:12 PM SQLSERVERAGENT Error Alert Engine 318 N/A SQL-SERVER Unable to...
I have produced many reports over the past several years for one of our clients. They reside on an NT 4.0 server. Most of the work stations have been Windows 95 until recently when they were all replaced with NT 4.0 Workstations. Not all reports have yet been run under the new setup. One of...
I used your first method on a test script (I had been trying it this way but didn't get it quite right) and it worked. Thanks a lot for your help.
Dennis
I thought of that but I believe that would require that I break it up into a stored procedure for each database as USE cannot be used in a stored procedure. Then I need to merge data from 4 databases into 1 after processing in each.
Dennis
I have a lengthy SQL script that creates several tables in several databases and culminates in a single table for use in a Crystal report. It runs nicely in isql. Is there a way that I can run this script as a scheduled task? It is way larger than the 255 character limit for TSQL in Scheduled...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.