Michael Valentine Jones (2/11/2010)

---

As other people have suggested, you would be better off using a datetime column.

This will verify the correct format and ensure that it is a valid date.

ALTER...

CirquedeSQLeil (2/11/2010)

---

I would not update maintenance plans, that belong to a 2005 instance, from SSMS 2008. An upgrade to the maintenance plan may be attempted. Otherwise, I use...

That list will only show you backups for that database that were performed on that instance. Since the backup you are looking for was not performed on that instance,...

See if this helps...

Declare @curYearStart datetime

,@prevYearStart datetime;

Set @curYearStart = dateadd(year, datediff(year, 0, getdate()), 0);

Set...

I have no idea what DPM is or how it is configured or set up. You probably should ask the vendor of that tool how it works.

In addition to the other posts, if you cannot use a datetime data type and absolutely must use a string data type, you should be using a unambiguous date. ...

On my system, the db_datareader role is owned by 'dbo'. Is this not the same on your system? If not, somebody changed it because all of the built in roles...

That really depends upon how they are connecting to the system. If they are using SSMS, you might need to change their default database.

I personally don't think it is...

I have not found a reason yet to create a schema that was not owned by dbo. Not to say that there isn't one, but I just have not...

Yes, you can upgrade to Enterprise Edition but you have to purchase new licenses. Enterprise Edition processor licenses are ~$20,000 per socket. A system with 4 quad core...

If you have defined 1.5GB of memory for each instance as the max memory, that is not the max memory that SQL Server will use. There is an additional...

If you have not defined any permissions or assigned any securables to the role - then the user will not have any permissions.

Just creating a role does not confer permissions...

I am not seeing this behavior on my test system.

What is the default schema for the user in that database?

What principal owns the developer schema?

My gut feeling is that you...

Review these articles:

http://blogs.msdn.com/sqlserverfaq/archive/2009/04/28/is-sqlvdi-dll-functioning-properly.aspx

http://support.microsoft.com/default.aspx?scid=kb;EN-US;934396

Are you backing up across the network? If so, you need to make sure your network is capable of supporting SQL Server backups across the network. ...

SQL Server 2005 Standard Edition only supports two nodes in a cluster - and I am not sure if that means it won't work.

However, I don't think you need to...