We have currently 2 copies of a database on the same server. We want to copy the jobs so that they run for both. The reason for this is that we are...
We have files on the AS400 that are named as atl0107, atl1206 and etc. We need to be able to retrieve the appropriate file to be ran in a stored...
We do not know when or how it happened but we can not see the subscription information for our reports. We need to change these. Also, it does not...
I have a Visual Basic ActiveX Script that keeps timing out. This is in a DTS package that only contains the ActiveX.<br /><br />We are using MS SQL...
We have a file on our AS400 - DB2 that is named accordingly: skmb1006 - the name is made up of skmb + mm + yy I have created a link to the folder...
Each month a file is created that contains the date at the end of the file. I would like to create a stored procedure that would obtain the correct...
I have a file created as tab delimited that I need to copy to another non SQL server. Any suggestions on how to do this. Both servers have Windows...
We are running MSSQL 2000 and every so often we get the following when running jobs: Executed as user: MANSFIELDPVSQL. OLE DB provider 'MSDASQL'...
I am working with SQL 2000 and am trying to update a table according to certain criteria. The error I am getting with using the CASE is: Server: Msg...
I have a SQL I need to automate. The problem is that a table I need is already linked for other purposes. The table GLPERIODS is used for...
I would like to either automatically rename or create a table. However there is a little hitch. I want the name to contain the current date in it....
The DBA that originally setup our database/stored procedures/Views, has been gone since November. I was hired in June as the new DBA. We are using...
I am new to SQL Server and working as the company's DBA. The databases that are being used need to be taken down and restarted several times a day....
Separate names with a comma.
