I just realized that I pasted the wrong section into my post.

This returns the same result as Brendt's DatePart/Cast example, but with less function calls:

SELECT CONVERT(varchar,GETDATE(),112)

print convert(varchar,@datetime,112)

Try running SET Quoted_Identifier ON before your declare.

I would start by defining exactly what permissions the application needs on the database.  To do this, you may have to get a few heads together as you will need...

It looks like you have a few posts out here that are very similar to this one, but with different error messages. 

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=283862

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=283864

Are you getting all three of these...

You say that your subtree cost is higher on your new server so you must have already looked at the exection plans.  Can you post the text version of your...

Yes, it is possible if you create your own transaction log backup job.  If you rely on maintenance plans, SQL Server will name your files for you.  Create your own...

Can you explain what you mean when you say 'construct user/system databases'?

If your data is on RAID 5 and you lose a data disk, you will be OK.  If you lose an OS disk with RAID 0, your application will go...

"How do I 'run' the command in @CmdStr"

You run the SQL code in @CmdStr just as Karl has shown.  sp_executeSQL is an extended stored procedure in the Master DB.  Look...

RAID 0 has no redundancy component.  If you loose a disk on your production server, your application goes down. 

I know from experience.  I have configured servers to use the /3GB switch without enabling AWE and have been able to verify, through monitoring the Total and Target Server Memory...

Just another thought, if you are running Windows Server 2000 Standard edition, you will not be able to use the /3GB switch either.

You do not need to enable AWE to use the /3GB switch.  If you only have 4GB of memory, AWE cannot be enabled. Also, once you have added the /3GB switch...

No, you cannot do what you are asking, but this link may be of interest to you depending on what types of processes you are trying to restrict.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=17677