SQL 2000 and 2005 can run side by side. And Management Studio will work on a 2000 Database server, meaning that you can use it. When you installed...

winnri -- are you still having the problem? What i was trying explain is that, if you create a 2005 database named XYZ as 2005, and then attempt to...

James -- Just wanted to add more clarity. xp_cmshell is used by TSQL to execute OS level commands. An example is in a stored procedure, it is executed...

Not sure if you have you answer yet; But from readin the thread it sounds like this is you problem:

If you have a 2000 database you cannot restore a...

Without getting into the race issue, this is a problem and as stated earlier, why salaries are not discussed.  As a Director of Software Development, this was an issue that I...

just thought i'd follow up.  running the package using 32 bit dtexec does work.  but remember that you also have to set the package to 32 bit also.

Here's how:  in...

thanks.  as soon as clicked send i knew where it was.  Kinda' when you lock you keys in the car.  As soon as you hear the door close ... 

laker_42:  I've having the same problem as you with the 64 bit.  Where do i find the 32 bit dtexec?  Anyone???

to answer questions from 'chess' questions 1 and 2 kinda go together 

1) & 2) checking replication:  here are some of the jobs that may get created, listed in no specific...

There are also some tools out there that will monitor the database server.  Lugiment is one that comes to mind.  It can send emails when an event occurs.

is this an on location job.  I have SQL DBA experience as well a powerbuilder.  I was the DBA and Software Dev mgr for a large home healthcare org for...

I've always done more than just DBA.  At my last job, I was there for 11 years, I was the Software Development Manager, I did application as well as database...

John -- your explanation is the same conclusion that I came to.  Even though the MS docs state that if you have under 4G of Ram that AWE / PAE...

this is a dedicated SQL box.  No other applications. Since the box is running correctly, I will just keep searching.  Maybe it has something to do with grabbing the memory...

ok i had already read that article, but i re-read again.  and based on it i do not need AWE.  let me say again that the server is working fine,...