SQLBOT (11/19/2008)

---

I've dabbled a bit with SB from a custom maintenance job perspective and might have some insight.

What you can do is set up a queue on each server and...

Here are the steps that worked (finally) for me:

Login as 'sa' on your local sql 2005 server.

Create a new database

In a new query window, run this script: ALTER DATABASE...

Here are the steps that worked (finally) for me:

Login as 'sa' on your local sql 2005 server.

Create a new database

In a new query window, run this script: ALTER DATABASE...

Steve Jones - Editor (11/17/2008)

---

Marios,

What are you trying to do? They usually perform separate actions, but if you are looking to just update another server, I might recommend looking at...

I'm not an expert on RAID configurations, but RAID 5 is the bare minimum and should be avoided if you can help it.

Here is my 0.2 c on the file...

I have heard that Microsoft does not officially support virtualized SQL Server installations. This might be a huge problem if one requires support for an emergency in the production environment.

That...

How do you disable the jobs, through the SSMS UI or through script?

If through script, you must use the msdb proc sp_update_job:

HarryH (11/14/2008)

---

I appreciate the detailed reply, Marios. You certainly seem to understand the position I am in - looking at SCOM with a view to using it for some useful...

Loner (11/13/2008)

---

It is a network account and it can access the file when I sign on using that account. But when I put it in the job and it...

Jonathan Kehayias (11/13/2008)

---

Post the value of SELECT @@VERSION, as well as the output of DBCC MEMORYSTATUS into this thread. Also what is the physical hardware configuration of the server...

Sorry guys, wasn't able to get back to this sooner.

The full error is the following:

Msg 10314, Level 16, State 11, Line 3

An error occurred in the Microsoft .NET Framework while...

HarryH (11/13/2008)

---

I'm not convinced how truly practical or useful this really is...

I haven't used SCOM in anger yet, but have been thrown it by my manager to take a...

Loner (11/13/2008)

---

I created a SSIS package to import data from a CSV file from a different server and when I ran it in SSIS, it was fine.

The file location is...

schep021 (11/13/2008)

---

Good morning. We have a request from a user to upgrade ONLY Analysis Services from sql server 2000 to 2005 and leave the rest running in 2000. ...

Would moving a database from a SQL 2000 to a SQL 2005 instance, while keeping it at comp. level 80, incur a performance hit (relative to its performance in the...