Viewing 15 posts - 7,576 through 7,590 (of 7,635 total)
High Page Fault/sec with no Pages/Sec just means that you are getting a lot of Soft Faults; that is, that the page faults are being satisfied with pages already in...
March 11, 2008 at 8:59 pm
Actually, you can use variables as parameters to [font="Courier New"]sp_AddLogin()[/font].
Sorry, I keep remembering additional details...
March 10, 2008 at 9:57 pm
M.van Leewen (3/10/2008)
Hi Barry,The recovery model is already set to simple. Do you have additional options in mind?
Menno
Nope. That was it.
March 10, 2008 at 8:56 pm
Alter Database [FUBAR ] Set Recovery Simple
...
Alter Database [FUBAR ] Set Recovery Full
Note: As Adam was saying, use with caution! You can easily shoot yourself in the foot...
March 10, 2008 at 7:12 pm
Jeff Moden (3/10/2008)
March 10, 2008 at 7:00 pm
Glad I could help.
(sorry, don't know about your other question)
March 10, 2008 at 6:44 pm
Does this command give you any messages?
Backup Log [A64-Prod] With Truncate_Only
March 10, 2008 at 6:40 pm
Is that possibly backwards?!?
March 10, 2008 at 6:25 pm
No, just add that Windows Account as a Login on your SQL server.
March 10, 2008 at 6:16 pm
Jeff Moden (3/10/2008)
Problem is... most people give up on trying to find a good set-based solution way too early...
Amen to that, Brother.
March 10, 2008 at 5:58 pm
Lynn Pettis (3/10/2008)
Cursors may be evil, but they may be a necessary evil...
In my experience they are necessary and acceptable for only one thing: variable-izing SQL objects in the repeated...
March 10, 2008 at 5:55 pm
How much data is it and how is it being "pulled over the network"?
Also, what is your network config?
March 10, 2008 at 5:35 pm
Glad I could help.
March 10, 2008 at 5:21 pm
Just add the app login in as a specific Widnows login. Then authorize it in SQL server for what it needs.
March 10, 2008 at 5:20 pm
Viewing 15 posts - 7,576 through 7,590 (of 7,635 total)