Viewing 15 posts - 27,151 through 27,165 (of 39,961 total)
Which event is this? If you are grabbing stored procs, you'll get it. You can filter by database or user as well.
What does the proc do?
September 18, 2008 at 1:57 pm
Paul's got it. tempdb is recreated, might not have enough space for that on your system or even logging.
September 18, 2008 at 1:56 pm
Lots of VBScripting.
Transfers are always easier to one file name. You could use the Dynamic Properties task to alter the connection to the file to a different name based on...
September 18, 2008 at 1:54 pm
For multiple operators, I usually send to a general box somewhere and then let the email system either forward to multiple people or one.
September 18, 2008 at 1:52 pm
If you don't have SMS or MOM, then this is a pain. I might psexec it, logging the results to each server.
That or get a bunch of terminal server sessions...
September 18, 2008 at 1:51 pm
Definitely use SHRINKFILE, but be sure that you don't need that space. HAving the log shrink and grow is a waste of resources.
September 18, 2008 at 1:50 pm
I wrote about this some time ago for SQL 2000. Basically the file extended properties and the version in master could conceivably be different. I'd check both and that might...
September 18, 2008 at 1:50 pm
You should use ALTER INDEX with 2005 and above as DBCC REINDEX is deprecated.
I'm not sure what you can grab here, though checking @@ERROR and related variables after the command...
September 18, 2008 at 1:49 pm
I'd also recommend 37 Signals to check out. They have an interesting blog.
I heard Jason Fried speak recently and he talked a bit about how they build software and their...
September 18, 2008 at 1:43 pm
We definitely don't condone posting of braindumps or links to dumps. They are a form of cheating and not accepted for passing. Microsoft has sued companies providing them.
Similar questions from...
September 18, 2008 at 9:31 am
The training kit should give you an idea of the types of questions and perhaps someone will chime in.
Exact questions and potential answers, should not be posted as that violates...
September 18, 2008 at 9:30 am
September 18, 2008 at 9:10 am
Ewan,
The way ESX works is that it's like a cluster of VMWare hosts. The "floating" means that your VM could migrate to another physical machine, WHILE it's running, and without...
September 18, 2008 at 8:11 am
We plan to keep them here and Jumpstart as well. Jumpstart runs on advertising as does this site, so that's the cost.
Nothing is for free, or almost nothing. It just...
September 18, 2008 at 8:04 am
I'm honestly not sure what I want. There has to be a balance between too many meetings and too little information.
For the deployment guys (production, operations), going to a...
September 18, 2008 at 7:58 am
Viewing 15 posts - 27,151 through 27,165 (of 39,961 total)