Viewing 15 posts - 121 through 135 (of 219 total)
fminns-1058143 (4/28/2010)
I recently set up log shipping (SQL 2005), and so have a readonly/standby database that the logs are being shipped to. The...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 28, 2010 at 9:11 am
sunshine-587009 (4/28/2010)
It works through a command prompt from my desktop. i'm sure it will not have a problem on the server.
It does not matter that you can run it from...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 28, 2010 at 9:01 am
xp_cmdshell runs on the server, not on the client. Try to run whatever your running on the server, through a command prompt, then you will see what is happening.
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 28, 2010 at 8:53 am
sunshine-587009 (4/28/2010)
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 28, 2010 at 8:45 am
Grant Fritchey (4/28/2010)
NOLOCK hints can cause you to get erroneous data. Not only will you see columns that have been changed but not yet committed within a transaction, but...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 28, 2010 at 6:57 am
Not sure if this is what you mean, but if you use the nolock hint (look it up in BOL), it will prevent locking from happening
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 27, 2010 at 11:31 am
jcrawf02 (4/21/2010)
GregoryF: "don't worry about not knowing how many instances/servers there are, every where I have ever worked, no one know all of them, there are some that are barely...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 21, 2010 at 9:25 pm
WayneS (4/21/2010)
GregoryF (4/21/2010)
Me, and many of my friends do spend a few hours surfing the web during the day.
Then, to kill the time surf the web.
Might I suggest instead of...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 21, 2010 at 6:51 pm
SQL 2000 does not have that functionality
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 21, 2010 at 6:47 pm
In SQL 7 or 2000 the only way to do it would be to:
1) Create a new table with [table_name], [last_update], [last_insert], [last_delete]
2) Create a trigger on the source tableto...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 21, 2010 at 6:22 pm
Me, and many of my friends do spend a few hours surfing the web during the day.
When that get's boring, I do thing like admin scripts (you learn alot about...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 21, 2010 at 4:57 pm
A couple of questions
1) Why would you want to backup the sa password? If something went wrong, why would you just not change it back?
2) If something we wrong...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 21, 2010 at 4:32 pm
Dan Fran (4/21/2010)
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 21, 2010 at 4:27 pm
Toby White (4/21/2010)
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 21, 2010 at 4:23 pm
Jeff Moden (4/21/2010)
Lynn Pettis (4/21/2010)
Toby White (4/21/2010)
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 21, 2010 at 4:15 pm
Viewing 15 posts - 121 through 135 (of 219 total)