Viewing 15 posts - 2,821 through 2,835 (of 3,232 total)
Try running SET Quoted_Identifier ON before your declare.
May 31, 2006 at 9:44 am
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...
May 31, 2006 at 9:32 am
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...
May 31, 2006 at 9:21 am
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...
May 31, 2006 at 9:05 am
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...
May 31, 2006 at 8:56 am
Can you explain what you mean when you say 'construct user/system databases'?
May 30, 2006 at 2:31 pm
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...
May 30, 2006 at 2:14 pm
"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...
May 30, 2006 at 2:10 pm
RAID 0 has no redundancy component. If you loose a disk on your production server, your application goes down.
May 30, 2006 at 2:03 pm
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...
May 25, 2006 at 3:50 pm
Just another thought, if you are running Windows Server 2000 Standard edition, you will not be able to use the /3GB switch either.
May 25, 2006 at 3:10 pm
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...
May 25, 2006 at 3:08 pm
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
May 25, 2006 at 11:05 am
Run_value is your current setting. When you change a configuration setting, it shows up under config_value. At that point, run_value and config_value would hold different values. When the new setting...
May 25, 2006 at 10:32 am
Viewing 15 posts - 2,821 through 2,835 (of 3,232 total)