I can't start the SQL Server Agent, and I get the following error message:
18456, Login failed for user
Unable to connect to server; SQL Server Agent cannot start
How can I solve this problem?
This error message usually means that you need to update the password in the SQL Server Agent service account. Go to the Control Panel, select Services, and double-click the SQL Server Agent Service. Change the SQL Agent user account password to the current password. Then you can start the service.
I want to call a stored procedure in a SELECT statement in SQL Server 7.0, Service Pack 1 (SP1). I tried doing so in the following statement
SELECT inv_no,inv_date, @inv_fin_year = sp_FinYear(inv_no) FROM inv_master
where sp_FinyYear is a stored procedure with a parameter. An error occurred while the procedure was executing. How can I create a user-defined function in SQL Server 7.0? And, how can I call a stored procedure in a SELECT statement?
You can't call a stored procedure in a SELECT statement or create user-defined functions in SQL Server 7.0. However, Microsoft plans to address both functionalities by implementing user-defined functions in a future release.
I need to upgrade a few hundred SQL Servers, and I don't think using the SQL Server 7.0 Upgrade Wizard is realistic. Can I extract the Upgrade Wizard's components for setup to run in an unattended mode, similarly to the way that I can perform the installation process unattended?
No, Microsoft doesn't support a way to break out the components of the Upgrade Wizard.
My SQL Server 7.0 database is a copy of the production database that I keep for testing and simulating problems that users report. I don't want a transaction log for the test database because some of the operations have too many data updates and the transaction log grows to an unmanageable size. How can I stop the server from logging transactions for the test database?
You can't turn off logging in SQL Server 7.0, but you can set the database options Trunc log on chkpt, which will truncate the log periodically, and Select into bulkcopy, which will allow some operations not to be logged.