Answers above are correct unless Helen is asking about Scheduled Tasks. I too would like to know how to move Scheduled Tasks from Server to Server including schedules and executables...

If I would not be MCDBA on 2000, then I would just pass 1 exam: 70-228, SQL Server 2000 Administration (the official exam title is longer). With this certification you may...

Some (not all) recommendations:

1 You may save packages as Visual basic files and search for the production server string if it completely absent. There will be text like this:

oConnection.ConnectionProperties("Data Source")...

You may use xp_cmdshell or use Execute Process task.

I would use PATINDEX and SUBSTRING functions to isolate the strings and then group by your numbers. PATINDEX shows the first position of the character in the string.

For example,

select patindex('%.%','ctim=0.0.0.12888&track=5')

will...

We had some problems when creating ActiveX script jobs. What we did is to save a script as a file with extension vbs (like mysript.vbs) and then create a job...

did you try sp_msforeachtable with truncate table statement? Additionally, in the previous post of JG the type should be U, not P

oops... knew the answer but got distracted by the tables A and B positions and accidentally clicked the correct position but the wrong operator.

Dan,

I would like to see if the server is installed in accordance with the purchased license. In our place we have internal/external software audits. Also, I need to make sure that...

It is OK to do new things not on the first try. I had a blue screen with STOP error myself the first time I tried.

Hi,

I did not try it myself, but did you follow the example in

http://msdn2.microsoft.com/en-us/library/ms186329.aspx

It says in the middle after the first example:

To test for updates that affect columns other...

Hello,

I  don't see anything wrong with the cursors when you have to access the previous /current/next record. The performance issues may be also if you put too much processing into...

You may order by your fields, output into temp table with Identity property:

create table ##Ranked ( Rank int  IDENTITY, Customer int NOT NULL,SortStart int NOT NULL, SortEnd int NOT NULL)

GO

Insert...

You don't need Visual Studio for installing SQL Server 2005. It installs some components of Visual Studio 2005: Analysys Services, Integration Services and Reporting Services projects.

Log files are just text files. Try to connect by mapping a drive from your computer and browse to the directory where the logs are.