Viewing 15 posts - 256 through 270 (of 692 total)
Is the schedule also enabled? Is SQL Agent running?
I have the same type situation with homegrown logshipping. I accomplish this by updating a "control" table on Server B when Job...
December 23, 2004 at 10:46 am
That really depends on how active the log is. For example, if you are taking transaction logs every 10-15 minutes, or are auditing successful logins, you might want to recycle...
December 23, 2004 at 10:42 am
You said the query for HugeDerivedTable has a parameter in it, which would seem to invalidate my suggestion. But, without knowing the parameter, and how it affects the derived table,...
December 23, 2004 at 10:24 am
Wow! Such kind words about the forum and no responses to your query for nearly 22 hours?!?! Well, it seems responses have slowed due to the holiday season. I know absolutely...
December 23, 2004 at 10:12 am
If you do that, you'll need to change to full recovery model, then take your full backup, so that your tlog backups can associate with the full backup.
Steve
December 22, 2004 at 1:00 pm
If you wish to continue to do the maintenance, it shouldn't be a problem to leave the file large, as long as you can accept the large log size. It...
December 21, 2004 at 1:23 pm
The only thing that jumps out at me is the periods in the group name. I know the spaces are ok, we have some like that. But maybe the periods...
December 17, 2004 at 2:38 pm
Well, lets see.
Assumptions -
The Windows Group has login rights to the server.
The ODBC connection is set up to use Integrated Security.
The Windows Group has been properly granted access to SQL...
December 17, 2004 at 1:14 pm
You could run into problems in a procedure that is performing inserts. If the column names aren't explicitly called out, all columns will be assumed, and your insert will fail.
Steve
December 15, 2004 at 3:59 pm
Yep. SQL Agent handles all the scheduling within SQL. It must be running for any automated job to execute via its schedule.
Steve
December 13, 2004 at 3:30 pm
I assume that you are trying to "open any table/view" from EM. Have you tried a select query from QA?
By the way, about the comma, I can't tell you how...
December 13, 2004 at 2:38 pm
If you pasted your restore command exactly as you were running it, your problem may be the missing comma at the end of the first move.
Steve
December 13, 2004 at 12:01 pm
Why????
As Tyson said, just multiply by -1.
positive values become negative ( 1 * -1 = -1).
negative values become positive (-1 * -1 = 1).
Thats what the original request was for!
No...
December 10, 2004 at 12:25 pm
Provided there is a share set up on the network resource, you can use the unc path. Again, using xp_cmdshell, execute the "DOS" copy command -
exec master..xp_cmdshell 'copy d:\test.txt
December 10, 2004 at 9:15 am
Please provide specific information about what you are trying to do.
Steve
December 9, 2004 at 3:11 pm
Viewing 15 posts - 256 through 270 (of 692 total)